Loading...
 

Spreadsheet demo



Introduction

This profile will create some spreadsheets for you to test the feature, and see their charting capabilities, formulas, etc.



This profile will include:

Remember that once you install this profile, you are NOT LOCKED IN to any feature, menu or content. Everything can always be changed, deleted or added to.

Features (Quick List)

  • Add a simple spreadsheet to Tiki, with sample data and charts


Features & Settings (YAML)

YAML
instructions: Spreadsheet demo instructions preferences: feature_sheet: y feature_jquery_sheet: y feature_wiki: y wikiplugin_sheet: y wikiplugin_chart: y wikiplugin_split: y


Instructions page

YAML
objects: - type: wiki_page ref: spreadsheet_inst_page data: name: Spreadsheet demo instructions description: Some instructions about the profile Spreadsheet demo lang: en content: wikicontent:Profile_spreadsheet_demo_instructions


Spreadsheet 1

YAML
objects: - type: sheet ref: spreadsheet_demo1 data: - title: Testing Basic operations rows: - [ 4, 8, =AVERAGE(A1:B1) ] - [ =C1, =10 + 10, =MAX(B1:B2) ] - [ "", Example text __in bold__ ] - [ Summing values in rows 1 and 2, =SUM(A1:C2) ] - [ =COUNT(A1:A4), =COUNT(B1:B4) ]


Spreadsheet 2

YAML
objects: - type: sheet ref: spreadsheet_demo2 data: - title: Testing Charts rows: - [ Data, Month, Year, Chart Type, Example, Chart ] - [ 4, Jan, 2001, Vertical Bar, "'=BARCHART(A2:A13)'", =BARCHART(A2:A13) ] - [ 6, Feb, 2002, Horizontal Bar, "'=HBARCHART(A2:A13)'", =HBARCHART(A2:A13) ] - [ 7.2, Mar, 2003, Line, "'=LINECHART(A2:A8;C2:C6)'", =LINECHART(A2:A8;C2:C6) ] - [ 7.5, Apr, 2004, Pie, "'=PIECHART(A2:A8;B2:B8)'", =PIECHART(A2:A8;B2:B8) ] - [ 8.2, May, 2005, , , ] - [ 9.1, Jun, 2006, , , ] - [ 14.1, Jul, 2007, , , ] - [ 16, Aug, 2008, , , ] - [ 17.9, Sep, 2009, , , ] - [ 22, Oct, 2010, , , ] - [ 30, Nov, 2011, , , ] - [ 32, Dec, 2012, , , ]


Spreadsheet_Test_Profiles