Loading...
 

History: Spreadsheet demo

View page Collapse Into Edit Sessions

Preview of version: 23



Introduction

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

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(D2:D13)", =BARCHART(A2:A13) ]
        - [ 6, Feb, 2002, Horizontal Bar, "=HBARCHART(D2:D13)", =HBARCHART(A2:A13) ]
        - [ 7.2, Mar, 2003, Line, "=LINECHART(D2:D8;F2:F6)", =LINECHART(A2:A8;C2:C6) ]
        - [ 7.5, Apr, 2004, Pie, "=PIECHART(D2:D8;E2:E8)", =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