PivotItem.IsHidden problem when refresh data

Aspose.Cells Product Family
1 
Hello
I hide some elements of pivotItem like this:
_PivotItem.IsHidden = true;


But when I refresh data:
 _PivotTable.RefreshData();

_PivotTable.CalculateData();

Notice than some pivotitems lose their ishidden property… ???
Any idea why?
2

Hi,


Thanks for providing us some details.

Please try our latest version/fix: Aspose.Cells for .NET v8.8.2.5 if it makes any difference.

If you still find the issue, kindly create a simple console application (runnable), zip it and post us here to show the issue., we will check it soon. Also provide us your template files (input (if any) and output, etc.).

Thank you.


3
Hello

Yes i have last dll version

I attach a project sample.. To test it push 'TestPIvotItemHidden' button

In UtilAspose.cs you can see the problem in line 103 (Calling UtilAspose.GetCheckValuePivotField function )

And then after refreshdata you can see in line 111 (same method) the problem. Compare string '_strOK' with '_strKO'

Thanks
4

Hi,


Thanks for the sample project with template file.

I have tested your scenario/ case using your attached project a bit and noticed a little difference when comparing both strings. We appreciate if you could also provide some screenshots to compare both strings (e.g in debug mode) and highlight the problematic pivot items (Give details about those items, etc.), so we could evaluate your issue properly and log an issue for it into our database to consequently figure it out soon.

Thank you.
5

Hi,


We have evaluated your issue further and confirmed this is an issue with Aspose.Cells APIs part. We have already logged a ticket with an id “CELLSNET-44514” for your issue. We will look into your issue soon.

Once we have an update on it, we will let you know here.

Thank you.
6

Hi,


We are pleased to inform you that we have fixed your issue logged earlier as “CELLSNET-44514”. We will soon provide the fix after performing QA and incorporating other enhancements and fixes.

Thank you.
7
Hi again,

Please test the scenario as logged under the ticket CELLSNET-44514 against the latest version of Aspose.Cells for .NET 8.8.2.8 and let us know your feedback.
8

The issues you have found earlier (filed as CELLSNET-44514) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.