Skip to Content
0
Former Member
Oct 25, 2017 at 01:19 PM

Error in decimal when ALV exporting to EXCEL

213 Views

Hi,

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