Dear all

We made a form that calls a report {forms and report is 10g R2}
When we call a report and define the destination type is SPREADSHEET
The browser ask the user to SAVE or Open the file in Excel
However the case
is the report contain the filed varchar2 and this filed in like a number but it is a varchar2 and this filed starting with ZERO this ZERO will truncated
And id the field is the long number the field goes to small number with special formats
Like the following
1401015080001 >> goes to >> 1.40102E+12
And
001234567 >> goes to >> 1234567
I am using excel 2007 this is a company policy.
How can I export the data as varchar2 and prevent the Excel to change the filed data types

أخي العزيز

انا واجهت نفس المشكلة

وما لقيت حل

وغير ذلك أن ترويسة الحقول ليست فوق الحقول تماما

وشكرا