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'.
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'.
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'.
Determines how to distribute text to Excel cells if the text does not fit a simple cell. Choose one of the following:
This default value can be changed for a specific report during the export.
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.