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
          27 kB
          Deividi Luvison
        2. Over 100000.7z
          470 kB
          Deividi Luvison

            Assignee:
            Angel Eduardo Garcia Hernandez (Inactive)
            Reporter:
            Deividi Luvison (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: