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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Export to Excel - Grand Totals / Totals showing even they are disabled

Thread ID:





145876 Jul 11,2019 06:37 PM UTC Jul 26,2019 02:05 PM UTC WinForms 2
Tags: PivotGridControl
Bilal Raja
Asked On July 11, 2019 06:37 PM UTC

I have disabled the Grand Totals / Totals in Pivot output grid. However, when I export data to excel, column and row totals / grand total is also exported. Screen Shots are attached.

I dont want totals in my export file.

Attachment: ScreenShot_2f765113.rar

Thirupathi Bala Krishnan [Syncfusion]
Replied On July 12, 2019 01:55 PM UTC

Hi Bilal Raja,

We are able to reproduce the reported issue –“SubTotal values are displayed in the excel document even when setting ShowSubTotals value as false” in our end  and we have logged an issue report for the same. We will provide the patch file for the reported issue on 26th July, 2019.

Here we have provided private feedback link, we request you to log in to view the link further. The fix will be available in our next main release Volume 3 release which is scheduled to be rolled out in Sep, 2019. 

feedback link: https://www.syncfusion.com/feedback/7466/subtotal-values-are-displayed-in-the-excel-document-even-when-setting-showsubtotals-value-as-false

If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal.

Please let us know if you need any further assistance.

Thirupathi B. 

Thirupathi Bala Krishnan [Syncfusion]
Replied On July 26, 2019 02:05 PM UTC

Hi Bilal Raja, 
Thanks for your patience.    
We have fixed the below reported issue “SubTotal values are displayed in the excel document even setting ShowSubTotals value as false” in your reported version Refer the screenshot for your reference.

Normal pivot grid:

Exported pivot grid (Cell mode): 

Please find the patch file from the following location.
Recommended approach – exe will perform automatic configuration            
Please find the patch setup here:                                  
Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment                             
Please find the patch assemblies alone from:             
Please find the Nugets from the below location:            
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
Please note that we have created this patch for the version specifically to resolve the issues reported in this incident #241846. If you have received other patches for the same version for other products, please apply all patches in the order received. This fix will be included in our 2019 Volume 3 release which will be rolled out in September, 2019.    

Thirupathi B. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon