TestSpreadsheetStuff
Here are some tests of spreadsheet functionality in tables
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
missing column 'col5' in table
|
Name ^ |
count ^ |
cost ^ |
total ^ |
shoes |
2 |
.30 |
0.6 |
shirts |
3 |
1.50 |
4.5 |
Query
missing column 'col5' in table
|
The following table has relative references, functions (SUM),
Name ^ |
test ^ |
count ^ |
cost ^ |
formula ^ |
total ^ |
expected value ^ |
sub-total |
sum function |
. |
. |
f=SUM($candy.:$shirts.) |
0.0 |
49.95 |
shirts |
expression |
3 |
12.95 |
f=$.count * $.cost |
38.85 |
38.85 |
sub-count |
sum of count |
3.0 |
. |
f=SUM($candy.count:$shirts.count) |
|
14 |
candy |
simple formula |
2 |
.30 |
f=2*.30 |
0.6 |
.6 |
shoes |
simple ref |
6 |
2.00 |
f=$shoes.count |
6 |
6 |
socks |
simple formula |
3 |
1.50 |
f=3*1.50 |
4.5 |
4.5 |
Query
missing column 'col5' in table
|
. ^ |
rval ^ |
col1 ^ |
col2 ^ |
col3 ^ |
col4 ^ |
col5 ^ |
col6 ^ |
cval |
. |
1 |
2 |
3 |
4 |
5 |
9 |
row4 |
4 |
4 |
8 |
12 |
16 |
20 |
36 |
row3 |
3 |
3 |
6 |
9 |
12 |
15 |
27 |
row6 |
7 |
7 |
14 |
21 |
28 |
35 |
63 |
row5 |
5 |
5 |
10 |
15 |
20 |
25 |
45 |
row2 |
2 |
2 |
4 |
6 |
8 |
10 |
18 |
row1 |
1 |
1 |
2 |
3 |
4 |
5 |
9 |
Query