Skip to Content
Apr 30, 2020 at 09:19 AM

Excel download - Decimal part missing in Excel (.xls ) download using GUI_DOWNLOAD

114 Views Last edit Apr 30, 2020 at 02:57 PM 3 rev


I had posted a similar query earlier. But this one is more specific to the excel download of report using GUI_DOWNLOAD. My program uses FM 'GUI_DOWNLOAD' to generate an excel in the desktop folder from report built on query-infoset. The report is predominantly having Amounts (in multiple currency format) and their dates. The requirement was to download the excel with the selected list of columns in the format similar to what user has maintained in SAP.

Issue with date format could be fixed by passing 'X' in the GUI_DOWNLOAD FM against the dat format option. And with the value / amount format, i noted that this could be fixed by making the number format in SAP and windows the same; This worked well to a good extent. But issue i face now is decimal part in downloaded excel is being truncated (or decimal portion is not available) if the decimal part is zero in a particular cell in ALV. But if there is a decimal part corresponding to the value, then that becomes available.(Eg. If in ALV its 0,00 excel will show only =,; but if its 1,10 excel will show 1,1. Similarly if the ALV has 1,23 excel will show 1,23 and so on,) So user has to edit the formatting every time they download this in desktop, when they face this case(it understand this doesnt make sense, but user wants decimal to be shown in excel output)

Is there an option to download into excel with the decimal portion in place whether it is 0 or not. Request your inputs.