Financial Reporting Export To Excel Results In Values Being Treated As Text
(Doc ID 1531035.1)
Last updated on JANUARY 07, 2020
Applies to:Hyperion BI+ - Version 220.127.116.11.302 to 18.104.22.168.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.
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