Download ALV output to XLSX - unexpected 0 in case of fieldcat no_zero = 'X'

[bull_chen]

Hello Guru,

When download ALV view output to XLSX with effective of field category option "no_zero = 'X'", and with column being set as numeric type P, the XLSX sheet still keeps 0 on those column which I don't want.

Is there any available option to remove 0 in downloaded Excel (.XLSX) file as same as the numeric output behavior in ALV view screen?

How can we resolve this issue?

BR Bull

[matt]

This is done by Excel. The column is numeric, so in Excel it's numeric. And that means a zero.

You could make the column character.