Grid exported to excel with footer template instead of group footer template

[Bill Naples]

When exporting a grid containing both group footers and footers to Excel, on the group footer rows, the footer templates are rendered instead of the group footers.

See attached demo, along with screenshots below of the displayed page as well as the excel export.

Attachment: SyncFusion_19.3_Grid_Footer_Excel_67020aaf.zip

[Ajith Govarthan]

Hi Bill Naples, 

Thanks for contacting Syncfusion support. 

Based on your query, you are facing group footer export issue in your Grid application. So, we have checked your attached sample found that you have used one aggregate column definition for both GroupFooter and Footer rows. So, to export the group footer and footer rows properly we suggest you use separate aggregate column definitions for GroupFooter and Footer. For your convenience, we have attached the code example, please refer them for your reference. 

Code Example: 

App.vue 

    aggregates () { 

      return [ 

        { 

          columns: [ 

            { 

              field: 'name', 

              type: 'Count', 

   

              footerTemplate: 'NAME FOOTER' 

            },{ 

              field: 'name', 

              type: 'Count', 

              groupFooterTemplate: 'NAME GROUP FOOTER',  // use separate column definitions 

              

            } 

            , 

            { 

              field: 'items', 

              type: 'Sum' 

            }, 

            { 

              field: 'price', 

              type: 'Sum' 

            } 

          ] 

        } 

      ] 

    } 

  }, 

Please get back to us if you need further assistance. 

Regards, 

Ajith G. 

[Bill Naples]

Thank you Ajith for the reply and the workaround. We'll plan to take a look at using separate aggregate columns for footer and group footer. Take care.

[Balaji Sekar]

Hi Bill, 

Thanks for your update. 

 

Let us know if you have facing any issues while implementing your requirements 

Regards, 

Balaji Sekar.