History: Spreadsheet demo

View page Show All Versions

Preview of version: 26



Introduction

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

Image


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


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

History

Information Version
Sun 29 of Jan, 2017 10:16 GMT-0000 Xavier de Pedro added link to related instructions page 29
Sun 29 of Jan, 2017 00:35 GMT-0000 Xavier de Pedro added plugin split 18 - 28
Sat 28 of Jan, 2017 18:50 GMT-0000 Xavier de Pedro reformated according to new lib frmo symphony and the right yaml syntax. thanks ricardo.melo and marclaporte 17
Fri 27 of Jan, 2017 10:28 GMT-0000 Xavier de Pedro profile install again, but data still not stored in the corresponding cells 12 - 16
Mon 01 of Nov, 2010 02:15 GMT-0000 robertplummer moved title around a bit 6 - 11
Fri 29 of Oct, 2010 16:56 GMT-0000 robertplummer updated profile to work with tiki 5
  • «
  • 1 (current)
  • 2