I'm having a problem exporting an ALV to EXCEL. The values are displayed correctly in the ALV, the properties of the fieldcat are:
wa_dyn_fcat-ref_field = 'KNAFA'. wa_dyn_fcat-ref_table = 'ANLC'.
ANLC-KNAFA is a CURR.
When I export to Excel fields that have decimals ending in 00 or 0 they disappear, for example:
In ALV: 100,00- / In EXCEL: -100
In ALV 200,30- / In EXCEL: -200.3
(real example) In ALV 3.900.000,00- / In EXCEL -3,900,000
But this occurs only when the value is negative, changing the value to positive in the debug does not occur
I do not know if the problem can be this conversion of punctuation '.' and ',' what is happening in EXCEL
Every help is welcome