Excel 2007 Data Limitations
Excel 2007 Data report output provides data for use in Microsoft Excel version 2007. These reports only contain minimal formatting. Default data formatting is applied to the data based on data type and assumes that each column has a single data type.
The output has these limitations:
- Includes Only the First List Query
The generated output includes only the first list query in the report. If a report contains multiple queries and the first query is a multi-dimensional query for a crosstab or for a chart, an error message is displayed when the report runs.
- Nested Frames/Master-Detail
Nested frames and master-detail links are not supported.
- Cell width/height
Cells in the Microsoft Excel file have a default width and height. You must adjust the column width and height if the data is larger than the default size.
- Styles
Style specifications are not rendered, including color, background color, and fonts.
- Borders
Borders are not rendered.
- User-specific Formatting
User-specified data formatting in the report specification are not applied, including exception highlighting and color rules for negative numbers.