Excel or Open Document Spreadsheet
Depending on the selected format the output file will be created in the XLSX or ODS format. It can be customized with the following options.
Truncating Behavior
Specifies whether strings which are too long for their cell will be truncated or not. This option is enabled by default.
Cell Distribution
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
New sheet per top-level group
Specifies whether a new sheet will be created for every instance of the top-most group or not. This option is disabled by default.
Number of group level outlines
Specifies how many group levels are to be shown in the outline of the excel sheet. A number between 0 and 7 is valid. The default value is: 0.