History: Spreadsheet demo

            {maketoc}

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

{BOX()}{CENTER()}{img src="https://tiki.org/display1159" width="400" thumb="box"}{CENTER}{BOX}

This profile will include:
* [https://profiles.tiki.org/Profile_spreadsheet_demo_instructions]

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)
{CODE(caption=>YAML,wrap=1)}
instructions: Spreadsheet demo instructions
preferences:
 feature_sheet: y
 feature_jquery_sheet: y
 feature_wiki: y
 wikiplugin_sheet: y
 wikiplugin_chart: y
 wikiplugin_split: y
{CODE}

!! Instructions page
{CODE(caption=>YAML,wrap=1)}
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
{CODE}

!! Spreadsheet 1
{CODE(caption=>YAML,wrap=>1)}
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) ]
{CODE}

!! Spreadsheet 2
{CODE(caption=>YAML,wrap=>1)}
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, , ,  ]
{CODE}

(alias(Spreadsheet_Test_Profiles))