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.

            Dale Baley added a comment -

            There should at least be an option to override this arbitrary 100000 row limitation. Similar to the officeconnector.spreadsheet.xlsxmaxsize option. I couldn't find it in the source code to make the change myself.

            Dale Baley added a comment - There should at least be an option to override this arbitrary 100000 row limitation. Similar to the officeconnector.spreadsheet.xlsxmaxsize option. I couldn't find it in the source code to make the change myself.

            Given the thousands of other issues we have open that are more highly requested, we won't be able to address this issue in the foreseeable future. Instead we will focus on bugs with a higher impact, and more votes.

            Thanks for taking the time to raise this issue. As you are no doubt aware this issue has been on our backlog for some time now with very little movement.

            I'm going to close this to set expectations so the issue doesn't stay open for years with few updates. If demand for this picks up, we will reopen the issue.

            edith (Inactive) added a comment - Given the thousands of other issues we have open that are more highly requested, we won't be able to address this issue in the foreseeable future. Instead we will focus on bugs with a higher impact, and more votes. Thanks for taking the time to raise this issue. As you are no doubt aware this issue has been on our backlog for some time now with very little movement. I'm going to close this to set expectations so the issue doesn't stay open for years with few updates. If demand for this picks up, we will reopen the issue.

              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: