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

Allow maximum cell count to be configurable to be higher than default 100000 using JVM parameter

XMLWordPrintable

    • 2
    • 1
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Environment

      Confluence 6.15.1

      Description

      It is not possible to open xls file with row count than 100000. There is currently a -Dofficeconnector.spreadsheet.xlsxmaxsize JVM parameter which allows admins to configure the maximum file size but the file must still have fewer than 100,000 cells which is not configurable. It would be nice to provide a configuration option to open files that have more than 100,000 cells.

      The limit is set in the SpreadsheetConverter class in the document-conversion-library.

      Symptoms

      • Error message is displayed: 
        We can't preview this file. 
You'll have to download the file to view it.
      • Logs contain following error: 
        Error rendering macro 'viewxls' : com.benryan.conversion.ConversionException: Cannot convert spreadsheet, the number of cells: 196605 is greater than the maximum allowed cells: 100000

      Workaround

      Currently there is no known workaround for this behaviour. A workaround will be added here when available.

              Unassigned Unassigned
              gkowalczyk GMK
              Votes:
              21 Vote for this issue
              Watchers:
              22 Start watching this issue

                Created:
                Updated: