Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Done
-
None
Description
When exporting an Excel template (XLSX) with a high amount of complex formulas and issues in bulk the Xporter engine seems to be hanging at around 64% for a while. However, after an unreasonable amount of time (that depends on the number of cells to be processed) the template export will succeed without any noticeable issues, apart from the performance hit that is being described.
Cause:
After some debugging we have concluded that the problem seems to be happening in the process method of AsCellProcessor class. By commenting the code related with formula calculations the export would speed up immensely.
Steps to reproduce:
- Have a template with multiple and complex formulas
- Bulk export the template with a reasonable amount of issues using the same template
Actual result: Template export will hang at around 64% for a good amount of time. The template will still be exported if given enough time.
Expected result: The template export proceeds smoothly without hanging for an unreasonable amount of time.
Note: I have attached the support provided template associated with this issue.
Attachments
Issue Links
- relates to
-
XPORTER-3845 Performance issues when exporting to XLSX with formulas
- Closed