Financial Reporting Export To Excel Results In Values Being Treated As Text (Doc ID 1531035.1)

Last updated on AUGUST 08, 2017

Applies to:

Hyperion BI+ - Version 11.1.2.2.302 to 11.1.2.2.303 [Release 11.1]
Information in this document applies to any platform.
This knowledge document is a replacement for 1541030.1, 1530964.1 which have been deleted.

Symptoms

When exporting Financial Reporting report Microsoft Excel, a quote mark is being added to values with decimals.  This is resulting in values being treated as text.

A scenario where the problem is seen:

  1. Run the FR report in HTML preview
  2. Export it from File > Export > Excel
  3. In resulted Excel sheet, click on negative number or a number with decimal places
  4. An additional quote in Excel can be seen e.g. the data in cell begins with a single quote "  '  "
    (Excel cell data beginning with a single quote are considered text and not numeric values)

Note : Values that do not have a decimal set, do not encounter this problem.

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