topic Re: Data changes while exporting table into excel file in SAP in Application Development and Automation Discussions

Data changes while exporting table into excel file in SAP

Former Member — Fri, 15 Jun 2012 12:53:46 GMT

Hi All,

We have very wiered situation as mentioned below.

While exporting the table into excel file the data gets changed.

for eg if ean code is 871715494100083383 then will downloading into excel the data gets changed to 871715494100083000.

Only the last 3 digits of data gets changed to 0.

Has any faced the same issue before ?

Thanks in Advance,

With Regards,

Haresh Lathia

Re: Data changes while exporting table into excel file in SAP

former_member213851 — Fri, 15 Jun 2012 13:09:13 GMT

Hi Haresh,

You are using BDC or downloading from ALV download functionality?

Re: Data changes while exporting table into excel file in SAP

Former Member — Fri, 15 Jun 2012 14:20:33 GMT

maybe we should have another forum, named like "OMG I have to deal with Excel." If you want it handled as text, put quotes around it, or a ' on the front of the number. Excel, in its inherent MS-installed brilliance, is converting based on what it is coded to do, which is guess at what the correct format should be. Better yet, IMHO, put the output into a compressed, tab-delimited file named like .txt and let the user import it and do what they want.

Re: Data changes while exporting table into excel file in SAP

SuhaSaha — Fri, 15 Jun 2012 14:33:59 GMT

Break Point wrote:

 Better yet, IMHO, put the output into a compressed, tab-delimited file named like .txt and let the user import it and do what they want.

That's exactly what i propose when someone asks me to import an excel in SAP

Re: Data changes while exporting table into excel file in SAP

Former Member — Fri, 15 Jun 2012 15:10:53 GMT

Hi Haresh,

As per excel behaviour if you enter more than 15 digits in a cell which is formatted to have number it would change the digits after 15th to zero. This is due to some flaoting point number calculation specification used by Excel. Work around is to format the target cell as Text.

HTH

Re: Data changes while exporting table into excel file in SAP

Former Member — Fri, 15 Jun 2012 15:30:16 GMT

Absolutely...my tiny pea-brain doesn't want to deal with... what? MS Binary ?? or Open XML?? either....but a tab-delimited text file, we can do ANYTHING (just about) with that....

in or out, apps server or desktop, tab-delimited is the way to operate.