Edit Interface

To edit the content of the spreadsheet from your web browser, click on the title of the spreadsheet in the list and then on edit when the spreadsheet page is being displayed. If the spreadsheet is new, it will appear with a single cell (see Fig. 1).

Fig. 1: Blank spreadsheet

Editing content of a cell

To edit the content of a cell:

• Double-click on the cell
• The current content of the cell appears on the edit bar located at the top of the spreadsheet
  • To replace the current content of the cell with something else, just start typing.
  • To modify the current content of the cell, click in the edit bar, and modify its content.
• Once your edit is done, press Enter

Modify the Spreadsheet Structure

Multiple options are available to change the structure of the spreadsheet. Here is a summary table.

Columns and rows can be added using the "Insert Row" and "Insert Column" options (see Fig. 2 and Fig. 3). Both will present radio buttons to select if the cells should be added before or after the selected reference. The reference is selected from a combo box listing the row numbers or column letters. A text field is used to specified the amount of items to add.

Fig. 2: Insert row form

Fig. 3: Insert column form

Note: If you add new rows or columns and save the sheet before entering data into them, Tiki will actually delete the empty rows or columns__.

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

Calculations can be copied across multiple cells using the "Copy Calculation" option (see Fig. 6). Before the direction is selected, the affected cells must be selected. To do so, first select a cell, hold shift and select the last cell. The selected range will be highlighted. In a vertical range where the calculation is written in the first cell, using the "Down" option will copy the calculation in every cell until the end of the range based on the first row.

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

Cell formatting is used to display the numeric values in a different format, such as replacing *2.5* for *$2.50* when displaying currencies. Applying format on a cell does not affect the real value, allowing to perform calculations. The cell formatting can be applied on a range of selected cells using the "Format Cells" option (see Fig. 7).

Fig. 7: Format cells form

Here is a summary of the available formats available.

Calculations and Formulas

Formulas work in a similar way to those in Excel or OpenOffice.org Calc. Once a cell is selected, a formula can be entered by clicking in the text bar above the spreadsheet and typing *=*, which is the character to indicate the entered value is a formula. Figure 8 contains an example formula.

Fig. 8: Example sheet containing a formula

Values from other cells can be included in a formula using the column letter and the row number. The example above substracts the Member discount from the regular price to produce the member price. Most common operators are supported.

Functions can also be used in formulas. Most functions are applied on a range. Ranges can be obtained using A1:Z99 syntax, where the part before the colon is the top left corner of the selection and the part after the colon is the bottom right corner.

Fig. 9: Spreadsheet not in edit mode

Figure 9 is a sample spreadsheet result. The following formulas have been used to obtain these results:

In the student total result, a dollar sign has been added (D$2) in the reference to the field at the top of the page. The dollar sign symbol indicate the value should not be incremented when the calculation is being copied to other cells. Using $D2 would lock the column to D while the row number could increment. Both can be used together ($D$2). As in Excel worksheets, formulas can be replicated in next cells by simply dragging the small square icon at the bottom-left corner of a cell. The corresponding free cells (not locked by $) will change accordingly.

A range can also be created using brackets. For example, a range containing cells from A1 to A4, excluding A2 could be created using: [ A1, A3, A4 ] .

Here is a list of the functions available:

Math methods

Because the spreadsheet is implemented using Javascript, the Math object's methods can be used. For example, Math.round() will round to the nearest integer. This use is more fragile than native TikiWiki functions, and these methods should be added to the spreadsheet functions in the future.