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 30, 2018

Applies to:

Hyperion BI+ - Version 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: for Oracle Hyperion Reporting and Analysis Financial Reporting Release or higher on Financial Reporting Web Application server.


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