https://bz.apache.org/bugzilla/show_bug.cgi?id=66215

--- Comment #4 from Axel Richter <[email protected]> ---
In my workbook "Tabelle2" is the sheet name and "Tabelle1" is the table name.
The formula shifter damages the structured column formula Tabelle1[[#This
Row],[Total]]/Tabelle1[[#Totals],[Total]]. It sets the sheet formula
Tabelle2!E5:E5/Tabelle2!E8:E8 in row 5 of the sheet. My workaround repairs 
this using the also stored column formula from table definition:
<calculatedColumnFormula>Tabelle1[[#This
Row],[Total]]/Tabelle1[[#Totals],[Total]]</calculatedColumnFormula>. 

One cannot detect such problems by JUnit tests only. One needs testing using
real Excel files opened in real Excel applications.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to