APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Spreadsheet displaying varchar2 fields as 1.23457E+15

623307Feb 14 2008 — edited Feb 20 2008

My table is set for all fields as varchar2. I am able to load from a text file and display in the APEX report just fine. When I open the generated spreadsheet, I loose the actual value for numeric codes such as account numbers. They display as 1.23457E+15 instead of 16 digits. Also leading zeros are lost.

Any idea how to maintain text formatting in the spreadsheet?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2008

Added on Feb 14 2008

#apex-discussions

3 comments

564 views