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 Aug 05, 2014 1:38 am

Hello,

Thanks for your inquiry.
Please firstly caculate, then autofit.
Code: Select all
pt.CalculateData();
sheet2.AutoFitColumn(1);
sheet2.AutoFitColumn(2);

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 Aug 05, 2014 8:28 am

Hi,

I don't see method
pt.CalculateData();

thank

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Tue Aug 05, 2014 9:19 am

Hello,

Thanks for your feedback.
Sorry that there is no the pt.CalculateData() method in the current newest office version, which is only included in the newest XLS version. And we are planning to build a new office version. Once it is released, we will let you know immediately. Sorry for inconvenience.
Sincerely,
Gary
E-iceblue support team
User avatar

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

Tue Aug 05, 2014 3:26 pm

ok, but version 2.9 not resolve problem ??
and is possible font size text for table pivot ??
thank

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Wed Aug 06, 2014 7:15 am

Hello,

Yes, it is not resolved in the Spire.Office version 2.9, which will be fixed in the next version our test team is testing.
Sorry that it is impossible to change font size for table pivot. It seems that even the Microsoft Excel don't allow(see screenshot).
Sincerely,
Gary
E-iceblue support team
Attachments
1.PNG
1.PNG (17.72 KiB) Viewed 2275 times
User avatar

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

Fri Aug 29, 2014 6:32 am

Hello,

The newest hotfifx of Spire.Office has been released, the calculate method has been included in it, you could download Spire.Office Platinum (Hot Fix) Version:2.9.3 and try it.
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

Return to Spire.XLS