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 MARCH 14, 2019

Applies to:

Hyperion BI+ - Version 11.1.2.3.501 and later
Information in this document applies to any platform.

Symptoms

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. 

Changes

 You have already applied Patch 19570230 (Patch Set Update: 11.1.2.3.503 for Oracle Hyperion Reporting and Analysis Financial Reporting Release 11.1.2.3.500) or higher on Financial Reporting Web Application server.

Cause

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
Symptoms
Changes
Cause
Solution
References


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