- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- ALV Grid Exporting to Excel - Columns out of order
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ALV Grid Exporting to Excel - Columns out of order
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2008 6:03 PM
Hi,
In my ALV grid everything is in order as it is in the structure. When however I export to excel from ALV grid, the columns are out of order. First it lists the string columns, then number columns and lastly date columns. Is there a way to make excel keep the same order as it is in ALV grid?
Thanks,
Sergiy
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2008 4:21 AM
Don't see any issue with Program or SAP.Take a help of the Excel expert and ABAPER(Hope you are) sit together ,and try to figure out.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2008 4:21 AM
Don't see any issue with Program or SAP.Take a help of the Excel expert and ABAPER(Hope you are) sit together ,and try to figure out.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2008 2:44 PM
I am not much of an ABAPer but I was able to set the column position during data declaration with
gs_fcat_line-col_pos = 1, for example.
That would put the column in the first position in ALV as well as the excel export.
Thanks for your inputs.
Sergiy
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2008 5:50 AM
