TikiSheet is a web-based spreadsheet, similar to MS Excel or OOo Calc.
More information: TikiSheetDev
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.
The title of the sheet.
The description of the sheet.
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).
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.
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.
Save and load icons are available in the sheet listing. Import will ask to specify a format and a file from the local drive. Importing to a sheet completely replaces everything on the sheet, however, the history of all versions is kept. 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).
Clicking on the chart-like icon in the sheet list will lead to the form to generate a chart. The first form presents the available type of charts that can be generated and allows to select the output format. Depending on the available libraries, some options may be disabled. Generating PDF documents requires the PDFLib extension to be installed and Images (PNG and JPEG) require the GD library.
Basic options are listed in the interface. PDF require the paper size and orientation. The most common formats have been listed (if you need a different one, leave a note on TikiSheetDev). Images require to specify the width and height. Click on any of the formats to proceed to the data input form.
The data input form is the same for all output formats. The differences come from the selected graphic type. All graphics have an optional title and a certain number of series. Graphics based on a grid (multiline, multibar and bar stack) have 3 additional parameters: independant scale position (indicates if the graphic will be horizontal or vertical), vertical scale (left or right, location of the vertical scale) and horizontal scale (top or bottom, location of the horizontal scale).
The series depend on the type of graphic. They are all given as a range of cells in the sheet. The range is in A1:B10 format. The letters have to be capitalized. Data can be entered manually be separating values by a comma and a space (", "). Entering data manually is useful for labels and colors. When a serie is labeled with 'y0' (or any number), only the first one is mandatory. Series labeled 'label' are used to generate the legend on the graphic.
Colors and styles are optional. Leaving 'style' empty is usually a good idea. The available colors are: