My Oracle Support Banner

OBIEe 11g: Export to Excel Results in Strange Characters when a Column has a Custom Format (Doc ID 1473588.1)

Last updated on DECEMBER 24, 2020

Applies to:

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


In OBIEE, 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:

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

@';">V5x Flip Phone

instead of:

"V5x Flip Phone"



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.