Export as MS Excel

For XLS export the font 'serif' will be replaced with the font defined in this property. This font is used in xls export because xls does not know the logical font 'serif'.

Default value: Times New Roman

For XLS export the font 'sansserif' will be replaced with the font defined in this property. This font is used in xls export because xls does not know the logical font 'sansserif'.

Default value: Arial

For XLS export the font 'monospaced' will be replaced with the font defined in this property. This font is used in xls export because xls 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. 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.

It is possible to change this default value for a specific report in the export dialog of the Java viewer or in the report URL. The possible parameter values and more information about the report URL parameters you can find in the i-net Clear Reports documentation.

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 value of this server property can be changed for a single report with the URL parameter "celltruncate".

Default value: true