Export TO XXL from ALV Grid - Column order mismatch

[Former Member]

Hi All,

The user is trying to download data from Option -> Export -> Spreadsheet which will create XXL.

But while downloading there is mismatch in the order of columns displayed on the alv grid & columns downloaded.

All character fields are displayed on left, then date fields then quantity fields are downloaded to XXL. but in ALV Grid user has chosen a layout in which date fields come first.

Please help me to find solution

[rosenberg_eitan]

Hi,

What kind of ALV (cl_gui_alv_grid) ?

How the DL is done ? by custum code ?

Regards.

[Former Member]

Grid display using    'REUSE_ALV_GRID_DISPLAY'. From the alv grid output, user is trying to download data using export -> Excel . so for download there is no custom code.

We have copied standard report and added few more fields to the custom report. strangely Standard report also has this issue.

I searched for SAP notes also..no clue

[rosenberg_eitan]

Hi,

Good luck.

Regards.

[s_nnoorie]

Dear Manasa,

when you download data from option -> export....... it will download based on your internal table

format/sequence and not according to ALV display.

check your internal table.

[Former Member]

No. Export to Excel which creates XXL will take the user layout columns into consideration and creates excel with only chosen columns.

My issue is with date fields..even though date fields are first two columns in my chosen layout, while downloading the date columns are shifted right after all characteristic columns are displayed.

[s_nnoorie]

please send your fieldcatlog details.

[Former Member]

field catalog is populated using '   'REUSE_ALV_FIELDCATALOG_MERGE' with a custom structure created by copying standard structure and adding 2 new fields at the end.

[Former Member]

Found this SAP note, http://service.sap.com/sap/support/notes/1261582