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

Office Excel Macro fails to display a worksheet that contains more than 100000 rows.

      When we display a worksheet with more than 100000 rows using the Office Excel macro, it fails with below error:

      Steps to reproduce:

      1. Extract the attached Over 100000.7z, to get the "Over 100000.xls" file.
      2. Attach the "Over 100000.xls" in a Space.
      3. Use the office Excel Macro to render the worksheet in the attached file.
      4. Once you hit the refresh icon next to preview in the Excel Macro you will get below error:
        Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: com.benryan.conversion.ConversionException: Cannot convert spreadsheet, the number of cells: 1048560 is greater than the maximum allowed cells: 100000
        

        1. img.PNG
          img.PNG
          27 kB
        2. Over 100000.7z
          470 kB

            [CONFSERVER-32726] Office Excel Macro fails to display a worksheet that contains more than 100000 rows.

              egarcia Angel Eduardo Garcia Hernandez (Inactive)
              dluvison Deividi Luvison (Inactive)
              Affected customers:
              1 This affects my team
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: