EXAMPLE
SUM over columns
{ { { #!sctable ||1||2||=A0+B0|| ||10||20||=@sum(A1:B1)|| } } }
RESULT:
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
cell B1 no data
{ { { #!sctable ||A||B||C||D|| ||1||||2||=A1+C1|| } } }
RESULT:
A |
B |
C |
D |
1.00 |
2.00 |
3.00 |
SUM over rows
{ { { #!sctable ||1||2||=A0+B0|| ||10||20||30|| ||=@sum(A0:A1)||=@sum(B0:B1)||=@sum(C0:C1)|| } } }
RESULT:
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
SUM over rows and columns
{ { { #!sctable ||A||B||C|| ||1||2||=A1+B1|| ||10||20||=@sum(A2:B2)|| ||=@sum(A1:A2)||=@sum(B1:B2)||=@sum(C1:C2)|| } } }
RESULT:
A |
B |
C |
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |
-column_header
{ { { #!sctable -column_header ||1||2|| ||3||4|| ||5||6|| } } }
RESULT:
A |
B |
1.00 |
2.00 |
3.00 |
4.00 |
5.00 |
6.00 |
-row_header
{ { { #!sctable -row_header ||1||2|| ||3||4|| ||5||6|| } } }
RESULT:
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
-column_header -row_header
{ { { #!sctable -column_header -row_header ||1||2|| ||3||4|| ||5||6|| } } }
RESULT:
|
A |
B |
0 |
1.00 |
2.00 |
1 |
3.00 |
4.00 |
2 |
5.00 |
6.00 |
-show_formular -column_header -row_header
{ { { #!sctable -show_formular -column_header -row_header ||m||p|| ||1||=A1 * 5|| ||2||=A2-3|| ||3||4|| } } }
RESULT:
|
A |
B |
0 |
m |
p |
1 |
1 |
=A1*5 |
2 |
2 |
=A2-3 |
3 |
3 |
4 |
-column_header and blanks in cells
{ { { #!sctable -column_header ||Name Vorname|| || || 3 || || 5|| ||Name Vorname|| 1 || 2 || || 4 || 5|| ||Name Vorname|| 1 || 2 || || || 5|| } } }
RESULT:
A |
B |
C |
D |
E |
F |
Name Vorname |
|
|
3.00 |
|
5.00 |
Name Vorname |
1.00 |
2.00 |
|
4.00 |
5.00 |
Name Vorname |
1.00 |
2.00 |
|
|
5.00 |
-format 1,1
{ { { #!sctable -format 1,1 ||1||2|| ||3||4|| ||=@sum(a0:a1)||=a2*4|| } } }
RESULT:
1.0 |
2.0 |
3.0 |
4.0 |
4.0 |
16.0 |
{{{ useage of variable names -show_formular -column_header -row_header }}}
{ { {#!sctable -show_formular -column_header -row_header ||A||B||C|| ||1||{two}2||=A1+two|| ||10||20||=@sum(A2:B2)|| ||=@sum(A1:A2)||=@sum(B1:B2)||=@sum(C1:C2)|| } } }
RESULT:
|
A |
B |
C |
0 |
A |
B |
C |
1 |
1 |
{two}2 |
=A1+two |
2 |
10 |
20 |
=@sum(A2:B2) |
3 |
=@sum(A1:A2) |
=@sum(B1:B2) |
=@sum(C1:C2) |
and if we calculate
RESULT:
|
A |
B |
C |
0 |
A |
B |
C |
1 |
1.00 |
2.00 |
3.00 |
2 |
10.00 |
20.00 |
30.00 |
3 |
11.00 |
22.00 |
33.00 |
{{{color in cells }}}
{ { {#!sctable ||<:rowbgcolor=lightcyan>'''A'''||<:>'''B'''||<:>'''C'''|| ||<)#dddddd>1||<)#dddddd>{two}2||<)#cccccc>=A1+two|| ||<(>10||<)>20||<:#dddddd>=@sum(A2:B2)|| ||<rowbgcolor="#cc99ff">=@sum(A1:A2)||=@sum(B1:B2)||<bgcolor=magenta>=@sum(C1:C2)|| } } }
RESULT:
A |
B |
C |
1.00 |
2.00 |
3.00 |
10.00 |
20.00 |
30.00 |
11.00 |
22.00 |
33.00 |