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.

Mon Feb 26, 2018 4:26 pm

Hello,

In Excel we have an option to Automaticly set size column on update and i want to uncheck it :)

PivotTableOption.png
PivotTableOption.png (35.62 KiB) Viewed 2824 times


I don't find the property on XlsPivotTable.Options.

Code: Select all
XlsPivotTable pt = workbook.Worksheets[0].PivotTables["TCD"] as XlsPivotTable;
pt.Options... // I don't know ??


Could you help me on this point ?

Secondly, when i load and save (with Spire 7.12.144) an Excel file with this option unchecked. When i open the save file, option is checked.


Thanks for your help

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Feb 27, 2018 6:53 am

Dear Vincent,

Sorry that our Spire.Xls doesn't support operating the option at present. We will consider adding it as a new feature into our upgrade list. If it can be achieved in the future, we will inform you. Besides, I tested your second case and indeed found the issue. It has been logged it into our bug tracking system. Once it is fixed or there are some updates for you, we will let you know.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Feb 27, 2018 1:25 pm

Hello,

Ok, Do you have an idea of the release date of the corrective version ?

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Feb 28, 2018 1:30 am

Hello,

I'm sorry that i don't have any idea about the release date at the moment. Our dev team will analyze the issue and we will let you know once there is any significant progress.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Wed Aug 01, 2018 9:21 am

Dear VincentB,

Thanks for your patient waiting.
The reported issue has been fixed and the option (Autofit column widths on update) is available now. Please download the hotfix (Spire.XLS Pack(Hotfix) Version:8.8.0) and use code below to test.
Code: Select all
pt.Options.IsAutoFormat = false;

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Aug 21, 2018 3:37 am

Dear VincentB,

Greetings from E-iceblue.
Did we fix your issue?
Your feedback will be greatly appreciated.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS