Financial Reporting (FR) Report Exported to Excel as Fully Formatted, the Grids and Text Replace Dash "-" with 0 (zero) in Excel Spreadsheet
(Doc ID 2044964.1)
Last updated on APRIL 29, 2021
Applies to:Hyperion BI+ - Version 184.108.40.206.501 and later
Information in this document applies to any platform.
You have a FR report in which a column and/or row has blank values, for example, "No Data".
In the report's Grid Properties box, "No Data" is replaced with a dash "-".
In Workspace, you perform HTML Preview on the report. Next, you click on the active link "Fully Formatted Grids and Texts". When the report is exported to Excel, the dash(-) symbol is replaced by "0" in the Excel spreadsheet.
You have already applied Patch 19570230 (Patch Set Update: 220.127.116.11.503 for Oracle Hyperion Reporting and Analysis Financial Reporting Release 18.104.22.168.500) or higher on Financial Reporting Web Application server.
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