Exporting a report to MS Excel

You can export a single report to .xlsx format. The report must be in View mode.

Note: Some functions are not supported in exports to MS Excel.

Select one of these output formats:

Format	Description
Excel Workbook	This format has these properties: Functions supported by Excel are exported as formulas Functions that are not supported by Excel are replaced by their values The content of hidden cells is visible if the cells are un-hidden in the exported file. Cells outside the visible area are exported as hidden Pictures are exported Visible Area is exported Print Area is exported Color Palette is exported Indentation in hyperblocks is exported Cell comments are exported Background image is exported
Excel Workbook, values only	This format has the same properties as the Excel Workbook format but with these exceptions: All formulas, whether or not supported by Excel, are replaced by the values that they return The content of hidden cells is not visible if the cells are un-hidden in the exported file Styles, conditional formats, column/row formats are applied. For example, if a cell has a conditional format and the condition is met, the format is applied to the cell in the exported file.

Format

Description

Excel Workbook

This format has these properties:

Functions supported by Excel are exported as formulas
Functions that are not supported by Excel are replaced by their values
The content of hidden cells is visible if the cells are un-hidden in the exported file.
Cells outside the visible area are exported as hidden
Pictures are exported
Visible Area is exported
Print Area is exported
Color Palette is exported
Indentation in hyperblocks is exported
Cell comments are exported
Background image is exported

Excel Workbook, values only

This format has the same properties as the Excel Workbook format but with these exceptions:

All formulas, whether or not supported by Excel, are replaced by the values that they return
The content of hidden cells is not visible if the cells are un-hidden in the exported file
Styles, conditional formats, column/row formats are applied. For example, if a cell has a conditional format and the condition is met, the format is applied to the cell in the exported file.