Save a Excel File with Pivot Table and Slicers

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Save a Excel File with Pivot Table and Slicers

Postby VincentB » Thu Jul 20, 2017 2:47 pm

Hello,

I have an issue if i save an Excel file with Pivot Table and Slicers.
When i try to open "Sample-Spire.xlsm" with Excel, i have a message "Sorry ... We found a problem with the content of "Sample-Spire.xlsm", ... ",
And Slicer are missing !

Code: Select all
var workbook = new Workbook();
workbook.LoadFromFile("...Sample.xlsm");

// Test 1
workbook.Save();

// Test 2
workbook.SaveToFile("...Sample-Spire.xlsm", ExcelVersion.Version2013);


I have make 2 test:
Test 1 : simple save (in same file)
Test 2 : Save in other file with Excel Version
But i have the same result.

Do you have a solution ?

I use Spire.xls_7.12.27

Thanks
Attachments
Sample.zip
(91.2 KiB) Downloaded 9 times
VincentB
 
Posts: 78
Joined: Thu Sep 15, 2016 9:44 am

Re: Save a Excel File with Pivot Table and Slicers

Postby Betsy.jiang » Fri Jul 21, 2017 2:00 am

Dear VincentB,

Thanks for your feedback.
I have reproduced the issue and forwarded it to our Dev team. We will inform you once there is any progress.
Sorry for the inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1424
Joined: Tue Sep 06, 2016 8:30 am

Re: Save a Excel File with Pivot Table and Slicers

Postby Betsy.jiang » Fri Aug 11, 2017 6:48 am

Dear VincentB,

Thanks for waiting.
Now the issue has been fixed in Spire.XLS Pack Hotfix Version:7.12.69. Please download it and have a try.
Looking forward to your feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1424
Joined: Tue Sep 06, 2016 8:30 am

Re: Save a Excel File with Pivot Table and Slicers

Postby VincentB » Mon Aug 21, 2017 12:16 pm

Hi,

Yes, it's work perfectly !

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

Re: Save a Excel File with Pivot Table and Slicers

Postby Betsy.jiang » Tue Aug 22, 2017 1:31 am

Dear VincentB,

Thanks for your feeedback.
Please do not hesitate to contact us if you have any question.

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1424
Joined: Tue Sep 06, 2016 8:30 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests