ALV Excel export format XXL & MHTML

[Former Member]

Hi Experts,

In the ALV export to Spreadsheet there are several formats to choose from. MHTML follows the screen column order (or as set in fieldcat). But XXL format moves the columns around -- columns with floating number are shifted to the very end of a row.

Is there a way to make XXL respect the column order as set in the Field Catalog? I know MHTML format can be a workaround. But users have used XXL for most of other reports, I don't want to make an exception.

Thank you!

Pulau

[Former Member]

Hi Experts,

In the ALV export to Spreadsheet there are several formats to choose from. MHTML follows the screen column order (or as set in fieldcat). But XXL format moves the columns around -- columns with floating number are shifted to the very end of a row.

Is there a way to make XXL respect the column order as set in the Field Catalog? I know MHTML format can be a workaround. But users have used XXL for most of other reports, I don't want to make an exception.

Thank you!

Pulau

[Clemenss]

Hi Dan,

no, I don't think so. MHTML is really what-you-see-is-what you get, ABAP uses it internally for the data transfer for inline excel (application running in control area) and everything is retained including sort orders, totals and subtotals and cell colors.

I think you can get your users used to MHTML. Probably if you rename it to .xls excel will open it anyway.

Regards,

Clemens

[Former Member]

If you make all the column have a character base then the output to Excel will not move columns about.

The relocation of columns seems to happen for numbers and dates. It is frustrating I know but as the other post said use the HTML format is better.