Tiki Spreadsheet performs calculations on user entered numeric data and presents the resulting data in tables and/or graphics within Tiki pages. The documentation describes the various available calculations performed by the Tikisheet.

Sheet management

Insert this code in a wiki page in order to have on spreadsheet added there:

{sheet}

And follow the instructions/links that you will be provided in the page after saving it.

• Left Arrow - Active cell moves left if possible
• Right Arrow - Active cell moves right if possible
• Up Arrow - Active cell moves up if possible
• Down Arrow - Active cell moves down if possible

• Left Arrow + Shift - Highlights left if possible
• Right Arrow + Shift - Highlights right if possible
• Up Arrow + Shift - Highlights up if possible
• Down Arrow + Shift - Highlights down if possible

• Escape - Active cell is removed from focus
• Enter - Active cell is set and cell moves down if possible.
• Shift + Enter - Adds a line break to the cell's value
• Tab - Active cell is set and active cell moves right if possible
• Ctrl + X - Cut
• Ctrl + C - Copy
• Ctrl + V - Paste

• Ctrl + Z - Undo
• Ctrl + Y - Redo

A formula is the reason why spreadsheets are so powerful. jQuery.sheet has a very powerful and secure formula engine that can be used in the following way:

• Starting a cell's value with '=' activates the formula engine on the active cell(s) you are editing, for example (results in 100):
  
  Copy to clipboard

  =100

  • This would really be the same as setting the cell's value to '100'
• Now lets start really using formulas (results in 0.03):
  
  Copy to clipboard

  =(100 + 200) /1000

jQuery.sheet v3 offers the option of creating and referencing variables (see jQuery.sheet setting formulaVariables)

• Example of using simple variable in formula:
  
  Copy to clipboard

  =variable_name

Variables can also have attributes:

• Example of using variable with attributes in formula:
  
  Copy to clipboard

  =variable_name.attribute

• Example of using variable with math:
  
  Copy to clipboard

  =100 * variable_name

Functions are where much of the work is done within spreadsheets. Here is how to use them:

• To use the SUM function, enter the following:
  
  Copy to clipboard

  =SUM()

• To use SUM with a single cell:
  
  Copy to clipboard

  =SUM(A1)

• To use SUM with a range of cells:
  
  Copy to clipboard

  =SUM(A1:B2)

• Nested functions:
  
  Copy to clipboard

  =DOLLAR(SUM(A1:B2) + SUM(D1:E2))

Cells can be referenced in the following ways:

• Single cell - example:
  
  Copy to clipboard

  A1

• Range of cells - example:
  
  Copy to clipboard

  A1:B2

• Single cell fixed - example:
  
  Copy to clipboard

  $A$1

• Range of cells fixed - example:
  
  Copy to clipboard

  $A$1:$B$2

• Other spreadsheet single cell - Example:
  
  Copy to clipboard

  SHEET2!A1

• Other spreadsheet range of cells - Example:
  
  Copy to clipboard

  SHEET2!A1:B2

See:

For the time being, see this external documentation page:
https://github.com/Spreadsheets/WickedGrid

See also:

• PluginSheet
• Spreadsheet Functionality
• Spreadsheet Interface
• Spreadsheet Graphics and Charts
• JQuery
• Spreadsheet jq

• Sheet
• TikiSheet
• Tiki Sheet
• Spreadsheets