|
|
 |
|
|
|
|
|
Descrtiption : This tutorial is about Worksheet Plugin from http://www.swish-shop.com
Using this plugin you can do the following:
- Custom worksheets coulumns and rows
- Custom Cells style and color
- Custom column/row width and height
- Custom Title of Sheet
- Custom Text in cells
- Custom Html tags in each cell
- Unlimited number of Rows and Columns
- Create your own Downlaod Center
- Create User Rating System
- Create anytype of Statistics
- Encapsulate sheets into eachother
- Customize External text filename to be loaded
- Most Advanced Drag is automatically enabled for each sheet
- Auto SWAP while Dragging the sheets
How to Customize?
Open SWI simple simple-worksheet.swi.
You will see an sprite named "simple".
It means your sheet will be loaded from "simple.txt".
Open the sprite. It contains four sub sprites in it. named as
border
Load
cells
title
border contains an unfilled rectangle for border of your sheet. You can change its color. Load is the sprite which loads the plugin. Sprite cells cintains further sub sprite named "pCell". If you want to set custom width and height of sheet cells, you will resize this sprite, by selecting it and changing values from its "Transform" tab in properties. And if you want to chnge color of cells, open it and change the fill color and border of the rectangle in it.
How to Define Data?
for example you are creating 2 colums and 3 rows sheet.
open new file and save it as name of parent sprite + .txt (as example contains one).
define columns and rows first
&col=2&row=3
then define title of table by adding &title=
&col=2&row=3&title=My Table
Now define the data by adding &data=
Remember if you enter data more than columns that is fine, but if that is less than the columns, your wheet wont work.
Tip:multiply the columns and rows which becomes 6. So add 6 data items by seperating them using ',' like this:
&data=item1,item2,item3,item4,item5,last
the pure string for your sheet file is
&col=2&row=3&title=My Table&data=item1,item2,item3,item4,item5,last[/green]
adding each item of sheet from left to right.
But how to decide either file is loaded or not. So you will have to put a check in the end of file like this
&done=1
So your final sheet file is
[color=red]&col=2&row=3&title=My Table&data=item1,item2,item3,item4,item5,last
Screenshot URL
http://www.swish-db.com/
Download if you are member
http://www.swish-db.com/Board/files.php?ac...=category&id=49
A supporting Windows Application named DB WorkSheet Manager is almost finished. Which will give you a best environment to create your sheets.
I will post a reply in this topic when released
Screenshot of DB Worksheet Manager
I hope it will help all the users..
regards
Ali Imran.
|
|
|
|
