multi-line footer totals grid excel extraction

[DrGiorgini]

Hello,

i created a grid with multi-line footer according to this example:

http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/totals-in-grid-footers

and added an excel export according to this tutorial:

http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview

but opening the extracted xls file file i see footer data messed up with values concatenated in a single cell.

How to get a proper xls extraction?

Regards.

[DrGiorgini]

For now, i am using a trick.
I am injecting totals into datasource so they are rendered in datagrid queued to other rows.
Handling ItemDataBound i can change background color for these added rows.

This is not exactly a clean solution but it works.

For the future, i think you should evaluate to implement multirows footers and aggregation with partitioning.

Regards.