Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ALV Export to excel (spreadsheet) without line break

my ALV report contains 76 columns, if i try to download it in an excel sheel its not getting displayed in correct format.

Few columns are automatically displayed in the second row and also all my values are getting collapsed due to this display.

In the print preview also i am getting the same problem.

Is there any column limit in ALV display or i can make it to get display correctly as it is in the exact output.

ALv reports contain various options such as sort,filter,print preview, download to excel etc....in this if i use the download to excel option in the excel sheet its getting displayed as col1,col2,col3.......col54

col55,col56.................col75

but i need the output to be in a single line such as col1,col2,col3,.........col75

I do not want the line break.

Edited by: Suhas Khengle on Oct 1, 2008 11:50 AM

Tags:
Not what you were looking for? View more on this topic or Ask a question