Skip to Content

Blank column in excel download from ALV Grid


I went through multiple posts on SDN but could not find any solution to this problem.

I am using LVC_FIELDCATALOG_MERGE for building fieldcatalog. The structure has 9 fields out of which the first one is MANDT and last one is CELLTAB for setting cell level styles.

I also have 2 checkboxes to be displayed in the end of the list.


when downloading to excel using LOCAL FILE -> SPREADSHEET the checkboxes are getting downloaded to blank columns and the headings are on one column to the left of the values. It works fine if i do right click on select spreadsheet. The users want this option to work fine.

I have no clue what might be going wrong. Please help.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 20, 2018 at 05:52 AM

    Hi Salil


    Export the ABAP/ALV List to tab-separated ACSII text file - Convert the List to tab-separated ASCII format by FM LIST_CONVERT_TO_DAT, then export the data to local file by FM GUI_DOWNLOAD (FILETYPE=ASC). Symbols and Icons are ignored.

    See wiki:

    -> So it is normal that the "checkbox" can not be downloaded.

    "right click on select spreadsheet" uses different technology to export the ALV list, if you want to export symbols/Icons(like checkboxs) you have to use this option.



    Add comment
    10|10000 characters needed characters exceeded