The Output Defaults allow you to configure system-wide Excel output settings for exporting your Prospero reports to an Excel spreadsheet. To open the Output Options screen, select Output Defaults on the left panel. The default out-of-the-box Prospero setting is for all options to be selected.
Output Defaults options include:
•Number Formatting – Indicates that the number formatting defined on the Prospero report (Line, Column, or Report Definition) will be preserved when exporting. If this is not selected, your standard Excel settings will be applied. For more information see Column Number Format, Line Number Format and Report Number Format.
•Fonts – Indicates that the font defined on the Prospero report (Line, Column, or Report Definition) will be preserved when exporting. If this is not selected, your standard Excel settings will be applied. For more information see the Column Tool Definition Ribbon, Line Tool Definition Ribbon and Report Number Format.
•Text Color – Indicates that the text color defined on the Prospero report (Line, Column, or Report Definition) will be preserved when exporting. If this is not selected, your standard Excel settings will be applied. For more information see the Column Tool Definition Ribbon, Line Tool Definition Ribbon and Report Number Format.
•Background Color – Indicates that the background color defined on the Prospero report (Line, Column, or Report Definition) will be preserved when exporting. If this is not selected, your standard Excel settings will be applied. For more information see the Column Tool Definition Ribbon, Line Tool Definition Ribbon and Report Number Format.
•Hidden Rows – Indicates that rows defined on the Prospero report as hidden (using the “Suppress” Line Definition field, will be included when exporting. These rows will be minimized to “appear” as the original report does, however, maximizing the row height will show the row’s values. If this is not selected, any rows which are hidden on the report will not be included in the export. For more information see the Line Definition Suppress.
•Vertical and Horizontal Lines – Indicates that the lines (and their weight) defined on the Prospero report (Line, Column, or Report Definition) will be preserved when exporting. If this is not selected, your report’s lines will not appear on the report.
Note: For your lines to appear in the color in which they are defined in Prospero you must also select the “Text Color” option.
For more information refer to the Underline and Vertical Line fields.
•Use Excel Page Headers – Indicates that the Report Headers for this Report will be exported into Excel’s Page Headers rather than being exported as repeating rows at the top of the spreadsheet. Formatting such as fonts and colors may not export for the header rows if this option is used.
•Use Excel Page Footers – Indicates that the Report Footers for this Report will be exported into Excel’s Page Footers in order to allow them to repeat at the bottom of each printed page. Formatting such as fonts and colors may not export for the footer rows if this option is used.
Remember that any of the Output Defaults that you set in Options may be overridden when you define your specific report’s Report Definition.