Loading...
 

History: Spreadsheet demo

View page Collapse Into Edit Sessions

Preview of version: 29 (current)



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

History

Advanced
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 28
Sun 29 of Jan, 2017 00:26 GMT-0000 Xavier de Pedro centering screenshot 27
Sun 29 of Jan, 2017 00:26 GMT-0000 Xavier de Pedro added screenshot 26
Sat 28 of Jan, 2017 23:57 GMT-0000 Xavier de Pedro kept strings as strings 25
Sat 28 of Jan, 2017 23:54 GMT-0000 Xavier de Pedro fixing coordinates and testnig a few ways to preserve formula strings column 24
Sat 28 of Jan, 2017 23:47 GMT-0000 Xavier de Pedro added sheet2 23
Sat 28 of Jan, 2017 23:23 GMT-0000 Xavier de Pedro added some ref to the sheet and some extra prefs and instructions page 22
Sat 28 of Jan, 2017 23:07 GMT-0000 Xavier de Pedro more fixes 21
Sat 28 of Jan, 2017 23:05 GMT-0000 Xavier de Pedro fixed a few issues with content 20
Sat 28 of Jan, 2017 23:02 GMT-0000 Xavier de Pedro added some more meaningful content while still simple tests 19
Sat 28 of Jan, 2017 22:50 GMT-0000 Xavier de Pedro renamed to make a good demo of spreadsheets from now onwards, keeping alias with old name just in case 18
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 16
Fri 27 of Jan, 2017 10:28 GMT-0000 Xavier de Pedro profile install again, but data still not stored in the corresponding cells 15
Fri 27 of Jan, 2017 10:26 GMT-0000 Xavier de Pedro attempting to fix the error 'You cannot define a sequence item when in a mapping at line 8 (near "- [ Test, '=A1' ]")' 14
Fri 27 of Jan, 2017 10:26 GMT-0000 Xavier de Pedro attempting to fix the error 'You cannot define a sequence item when in a mapping at line 8 (near "- [ Test, "=A1" ]")' 13
Fri 27 of Jan, 2017 10:22 GMT-0000 Xavier de Pedro attempting to fix the error 'You cannot define a sequence item when in a mapping' 12
Mon 01 of Nov, 2010 02:15 GMT-0000 robertplummer moved title around a bit 11
Mon 01 of Nov, 2010 02:11 GMT-0000 robertplummer Switched a value 10
Mon 01 of Nov, 2010 02:07 GMT-0000 robertplummer moved title around 9
Mon 01 of Nov, 2010 02:04 GMT-0000 robertplummer added title attribute 8
Mon 01 of Nov, 2010 01:53 GMT-0000 robertplummer Removed quotes 7
Mon 01 of Nov, 2010 01:47 GMT-0000 robertplummer Added quotes around values 6
Fri 29 of Oct, 2010 16:56 GMT-0000 robertplummer updated profile to work with tiki 5
  • «
  • 1 (current)
  • 2