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

missing column 'col1' in table

table as spreadsheet [edit section]

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

Query

missing column 'col1' in table

complex spreadsheets [edit section]

complex formulas [edit section]

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 'col1' in table

multiplication table [edit section]

.  ^	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