Edit Interface  
Fig. 1: Blank spreadsheet

Editing content of a cell  
To edit the content of a cell:

Modify the Spreadsheet Structure  
Fig. 2: Insert row form
Fig. 3: Insert column form
Columns and rows can be removed one at a time using the "Remove Row" and "Remove Column" options (see Fig. 4 and Fig. 5) Fig. 4: Remove row form
Fig. 5: Remove column form
When the calculation is being copied, the references to other cells are modified to suit the new location. In the example above, the row numbers would increment on every row. Elements in the calculation can be made static. For more information about calculations, see the section on "Calculations and Formulas". Fig. 6: Copy calculation form
Fig. 7: Format cells form

Calculations and Formulas  
Note:_ Entering a formula directly into the cell will not work. You need to enter the formula in the text bar located at the top of the spreadsheet (the one that displays the content of the currently selected cell).
Note:_ Names of formulas are NOT casesensitive, and must be entered all caps (ex: =SUM, as opposed to =sum).
Fig. 8: Example sheet containing a formula
Note: Formulas are interpreted as JavaScript after a few transformations. Most constructs and functions of the language can be used. This documentation describes the elements required for common use and customized elements
Fig. 9: Spreadsheet not in edit mode
Note:_ (As of Tiki 12), replicating formula cells across a column is NOT possible when there are locked cells of type $D2 or $D$3 used in the formula. For e.g. "=$D$3*E3+C$4 will fail with errors. In this case, you will need to copy & paste by hand the formula in each cell and change the numbering of the free cells (here E3 to E4, E5, ...).
Hopefully, this will improve in the coming versions of Tiki.
Here is a list of the functions available:
Note: You must enter function names in UPPER case. Function names appear to be case sensitive e.g. entering "sum(A1:A12)" will not work, you must enter "SUM(A1:A12)".

Math methods  
