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 case-sensitive, and must be entered all caps (ex: =SUM, as opposed to =sum).
Fig. 8: Example sheet containing a formula
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)".