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