FrontPage 

TB Wiki

Login

TestSpreadsheetStuff in split format

Here are some tests of spreadsheet functionality in tables
Here are some tests of spreadsheet functionality in tables

simple spreadsheet [edit section]

= simple spreadsheet =
== table not a spreadsheet ==
Here is the data, without the "is_spreadsheet" attribute
{{{#!Table:Not1
||Name||count||cost||total||
||shoes||2||.30||=2*.30||
||shirts||3||1.50||=3*1.50||
}}}

table as spreadsheet [edit section]

== table as spreadsheet ==
{{{#!Table:Is1
is_spreadsheet=1
||Name||count||cost||total||
||shoes||2||.30||=2*.30||
||shirts||3||1.50||=3*1.50||
}}}

complex spreadsheets [edit section]

= complex spreadsheets =
== complex formulas ==
The following table has relative references, functions (SUM), 
{{{#!Table:spread
is_spreadsheet=1
||Name||test||count||cost||formula||total||expected value||
||candy||simple formula||2||.30||f=2*.30||=2*.30||.6||
||socks||simple formula||3||1.50||f=3*1.50||=3*1.50||4.5||
||shoes||simple ref||6||2.00||f=$shoes.count||=$shoes.count||6||
||shirts||expression||3||12.95||f=$.count * $.cost||=$.count * $.cost||38.85||
||sub-total||sum function||.||.||f=SUM($candy.:$shirts.)||=SUM($candy.total:$shirts.total)||49.95||
||sub-count||sum of count||=SUM($candy.count:$shirts.count)||.||f=SUM($candy.count:$shirts.count)||||14||
}}}

multiplication table [edit section]

== multiplication table ===
{{{#!Table:multiplication
is_spreadsheet=1
||.||rval||col1||col2||col3||col4||col5||col6||
||cval||.||1||2||3||4||5||9||
||row1||1||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
||row2||2||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
||row3||3||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
||row4||4||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
||row5||5||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
||row6||7||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||=$.rval*$cval.||
}}}
TBWiki engine 1.9.2 by Tim Bird