- edited description
- changed component to View
Export calculated column to Excel results in blank column
Issue #474
resolved
We have a calculated column in an Apliqo report with this formula:
=IF(AH1 / IF(M1 = 0, 1, M1) > 5, 0, IF(M1 = 0, 0, AH1 / IF(M1 = 0, 1, M1)))
When we export the report to Excel, we get these error messages:
Repair Result to ___.verbose0.xml
Errors were detected in file '___.xlsx'
Removed Records: Formula from /xl/worksheets/sheet1.xml part
Removed Records: Formula from /xl/worksheets/sheet2.xml part
When we open my report, the calculated column header shows up but the values are all blank.
Are formulas of this complexity supported during export? We are on the linux version 2022.06 (latest version).
Comments (7)
-
reporter -
- changed status to open
Added to our issues backlog
-
- marked as minor
-
Issue priority has been changed to minor as this has no impact on the application it self.
-
- changed status to resolved
a fix for this will be included on June 2022 FP2 release
-
reporter That’s great, thank you!
-
- removed milestone
Removing milestone: 2022_Q1 (automated comment)
- Log in to comment