Inconsistent Behavior of Conditional Formatting When Exporting to Excel
(Doc ID 2691389.1)
Last updated on SEPTEMBER 01, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Conditional formatting may not be applied to all rows when exporting to excel. In this case, conditional formatting may be lost around latter part (3/4) of reports in exported Excel file.
This issue can be reproduced with next conditions
- Union Report is created
- Set Column Properties > Conditional Format in the report (For example, if ColumnA is greater than 100% then set background color to Red)
- At the bottom of the dashboard, click on Export link->Excel 2007+
- Only happens to excel file more than 300 rows
In detail, conditional formatting applies only to the cells that has the values in the dashboard page. Whereas in the exported Excel, conditional formatting applies to the whole line.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document