Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-60132

Office Excel thread hangs if xls file contains formulas

XMLWordPrintable

      Problem

      Office Excel (view-xls) macro does not load and its corresponding thread gets stuck if the file contains formulas. Example:

      =COUNTIF(Section,"Person4")+H1

      Steps to Reproduce

      1. Attach the file Test.xls to a page
      2. Add the Office Excel macro and select that file
      3. Save the page

      Expected Results

      The page and the macro render as expected.

      Actual Results

      The page does not load anymore and the thread gets stuck infinitely. Only restarting the application will clear up that thread.

      Workaround

      The file Test-noformulas.xls is the same but the "COUNTIF" formulas were removed. The bug cannot be reproduced with that file. So, the options are:

      1. Edit the file and remove those formulas
      2. Or, use the File Preview macro instead of the Office Excel one

      Notes

      Example of hanging thread:

      at com.aspose.cells.zaaj.c
at com.aspose.cells.Workbook.calculateFormula

      This can result in full unresponsiveness of the instance if the page is visited the same number of times that is defined in maxThreads (48 by default) since they all will get stuck in this operation. Only restarting will clear them up.

      It also affects Data Center because the Office Excel macro is not covered by the file conversion sandboxing due to this bug:

        1. 60132.mp4
          24.95 MB
        2. CONFSERV-60132.mp4
          10.79 MB
        3. Test.xls
          67 kB
        4. Test-noformulas.xls
          39 kB

            [CONFSERVER-60132] Office Excel thread hangs if xls file contains formulas

            Viacheslav Yushchenko (Inactive) added a comment - - edited

            Document Conversion Library component needs to be updated (version 2.3.4 and 2.4.2 work correctly)

            Viacheslav Yushchenko (Inactive) added a comment - - edited Document Conversion Library component needs to be updated (version 2.3.4 and 2.4.2 work correctly)

              568965d94e93 Viacheslav Yushchenko (Inactive)
              bandreeti Bernardo Andreeti
              Affected customers:
              2 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: