Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue May 28, 2013 12:00 pm

how to set subtotals at top. could any one help please..

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Wed May 29, 2013 3:57 am

Dear chaitanya,

Thanks for your inquiry.
The default value of subtotalTop property of PivotField is true. So you only need to ensure that your PivotTable has at least two fields in Row area. I provide you a demo as a reference.

There is any issue, please feel free to contact us.

Regards,
Amy
E-iceblue support team
Attachments
SubTotalTop.zip
(55.56 KiB) Downloaded 345 times
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue Jun 04, 2013 9:11 am

Hello,

Has the demo provided by Amy been useful for you? Has the issue been resolved? Could you please update the thread if convenience?

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Jun 04, 2013 1:23 pm

Dear Amy,

could you please let me know how to set subtotalstop to false for any pivot field.

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Wed Jun 05, 2013 7:06 am

Dear chaitanya,

Thanks for your inquiry.
Sorry for that there is a bug in subtotalTop property of PivotField, but our dev team has fixed this bug now.
Our test team is testing the fix. Once the fix is ok, we will release a new version of Spire.Xls and tell you.

Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Wed Jun 05, 2013 9:13 am

sure Amy. Thanks for your support.

chaitanya
 
Posts: 12
Joined: Thu May 16, 2013 10:42 am

Mon Jan 20, 2014 7:15 am

Dear chaitanya,

Thanks for your waiting.
A new version of Spire.Xls has been released. Welcome to download Spire.XLS Pack Version:7.2(http://www.e-iceblue.com/Download/downl ... t-now.html) and test it.

Have a nice day.

Best wishes,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Thu Jan 23, 2014 9:37 am

Dear chaitanya,

Have you tested Spire.Xls_7.2? How did it work?
Thank for your feedback.

Best wishes,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS