If you are unable to create a new account, please email support@bspsoftware.com

 

Increasing max rows not working for Excel formatted?

Started by llopinto, 14 Jun 2019 10:54:02 AM

Previous topic - Next topic

llopinto

in 10, I had updated the settings to allow 500k rows per worksheet with no problems.  It seems like in Analytics, it only works for Excel data, NOT excel with formatting.

Before you ask, I added these to ReportService, BatchReportService, and even the system advanced settings:

RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET = TRUE
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS = 500000
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE = 500000

Any help would be appreciated, thanks!