Skip Navigation
Expand
Report Columns conditionally formatted with an image are blank when exported to Excel or CSV
Answer ID 6580   |   Last Review Date 11/18/2018

When exporting a report to Excel or CSV, and the report contains a conditional format that replaces text with an image, why does exporting to Excel or CSV result in blank cells?

Environment:

Analytics, Exporting reports
Oracle B2C Service, All supported versions

Resolution:

This is expected behavior. When the report is exported it exports the display value (image) of the column and not the raw value (text) of the column definition. As images cannot be displayed in text type documents (i.e. Excel or .csv) the images are stripped when exported to text type files.

However, if you copy the report and edit the conditional formatting you can replace the images with 'Text Only', which will display as 'xxx' on the file you exported.  You must also uncheck the 'Include cell images' in the export options of your report.  You can edit the conditional formatting by following the steps below:

1.  right click on the column in the report.
2.  select 'Edit Format'.
3.  select the 'Conditional' tab.
4.  click 'Edit'.
5.  click the 'Format' tab.


For additional information, refer to the 'Change column options' section in the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.