Export to Excel Displays 0 (No Data) As Hash Marks In Cells And As "1.79769313486232E+308" In Formula Bar.
(Doc ID 2893100.1)
Last updated on AUGUST 30, 2022
Applies to:
Oracle Planning and Budgeting Cloud Service - Version 22.01.25 to N/A [Release 22.0 to 11.1]Oracle Enterprise Planning and Budgeting Cloud Service - Version 22.01.25 and later
Oracle Financial Consolidation and Close Cloud Service - Version 22.01.25 and later
Information in this document applies to any platform.
Symptoms
A Financial Reports (FR) report utilizes grid suppression whereby No Data default value of #MISSING is replaced with 0 (zero). When the report is transferred to Excel, the 0 (No Data) is displayed as hash marks in cells. In addition, selecting these cells in return display "1.79769313486232E+308" from Excel's formula bar.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
A. Explore Repository
- Perform HTML Preview on the report.
- From the menu bar, select File->Export->Excel.
B. Smart View
- From Smart View add-in, import the report into Excel.
C. Reports card.
- From Financial Reports tab, click on the XLS icon of the report and save output as an xlsx file.
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 |
| Cause |
| Solution |
| References |