TestSpreadsheetStuff in split format
|
Here are some tests of spreadsheet functionality in tables
|
Here are some tests of spreadsheet functionality in tables
|
|
|
= 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 =={{{#!Table:Is1is_spreadsheet=1||Name||count||cost||total||||shoes||2||.30||=2*.30||||shirts||3||1.50||=3*1.50||}}}
|
|
|
= complex spreadsheets === complex formulas ==The following table has relative references, functions (SUM), {{{#!Table:spreadis_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 ==={{{#!Table:multiplicationis_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.||}}}
|