OBIEe 11g: Export to Excel Results in Strange Characters when a Column has a Custom Format

(Doc ID 1473588.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Symptoms

In OBIEE 11.1.1.5.0, you use special characters on a column. But when you export the report to Excel the special characters do not show correctly.  For example, set the column data format to Custom Text Format and enter the following:

@[html]<span style="width:200px; height:50px">@</span>

When you export the result to Excel, you see something like:

@';">V5x Flip Phone

instead of:

"V5x Flip Phone"

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms