What is Large Data Mode

When filling the Excel template with the report data, the Excel reports engine needs to load the whole XLSX file into memory in order to allow complex document manipulation. As a result, if you have a lot of data to insert into your template, you risk poor performance and running out of memory.

With Large Data mode, you can insert data into the Excel report file row by row in a very efficient way, without loading the whole XLSX file into memory. However this improvement on memory and performance comes at a cost. It is not possible to use any of the features of the JETT third-party, such as scripting, placeholders, tags, cells formatting, on the data that is inserted in Large Data mode.

There are other limitations with Large Data mode. The data can only be inserted at the bottom of the first spreadsheet of the workbook; only one list of values can be inserted in a given workbook.

As a result, Large Data mode is typically used to output some large amounts of raw data that will be filtered, formatted, or rendered as charts on other spreadsheets of the workbook by leveraging all the features of Excel reports.

Note: In PPM 9.3X, data inserted in Large Data Mode ignores the style of the cell with the $$placeholders$$ and uses some hard-coded styles for the text font and date formats. This behavior was changed in PPM 9.40, and data inserted in Large Data Mode will now use the same style as the cell (not the column) with the $$placeholder$$. However, if you prefer to keep the old 9.3X behavior with hard-coded styles, go to the PPM Administration Console (or your server.conf file) and set the parameter AUTO_SET_LARGE_DATA_STYLE to true (default value is false).