TablePlugin and EditTablePlugin test case - mixed order of EDITTABLE and TABLE tags
Description: Manual test of the combinations of TABLE and EDITTABLE macros with advanced tables
This test contains 4 identical tables all with both TABLE and EDITTABLE tags. They are combined the 4 different ways.
Test Steps
- Verify that the 4 tables are identical with content and columnwidths
- Edit each of the 4 tables using the edit table feature. Verify that they all 4 behave the same way
- In all 4 tables edit and add a row. The row must be added BEFORE the footer row
- Put some text in the fields. Use some Macros like WIKINAKE and RED/ENDCOLOR
- Save and check that the new row appears OK with calculations
- Check in raw view that the Macros are saved as macros and that the CALC in the 13th column is the same as the previous columns
- Edit the table again and move the row above the footer up a few positions
- Save and check that the row ended up at the right position and that the footer is still at the bottom
TABLE before EDITTABLE - two lines
%TABLE{columnwidths="80,80,50,110,150,50,50,50,50,50,70,70,50" dataalign="left,left,center,left,left,center,center,center,center,center,center,right,right,center" headeralign="center" headerrows="1" footerrows="1" headerislabel="on"}%
%EDITTABLE{format="|text,10|text,10|text,3|text,15|text,15|text,3|text,3|text,3|text,3|text,3|text,3|text,10|label,0,$percntCALC{$quot$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))$quot}$percnt|text,5|" }%
Project |
Customer |
Pass |
Type |
Purpose |
Qty |
Radios |
Controllers |
Hubs |
Tuners |
Hybrid |
Unit Cost (USD) |
Total Cost (USD) |
When (Q) |
---|
Project A |
Engineering |
A |
PK2 |
Eng Test |
2 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project B |
Factory |
A |
PC2 |
Fact Test |
1 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project C |
Eng |
P1 |
CT5 |
Eng Test |
1 |
2 |
1 |
|
|
1 |
3502 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project D |
SW |
P3 |
CT5 |
SW Dev |
2 |
4 |
2 |
|
2 |
|
6345 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Total |
|
|
|
|
%CALC{"$SUM($ABOVE())"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
|
%CALC{"$SUM($ABOVE())"}% |
|
---|
EDITTABLE before TABLE - two lines
%EDITTABLE{format="|text,10|text,10|text,3|text,15|text,15|text,3|text,3|text,3|text,3|text,3|text,3|text,10|label,0,$percntCALC{$quot$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))$quot}$percnt|text,5|" }%
%TABLE{columnwidths="80,80,50,110,150,50,50,50,50,50,70,70,50" dataalign="left,left,center,left,left,center,center,center,center,center,center,right,right,center" headeralign="center" headerrows="1" footerrows="1" headerislabel="on"}%
Project |
Customer |
Pass |
Type |
Purpose |
Qty |
Radios |
Controllers |
Hubs |
Tuners |
Hybrid |
Unit Cost (USD) |
Total Cost (USD) |
When (Q) |
---|
Project A |
Engineering |
A |
PK2 |
Eng Test |
2 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project B |
Factory |
A |
PC2 |
Fact Test |
1 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project C |
Eng |
P1 |
CT5 |
Eng Test |
1 |
2 |
1 |
|
|
1 |
3502 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project D |
SW |
P3 |
CT5 |
SW Dev |
2 |
4 |
2 |
|
2 |
|
6345 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Total |
|
|
|
|
%CALC{"$SUM($ABOVE())"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
|
%CALC{"$SUM($ABOVE())"}% |
|
---|
TABLE before EDITTABLE - one line
%TABLE{columnwidths="80,80,50,110,150,50,50,50,50,50,70,70,50" dataalign="left,left,center,left,left,center,center,center,center,center,center,right,right,center" headeralign="center" headerrows="1" footerrows="1" headerislabel="on"}% %EDITTABLE{format="|text,10|text,10|text,3|text,15|text,15|text,3|text,3|text,3|text,3|text,3|text,3|text,10|label,0,$percntCALC{$quot$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))$quot}$percnt|text,5|" }%
Project |
Customer |
Pass |
Type |
Purpose |
Qty |
Radios |
Controllers |
Hubs |
Tuners |
Hybrid |
Unit Cost (USD) |
Total Cost (USD) |
When (Q) |
---|
Project A |
Engineering |
A |
PK2 |
Eng Test |
2 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project B |
Factory |
A |
PC2 |
Fact Test |
1 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project C |
Eng |
P1 |
CT5 |
Eng Test |
1 |
2 |
1 |
|
|
1 |
3502 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project D |
SW |
P3 |
CT5 |
SW Dev |
2 |
4 |
2 |
|
2 |
|
6345 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Total |
|
|
|
|
%CALC{"$SUM($ABOVE())"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
|
%CALC{"$SUM($ABOVE())"}% |
|
---|
EDITTABLE before TABLE - one line
%EDITTABLE{format="|text,10|text,10|text,3|text,15|text,15|text,3|text,3|text,3|text,3|text,3|text,3|text,10|label,0,$percntCALC{$quot$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))$quot}$percnt|text,5|" }%
%TABLE{columnwidths="80,80,50,110,150,50,50,50,50,50,70,70,50" dataalign="left,left,center,left,left,center,center,center,center,center,center,right,right,center" headeralign="center" headerrows="1" footerrows="1" headerislabel="on"}%
Project |
Customer |
Pass |
Type |
Purpose |
Qty |
Radios |
Controllers |
Hubs |
Tuners |
Hybrid |
Unit Cost (USD) |
Total Cost (USD) |
When (Q) |
---|
Project A |
Engineering |
A |
PK2 |
Eng Test |
2 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project B |
Factory |
A |
PC2 |
Fact Test |
1 |
4 |
|
2 |
2 |
|
6214 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project C |
Eng |
P1 |
CT5 |
Eng Test |
1 |
2 |
1 |
|
|
1 |
3502 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Project D |
SW |
P3 |
CT5 |
SW Dev |
2 |
4 |
2 |
|
2 |
|
6345 |
%CALC{"$EVAL($T(R$ROW():C6) * $T(R$ROW():C$COLUMN(-1)))"}% |
Q1 |
Total |
|
|
|
|
%CALC{"$SUM($ABOVE())"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
%CALC{"$SUMPRODUCT(R2:C6..R$ROW(-1):C6, R2:C$COLUMN(0)..R$ROW(-1):C$COLUMN(0))"}% |
|
%CALC{"$SUM($ABOVE())"}% |
|
---|
-- end of test