Uploaded image for project: 'Xporter for Jira'
  1. Xporter for Jira
  2. XPORTER-3817

Perfomance issue related with multiple complex Excel formulas

    XporterXMLWordPrintable

Details

    • UNCOVERED

    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:

      1. Have a template with multiple and complex formulas
      2. 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

          Activity

            People

              afro Andre Fernandes Rodrigues
              palf Paulo Fernandes [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 10 minutes
                  10m