Export To Excel From Report 10g Without Changing Field Type

[mtdeep2002]

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

[ashraf76]

أخي العزيز

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

وما لقيت حل

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

وشكرا