Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error in decimal when ALV exporting to EXCEL

Former Member

‎10-25-2017 2:19 PM

0 Kudos

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

0 REPLIES 0