Details
-
Bug
-
Status: Open
-
Medium
-
Resolution: Unresolved
-
Xporter DC - 6.9.16
-
None
Description
Excel formula is not working, when a referenced cell is empty in the template.
It is necessary to implement a condition to verify first if the cell is empty or not.
Example:
- =Template!A2&" - "&Template!B2 - Doesn't work
- =SE(Template!B2="";"";Template!A2&" - "&Template!B2) - Works
Steps to reproduce:
- Perform an export with the following template: TemplateWrong.xlsx
The generated file won't be able to be opened by Excel.
- Perform an export with the following template: TemplateCorrect.xlsx
The file will be successfully generated with all the necessary data.
Note: In version 6.9.12 it was working fine.