TikiSheet is a web-based spreadsheet, similar to MS Excel or OOo Calc.
More information: TikiSheetDev
Demo: TikiSheetDemo
Documentation
Sheet Creation
From tiki-sheets.php, you should be able to see a "Create New Sheet" link. Clicking it will lead you to a form containing the sheet's properties.
Title
The title of the sheet.
Description
The description of the sheet.
Class Name
The CSS class name that will be applied on the <table> tag of the normal output. This method is used to allow as much flexibility as possible and reduce the actual work required by TikiSheet developpers.
The amount of rows that will be part of the <thead> section of the table.
The amount of rows that will be part of the <tfoot> section of the table.
If the amount of rows is inferior to the sum of header and footer rows, the table will not be displayed. The remaining rows will be part of <tbody>
Sheet Property Modification
The right section of the sheet listing contains an icon to modify the properties. The same form seen in creation will be displayed. The title and description will be modified globally and the class, header and footer rows will be kept as a revision (possible to rollback).
Sheet Modification
Clicking on the sheet's title in the listing will lead to the display. An edit link is present and will lead to edit mode for the current sheet. A serie of links is available above the sheet and allows multiple operations. Rows and colums can be removed and added at any place. The forms should be clear enough and require no additional information.
Cells can be selected by clicking on them. Typing directly will enter a value. A double click will lead to the top bar to edit the calculation (must start with =, otherwise it will be considered as a normal value). The calculations support all common operators (see ))JavaScript(( documentation). The list of available custom functions is available on TikiSheetDev. It's possible to reference to a cell using A1 type of format. Using $ before column and/or row identifier will set that attribute as sticky (no auto-increase/decrease), as in most spreadsheet applications. Cell ranges can be represented using A1:B3 type of syntax.
Multiple cells can be selected by holding either ctrl or shift. The behavior is similar to most desktop environments (ctrl->single, shift->range). When a range of cells is selected, they can be merged (from the menu). Restore will seperate all cells.
Copy calculation allows to copy a calculation on multiple rows/columns and modify the components to apply to the new row/column.
When changes are saved, they are saved as a revision and it is possible to rollback (even if the interface does not currently supports it).
Delete a Sheet
Accessible fron the delete icon in the sheet listing.
Import/Export
Save and load icons are available in the sheet listing. Import will ask to specify a format and a file from the local drive. The currently supported formats are: TikiSheet native, CSV and Excel. Most formats will cause data loss. TikiSheet native format will only loose revision informations. Export will ask a format and output the file (ready for download).