TablePlugin and EditTablePlugin test case - mixed order of EDITTABLE and TABLE tags

combined with macros

Description: Manual test of the combinations of TABLE and EDITTABLE macros with advanced tables and with the option strings defined as macros

• Set TABLESETTING = 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"
• Set EDITTABLESETTING = 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|"

Test Steps

• All 4 tables look exactly the same
• All 4 tables can be edited
• All 4 tables have the column widths matching the settings in TABLE tag
• All 4 tables can be edited and saved and the CALC are not saved as their values
• The first column in view mode is 80 wide same as 2nd column
• The 3rd column in edit mode is a 3 character wide text field
• When editing one table the 3 others look like normal viewing.
• 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