My Oracle Support Banner

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 OCTOBER 24, 2022

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.