Skip to Content
0

Error in decimal when ALV exporting to EXCEL

Oct 25, 2017 at 01:19 PM

45

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers