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.

XMLWordPrintable

      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

          Form Name

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

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2888495 ] New: CONFSERVER Bug Workflow v4 [ 2999607 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2798353 ] New: JAC Bug Workflow v3 [ 2888495 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2735622 ] New: JAC Bug Workflow v2 [ 2798353 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2401108 ] New: JAC Bug Workflow [ 2735622 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2301075 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2401108 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2234963 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2301075 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2197945 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2234963 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1953668 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2197945 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1746579 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1953668 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1709060 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1746579 ]

              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: