Excel attachment downloaded from SOST rounding off the columns

[former_member565051]

Hello,

While downloading the Excel file from the SOST, the column (eg. Idoc no.) is automatically rounding to the nearest decimal.

For eg. If idoc number is 5000000009681031, in the excel it will be displayed as 5000000009681030.

Problem seems to be in Dev system only. When i try the same report in Sandbox, the values are coming correctly.

Is there any setting we need to do for system specific? or any excel settings?

TIA,

Ajay

[FredericGirod]

Are you sure this is how the file is stored ? and not Excel doing this ?

A lot of time, the file suppose to be excel file is a simple CSV. So just drag and drop this file in a notepad app. and check the value

[abo]

frdric.girod

rule of thumb, when people say "Excel file" it usually isn't 🙂

Also, SOST does not care about the files' content, as long as they have the proper attachment type the rest is up to the users / developers.

[FredericGirod]

scot has a transformation tool, to convert the format (oss note 762870)

[Sandra_Rossi]

You must understand the difference between texts and numbers in Excel, to make it work correctly. For numbers, Excel guarantees only a precision up to 15 digits. As IDoc numbers may have up to 16 digits, you should format the column of IDoc numbers as text.

[former_member565051]

sandra.rossi

Thanks for the help. Yes the issue is with Idoc number range. It is 17 in the Dev while its 9 in sandbox. Excel has some limitations it seems.

[Sandra_Rossi]

Please use the COMMENT button for comments, questions, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

[Sandra_Rossi]

IDoc number = 16 digits maximum in SAP.