Skip to Content
0
Former Member
Oct 04, 2011 at 08:48 AM

Column shifted during Local file download in ALV Grid

819 Views

Dear Experts,

I have an ALV grid editable report program. The program is developed to maintain custom table data.

The table data will be maintained using this report. User can edit the data and can save it. In this report there are some columns which are defined as checkbox (fieldcat-checkbox = 'X'.).

I have the buttons "Excel Upload" and "Download Template" in the application tool bar of ALV display.

Users can use the "Download Template" which can be used to get the exact excel format.

But sometimes they just download the data into the Local PC file (Excel format), modify the excel data (remove ALV header and space rows) and upload by using the ALV button.(ALV Tool : cl_gui_alv_grid=>mc_mb_export)

While downloading I observed the ALV column values which have defined as checkboxs have shifted to next one in Excel file.

Do any one now how to resolve this error? The column values which are defined as "Check box" (fieldcat-checkbox = 'X', (fieldcat TYPE lvc_s_fcat) should not be shifted to next column in Excel during SAP standard ALV Grid download

(ALV Tool : cl_gui_alv_grid=>mc_mb_export).

I am checking the ALV layout parameters. But doesn't help. If any one knows the solution please share it with me.

Thank you.

Kind Regards,

Senthilraj S