History: Spreadsheet jq

• «
• »

            ^ This page should merge with ((Spreadsheet)) ^

{maketoc}

! Spreadsheet using jQuery.sheet
The ((Spreadsheet)) feature can be be accessed through the jquery.sheet interface, added to Tiki since version 5.0

!! A review of jQuery.Sheet
[http://roberto.open-lab.com/2010/01/30/javascript-grid-editor-i-want-to-be-excel/|Light years beyond other solutions at least as first impression, jQuery.sheet by Robert Plummer is a really wonderful library.]

!! Usage

When adding a new spreadsheet, the interface is as usual in ((Tiki5)): you have the option to allow wiki parsing of wiki content inside the spreadsheet, plus defining some parent relationship with other spreadsheets:

{img src="display235" imalign=center} 

When editing the spreadsheet, you can add more rows and columns, add content to them, move among the cells using the cursor keys, etc. If wiki parsing was enabled for the spreadsheet, then you can add any wiki syntax to the cell (including ((Wiki plugins))!)

::{img src="display233" class=reflect}:: 

That wiki markup will be parsed when saved.

::{img src="display234" class=reflect} ::

New sheets can be added when clickling at the plus sign ("+") at the bottom of the spreadsheet.

::{img src="display232" }::

Then, this new sheet is added to the workbook.

::{img src="display236" imalign=center}:: 

!! Spreadsheet Help