plugin

Plugin Sheet

This Wiki Plugin allows the data from a Tiki Spreadsheet to be integrated into a wiki page.

Usage and Parameters

To use this plugin in a wiki page, use the syntax:

{SHEET(id=>sheet_id)}table_caption{SHEET}

Required parameters are in bold
Preferences required: wikiplugin_sheet, feature_sheet

Parameters	Accepted Values	Description	Default	Since
id	Sheet ID number	Internal ID of the TikiSheet. Either id or url MUST be used.
url	Valid url	Internal URL of the Table to use as a spreadsheet. Either id or url MUST be used.		6.0
simple	y or n	Simple table view y/n (Default: n = jquery.sheet view if feature enabled).	n	5.0
width	Number of pixels followed by 'px' or percent followed by % (e.g. "200px" or "100%").	Width in pixels or percentage. Default value is page width. e.g. "200px" or "100%"	Page width	6.0
height	Number of pixels followed by 'px' or percent followed by % (e.g. "200px" or "100%").	Height in pixels or percentage. Default value is complete spreadsheet height.	Spreadsheet height	5.0
editable	y or n	Show edit button. Default 'y' depending on user's permissions.	y	6.0
subsheets	y or n	y/n. Show multi-sheets. Default 'y'.	y	6.0
range	Cell range, e.g. "D1:F3" or "e14:e14"	Show a range of cells (or single cell). Default shows all. e.g. "D1:F3" or "e14:e14"	All cells	6.0
class	Any valid CSS class	Apply custom CSS class to the containing div.		6.0

In Tiki7, you can use an internal or external url to a csv file in the url param of the sheet plugin, in order to show the csv file as a spreadsheet within Tiki.

Example

This code,

{SHEET(id=15)}Table 2. Advantages and disadvantages detected by the teaching staff after using Wiki methodology{SHEET}

On a tiki site have sheet id 15 (tiki-view_sheets.php?sheetId=15) as:

Would produce, in the middle of a wiki page context:

The edit sheet button is shown while a registered user is logged in to the site. When logged out, no "edit sheet" button is shown.
Images taken from this study of usage of Tiki in educational scenarios:
http://uniwiki.ourproject.org/aw1l