Set the settings which have an effect on report generation in spreadsheet export format like: XLS, XLSX and ODS.

For spreadsheet export the font 'serif' will be replaced with the font defined in this property. This font is used in spreadsheet export because the table calculation formats does not know the logical font 'serif'.

• Default value: Times New Roman

For spreadsheet export the font 'sansserif' will be replaced with the font defined in this property. This font is used in spreadsheet export because the table calculation formats does not know the logical font 'sansserif'.

• Default value: Arial

For spreadsheet export the font 'monospaced' will be replaced with the font defined in this property. This font is used in spreadsheet export because the table calculation formats does not know the logical font 'monospaced'.

• Default value: Courier New

Determines how to distribute text to Excel cells if the text does not fit a simple cell. The default value can be changed for a specific report during the export. For details about cell distribution check out the export documentation

• Default value: Static Layout

Truncate the cell content in excel export. If it is true then the content of cells will be truncated if it does not fit into the designed field size. The default value of this server property can be changed for a single report during export.

• Default value: activated