Exporting To MS Excel 2003 From Discoverer 11g Produces Incorrect Macros (Doc ID 1568529.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Discoverer - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

In 11g version of Discoverer, when using Excel to open an exported workbook having totals, with macros enabled, the following error occurs:


ERROR
-----------------------

The formula you typed contains an error.
 - For information about fixing common formula problems, click Help.
 - To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group)
 - If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').


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