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

Last updated on OCTOBER 18, 2016

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

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