Spreadsheet Export

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

Mapping for Logical Fonts

Serif

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

SansSerif

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

Monospaced

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

Cell Distribution

Determines how to distribute text to Excel cells if the text does not fit a simple cell. Choose one of the following:

  • Static Layout - the text is displayed in one line. Background and border, if set, are displayed as designed in the report. All lines are connected.
  • One Line - the text is displayed in one line. Background and border, if set, are displayed as designed in the report. Additional rows are not connected.
  • Line Break - the text, (as well as background and border, if set) are displayed in one single cell, but the cell's text includes line breaks if needed.
  • Multi-cells - the text is split into multiple Excel cells. The number of required rows will be the same as number of lines of text. The rows are not connected. Background and border, if set, are set for all lines of text.
  • Merge Cells - the text is split into multiple Excel rows, the rows are merged, but the text receives line breaks. Background and border, if set, are set for all lines of text.
  • Single Cell - the content is written into a single line. Background and border are only set for this one cell. The width of background and border is that of the element's designed width.

This default value can be changed for a specific report during the export.

  • Default value: Static Layout

Cell Truncate

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