Skip to Content
0

Blank column in excel download from ALV Grid

Mar 05 at 12:09 AM

72

avatar image

All,

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.

I am using SET_TABLE_FOR_FIRST_DISPLAY

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.

Regards,

Salil

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Tom Wan
Mar 20 at 05:52 AM
0

Hi Salil

"LOCAL FILE -> SPREADSHEET" means:

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: https://wiki.scn.sap.com/wiki/x/O7yyGw

-> 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.

Regards

Tom

Show 2 Share
10 |10000 characters needed characters left characters exceeded

So the solution would be to write your own Excel download program, triggered by a custom button.

0

Thanks all for your answers. We have asked users to right click and opt for download.

0