Skip to Content

Scientific Notation or Exponential Value while export/download to Excel from ALV

Folks

Some of the values from a custom ALV output are downloaded in an exponential format or scientific notation while exporting to an excel file.


One value is okay on expanding the column but there is another field value of length more than 45 characters and it does not convert to correct value.


Please suggest me with a resolution. Thank you.


Capture2.JPG (36.2 kB)
Capture1.JPG (18.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Apr 20, 2016 at 04:02 PM

    This is a problem with Excel display. Excel considers it as a number because there are only numeric characters in that field. And there is a limitation in Excel on how big a number can be shown.

    Please try to use newer methods to download data from SAP, and they will make the field as a String in Excel.

    Thanks,

    Juwin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.