We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Excel export Not working when using aggregates in footer

Error:

Grid :

​​<ejs-grid id="roleDesignGrid" height="100%"

                              ref="roleDesignGrid"

                              :data-source="forecastPlannings"

                              :created="initGrid"

                              :allow-paging="false"

                              :allow-resizing='true'

                              :allow-sorting='true'

                              grid-lines="Both"

                              :page-settings='settings.pageSettings'

                              :record-click="onRecordClick"

                              :query-cell-info='customiseCell'

                              :context-menu-items="menuItems"

                              :context-menu-click='contextMenuClick'

                              :allow-filtering='true'

                              :filter-settings='settings.filterOptions'

                              :allow-excel-export='true'

                              :allow-text-wrap="'true'"

                              :command-click='onCommandClicked'>

                        <e-columns>

                            <e-column field="roleName"

                                      header-text="@_localizer["job"]"

                                      text-align='Center'

                                      :filter='settings.filter'

                                      :allow-editing='false'

                                      width="250" :columns='jobColumns'></e-column>

                            <e-column :header-text="headerYear"

                                      :allow-filtering="false"

                                      :allow-sorting='false'

                                      text-align='Center'

                                      width="120" :columns='quarterColumns'></e-column>

                            <e-column :commands='settings.commands' header-text='@_localizer["actions"]' text-align='Center' width="100"></e-column>

                        </e-columns>

                        <e-aggregates>

                            <e-aggregate>

                                <e-columns>

                                    <e-column type="Text" field="roleName" text-align='Right' :footer-template='roleNameFooterSum'></e-column>

                                    <e-column type="Sum" field="q1" :footer-template='q1FooterSum'></e-column>

                                    <e-column type="Sum" field="q2" :footer-template='q2FooterSum'></e-column>

                                    <e-column type="Sum" field="q3" :footer-template='q3FooterSum'></e-column>

                                    <e-column type="Sum" field="q4" :footer-template='q4FooterSum'></e-column>

                                </e-columns>

                            </e-aggregate>

                        </e-aggregates>

                    </ejs-grid>


1 Reply

JC Joseph Christ Nithin Issack Syncfusion Team February 22, 2023 11:21 AM UTC

Hi Sujon,


  Greetings from Syncfusion support.


  Based on your query, when you try to perform excel export with aggregates and stacked header script error was thrown. We tried to reproduce the same by creating a sample from our side, but unfortunately, we were not able to reproduce the issue. We have shared the sample for your reference.


Sample: https://codesandbox.io/s/syncfusion-grid-row-not-updated-forked-3bgtfi?file=/src/components/HelloWorld.vue


Kindly refer the sample, if you still face the issue, kindly share an issue reproducible sample or try to reproduce the issue in the sample shared.


Regards,

Joseph I.


Loader.
Live Chat Icon For mobile
Up arrow icon