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.

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 384 times

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

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: 3099
Joined: Tue Sep 06, 2016 8:30 am

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: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Aug 21, 2017 12:16 pm

Hi,

Yes, it's work perfectly !

Thanks

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

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: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Nov 02, 2022 4:47 pm

hi guys, I have the same problem with SaveToStream function.
Code: Select all
 
Stream memoryStream = new MemoryStream();
workbook.SaveToStream(memoryStream);
return ((MemoryStream)memoryStream).ToArray();

when I download and open this file - slicers are gone (
FreeSpire.XLS (12.7.0)

oleksa.dovbush
 
Posts: 11
Joined: Wed Nov 02, 2022 4:44 pm

Thu Nov 03, 2022 2:30 am

Hello,

Thanks for your inquiry.
To help us have an accurate investigation, please provide us with your test documents for reference. You can attache it here or send it to us via email (support@e-iceblue.com).

Sincerely,
Simple
E-iceblue support team
User avatar

Simple.Li
 
Posts: 248
Joined: Fri Jul 01, 2022 2:33 am

Thu Nov 03, 2022 9:30 am

Simple.Li wrote:Hello,

Thanks for your inquiry.
To help us have an accurate investigation, please provide us with your test documents for reference. You can attache it here or send it to us via email (support@e-iceblue.com).

Sincerely,
Simple
E-iceblue support team

Here in the attachment, you can find my file.
Thank you!
Attachments
AnalyticsTemplate.zip
ExcelFile
(294.3 KiB) Downloaded 157 times

oleksa.dovbush
 
Posts: 11
Joined: Wed Nov 02, 2022 4:44 pm

Fri Nov 04, 2022 2:31 am

Hello,

Thanks for your inquiry.
I did reproduce the behavior you mentioned. I have logged this issue into our tracking system with the ticket SPIREXLS-4252. Our Dev team will do more investigations. Once there is any update, I will inform you asap. Sorry for the inconvenience caused.

Sincerely,
Simple
E-iceblue support team
User avatar

Simple.Li
 
Posts: 248
Joined: Fri Jul 01, 2022 2:33 am

Wed Nov 09, 2022 11:09 am

Simple.Li wrote:Hello,

Thanks for your inquiry.
To help us have an accurate investigation, please provide us with your test documents for reference. You can attache it here or send it to us via email (support@e-iceblue.com).

Sincerely,
Simple
E-iceblue support team

Hello, any updates?

oleksa.dovbush
 
Posts: 11
Joined: Wed Nov 02, 2022 4:44 pm

Thu Nov 10, 2022 1:35 am

Hello,

Thanks for your following-up.
This issue has been in test phase, I have urged our test team to speed up testing your issue. Once the official version including this fix is released, I’ll inform you in time.

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 860
Joined: Tue Mar 08, 2022 2:02 am

Thu Nov 10, 2022 5:29 pm

Abel.He wrote:Hello,

Thanks for your following-up.
This issue has been in test phase, I have urged our test team to speed up testing your issue. Once the official version including this fix is released, I’ll inform you in time.

Sincerely
Abel
E-iceblue support team

Thank you!

oleksa.dovbush
 
Posts: 11
Joined: Wed Nov 02, 2022 4:44 pm

Fri Nov 11, 2022 1:19 am

You're welcome! Have you a nice day! :D

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 860
Joined: Tue Mar 08, 2022 2:02 am

Tue Nov 29, 2022 11:29 am

Abel.He wrote:You're welcome! Have you a nice day! :D

Sincerely
Abel
E-iceblue support team

Hi there! )
Are there any updates?

oleksa.dovbush
 
Posts: 11
Joined: Wed Nov 02, 2022 4:44 pm

Wed Nov 30, 2022 2:07 am

Hello,

Thanks for your patience!
Glad to inform you that we just released Spire.Xls 12.11.3 which fixes the issue with SPIREXLS-4252.
Please download the new version from the following links to test.
Website download link: https://www.e-iceblue.com/Download/down ... t-now.html Nuget download link: https://www.nuget.org/packages/Spire.Xls/12.11.3

Sincerely
Abel
E-iceblue support team
User avatar

Abel.He
 
Posts: 860
Joined: Tue Mar 08, 2022 2:02 am

Return to Spire.XLS