TestSpreadsheetStuff 

TB Wiki

Login

TestSpreadsheetStuff

Here are some tests of spreadsheet functionality in tables

simple spreadsheet [edit section]

table not a spreadsheet [edit section]

Here is the data, without the "is_spreadsheet" attribute
Name  ^ count  ^ cost  ^ total  ^
shoes 2 .30 =2*.30
shirts 3 1.50 =3*1.50
Query

table as spreadsheet [edit section]

Name  ^ count  ^ cost  ^ total  ^
shoes 2 .30 0.6
shirts 3 1.50 4.5
Query

complex spreadsheets [edit section]

complex formulas [edit section]

The following table has relative references, functions (SUM),
Name  ^ test  ^ count  ^ cost  ^ formula  ^ total  ^ expected value  ^
candy simple formula 2 .30 f=2*.30 0.6 .6
socks simple formula 3 1.50 f=3*1.50 4.5 4.5
shoes simple ref 6 2.00 f=$shoes.count 6 6
shirts expression 3 12.95 f=$.count * $.cost 38.85 38.85
sub-total sum function . . f=SUM($candy.:$shirts.) 49.95 49.95
sub-count sum of count 14.0 . f=SUM($candy.count:$shirts.count) 14
Query

multiplication table [edit section]

.  ^ rval  ^ col1  ^ col2  ^ col3  ^ col4  ^ col5  ^ col6  ^
cval . 1 2 3 4 5 9
row1 1 1 2 3 4 5 9
row2 2 2 4 6 8 10 18
row3 3 3 6 9 12 15 27
row4 4 4 8 12 16 20 36
row5 5 5 10 15 20 25 45
row6 7 7 14 21 28 35 63
Query

TBWiki engine 1.9.2 by Tim Bird