History: Spreadsheet demo

View page

Source of version: 29 (current)

{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))

Latest Changes

...more

Like almost all *.tiki.org sites, you can log in with your login from https://tiki.org (register over there)

Search

Most Popular Tags

admin agenda alias antibot antibot captcha app archive articles banning batch blogs calculations calendars cart categories cluster codemirror comments computation contact us datachannel debug debug console dropdown with other error messages features file galleries forums geo geocms geolocation group homepages group watches header i18n images item link items list jquery languages location map maps maths menu menupage multilingual ol3 ol5 openlayers paypal plugin plugin alias plugin datachannel plugin fade plugin tabs plugin trackerlist pretty trackers print project management r r project realnames rss static static text statistics stats structures syntax highlighter tablesorter template trackers user watches visualization watches webservice wiki wiki argument variables wiki structures

History: Spreadsheet demo

Source of version: 29 (current)

Menu

Current Profiles

Latest Changes

Search

Most Popular Tags

About Tiki

Support

Community

Documentation

Development

Legal

Tiki Project Sites

Networks

History: Spreadsheet demo

Source of version: 29 (current)

Menu

Current Profiles

Latest Changes

Search

Most Popular Tags

Tiki Newsletter

About Tiki

Support

Community

Documentation

Development

Legal

Tiki Project Sites

Networks