Welcome to the Kc SpreadSheet help file, pick from the following topics to get help on.

Menus
Toolbar
Sizing Cells
Moving the spread sheet
Modify Cells
Scripting

There arent to many menus in Kc SpreadSheet, but lets explain what each one contains.

File
Features
Help

The toolbar only has a few buttons, so lets go over them.

1 - New - This starts a new spread sheet, it will confirm if you want to first so you dont overwrite any data on accident.

2 - Open - Will let you choose a file to open, will cofirm if you wish to do so, so you dont overwrite any data on accident.

3 - Save - Will save the file you currently have open, will not ask if you want to or not.

4 - Export as HTML - Will create an HTML file of the table currently on the spreadsheet. (Colors included)

5 - Help - Will open this helpfile.

Sizing cells in Kc SpreadSheet is extremely simple. To size a cell, simply click the border after the cell you want to size, for further example refer to image below.

Modifying cells is quite easy.

The aspects of a cell you can modify is the border color, the text color, the back color, and the text that is displayed. To get to the dialog that lets you edit all of these aspects you must double click on the cell you wish to edit, and then a dialog like this will appear

When that appears, to edit the colors listed click on the box that holds its color and a color dialog will appear, select a color from it and press ok to save the color.

To save all changes made to the cell you MUST press save, cancel will cancel all changes you were going to make to the cell. Exiting out of the window through the X button will also cancel changes, so you must press save if you want any changes to happen.

Scripting is the most advanced thing Kc SpreadSheet can do, it's also quite handy and makes it very useful in many applications.

To do scripting you must know how to modify a cells content.

To define a cell as a cell that has a script in it you must make the first character of the cell a "$" (dollar sign). After that you put whatever formula you want, and whatever it equals out to thats what you will see in the cell.

Kc SpreadSheet currently accepts the math operators, - (minus sign), + (addition sign), * (multiplication sign), / (divide sign), and the ( )'s (parantheses).

So an example script so far would be

$1+(2/5*3)-3

which would look like in the edit window

would look like this in the spreadsheet

But how do you throw in expressions from other cells? To throw in numbers from other cells you simply take the cell's x value and y value and put it like so: [x,y]. An example would be we wanted to display in cell 1,1 whats in cell 2,2, heres the script for cell 1,1

$[2,2]

That simple.

For advanced users heres functions you can use:

int( a ) - Returns the integer of a
abs( a ) - Returns the absolute value of a
sin( a ) - Returns the sine value of a
cos( a ) - Returns the cosine value of a
tan( a ) - Returns the tangent value of a
acs( a ) - Returns the arc cosine value of a
asn( a ) - Returns the arc sine value of a
atn( a ) - Returns the arc tangent value of a
log( a ) - Returns the logarithm of a
max( a , b) - Returns the biggest of a and b
min( a , b) - Returns the smallest of a and b
mod( a , b) - Returns the remainder of a/b
rnd( a ) - Returns a random number (0-a)
sqrt( a ) - Returns the sqaure root of a
power( a , b) - Returns a^b

Example of some being used

$min((int(rnd(1)*100)+1),50)

It will return 50 if the random number (0-100) is bigger than 50 and will return the random number if it is lower than 50.