Financial Reporting Export To Excel Results In Values Being Treated As Text
Last updated on AUGUST 08, 2017
Applies to:Hyperion BI+ - Version 126.96.36.199.302 to 188.8.131.52.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.
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:
- Run the FR report in HTML preview
- Export it from File > Export > Excel
- In resulted Excel sheet, click on negative number or a number with decimal places
- 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.
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