topic Re: ALV XLS format problem in Application Development and Automation Discussions

ALV XLS format problem

Former Member — Thu, 17 Dec 2009 05:06:12 GMT

In some of the reports when we view the ALV output in xls format(in GUI) the totals are not showing.The total are coming properly in theALV grid format and it is also showing correct when we download it into local file in xls format. Anyone please help me with this problem.

Thx to all in advance

Re: ALV XLS format problem

former_member194669 — Thu, 17 Dec 2009 05:15:37 GMT

Any filters set, sort criteria, totals calculated and subtotals are not taken into account for the transfer to the spreadsheet.

When you transfer to as local file then file is not generating as excel file its simple TXT only difference is extension will show as XLS, you can open this file in notepad also

a®

Re: ALV XLS format problem

Former Member — Thu, 17 Dec 2009 05:30:36 GMT

Thx for the reply

but no filter criteria set or sub totaling done in the reports.

Re: ALV XLS format problem

former_member194669 — Thu, 17 Dec 2009 05:31:56 GMT

it include totals calculated in ALV grid also

a®

Re: ALV XLS format problem

Former Member — Thu, 17 Dec 2009 06:19:34 GMT

totals calculated in ALV grid is not getting included in the xls view