Skip to Content
Mar 02, 2006 at 12:40 AM

ALV download: retain column sequence in excel


Good people,

I wish to download an alv report to excel but keep the column sequence in excel identical to that displayed in alv.

Currently what happens is the basic sequence is kept but 'non-char' fields are moved to the end, eg my alv displays postcode, region, credit limit(non-char), industry... BUT in excel after downloading this is changed to postcode, region, industry, credit limit.

I have tried setting the 'fix_column' fieldcat attribute for all fields but this seems to have no effect.

Any ideas?