11g: Export To Excel File Fails to Open. Excel errors with: "We found a problem with some content..." When Total Label contains # (Doc ID 2244342.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.2.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Goal

Worksheets exported to Excel cannot be opened by Excel if Totals or Subtotals contain special character in the label.  Excel throws the error :


How can this be resolved?
 

Solution

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