CalculateData method is absent in XLS Free for PivotTabel

Tue Sep 08, 2015 10:41 am

Hello!

In your code samples I saw referense to CalculateData metod for PivotTable class.
Additionally, in comments to HideItemDetail method of XlsPivotField written that execution of CalculateData is mandatory.
But there is no such method!
I'm using Free edition of XLS. Version 7.8.
What I am doing wrong?
Thank you!

Wed Sep 09, 2015 2:16 am

Hello,

Thanks for your inquiry.
The free version has the feature limitation and it doesn't have the two methods.
I recommend you use the commercial version ( The latest version is Spire.XLS Pack Hotfix Version:7.8.26 ).

Best Regards,
Sweety
E-iceblue support team

Fri Sep 11, 2015 8:22 am

Hello,

Have you tried the the commercial version ( The latest version is Spire.XLS Pack Hotfix Version:7.8.26 )?
Has your issue been resolved?
Thanks for your feedback.

Best Regards,
Sweety
E-iceblue support team

Fri Sep 11, 2015 10:02 am

Hello!
Haven't tried yet. Will try with a few days.
But it's strange that free version has a methods with dependency on absent methods. It does not make a sense for me.
And I think you should say about this limitation in your docs. There is a statement on your site that free version have no limitation for xlsx files.

Thank you!

Mon Sep 14, 2015 2:34 am

Hello,

Thanks for your response.
The statement on our site is that Free Spire.XLS v7.8 has no any limitatin when loading and saving .xlsx file format. Not the free version have no limitation for xlsx files.

Best Regards,
Sweety
E-iceblue support team