on 04-23-2019 10:04 AM
While Downloading a CSV file into the Application server the value 1.10 is displaying as 1.1 this is an index and I have to show it as 1.10 . Tried differed modes in the open data set yet it is showing as 1.1. In this way we will not be able differentiate between 1.1 and 1.10. This works fine in ALV report and uses a character field. Is there any way we can do something to change be 1.10 when we download it as CSV or XLS file using open dataset statement?
Hi,
I guess you are trying to open the CSV file in the Excel . did you tried with Notepad ?
usally when you open the excel it changes the type to number and thus it won't show up the decimal with Zero. try to click on it and check its values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Matthew,
I am not clear with your reply on abap2xlsx, however I tried downloading in XLSX but it didnt work. Can i get some more information on abap2xlsx please.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
My bet is with Matt as well. When you use excel to provide input data always copy all and paste as values in a fresh sheet, this way the data that you see on screen is the actual data that is going to be processed.
Kind regards, Rob Dielemans
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My bet is the software you are using to look at the file once you've downloaded it is transforming the number. If you look at the file through a text editor, you'll find that it does contain 1.10
If you use abap2xlsx to make a true xlsx file, you'll be able to specify the column as character, and preserve the formatting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.