multi-line footer totals grid excel extraction

2 posts, 0 answers
  1. DrGiorgini
    DrGiorgini avatar
    11 posts
    Member since:
    Jul 2010

    Posted 14 Sep 2017 Link to this post

    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.

  2. DrGiorgini
    DrGiorgini avatar
    11 posts
    Member since:
    Jul 2010

    Posted 18 Sep 2017 in reply to DrGiorgini Link to this post

    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.

Back to Top