TestSpreadsheetStuff
simple spreadsheet [edit section]
table not a spreadsheet [edit section]
Here is the data, without the "is_spreadsheet" attributeName ^ | count ^ | cost ^ | total ^ |
shoes | 2 | .30 | =2*.30 |
shirts | 3 | 1.50 | =3*1.50 |
table as spreadsheet [edit section]
Name ^ | count ^ | cost ^ | total ^ |
shoes | 2 | .30 | 0.6 |
shirts | 3 | 1.50 | 4.5 |
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 |
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 |