My Oracle Support Banner

BI String Field is Exported To Excel as Numeric Field (Doc ID 980572.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Utilities Business Intelligence - Version: 2.2.0 to 2.2.1 - Release: 2.2 to
Information in this document applies to any platform.

Symptoms

When exporting a zone's data to excel, if a field of the zone is defined as STRING, but is only composed by numbers,the field is exported as a numerical filed, and accordingly the value of the excel field is not displayed correctly when the numeric value is big enough determining Excel to convert the number to scientific notation. (For example Excel is showing the scientific notation "1,00909E+12" instead of the STRING "1009086035505".)



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

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