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.
Specifies whether strings which are too long for their cell will be truncated or not. This option is enabled by default.
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
Specifies whether a new sheet will be created for every instance of the top-most group or not. This option is disabled by default.
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.