Pivot Table Options: "Show expand/collapse buttons"

Aspose.Cells Product Family
1

In Excel, I can click on the pivot table and go to the PivotTable Options and uncheck “Show expand/collapse buttons”. What is the equivalent in ASPOSE?

2

Hi,


I am afraid currently we do not have this feature available in Aspose.Cells for .Net API. But we will try to provide you a fix version having equivalent functionality.
Thanks
3

Hi,

We have logged your feature request into our tracking system with an id: CELLSNET-27285. We are already working on it. I takes some days to support this feature. Once we support it, we will let you know here.

Thank you.

4

Hi,

We have implemented this feature in our latest release of Aspose.Cells for .NET v5.3.3.1 [Attached]. Please use the following code of line to "Show Expand / Collapse Buttons" in a pivottable. Also share your feedback on this. Thanks

Sample Code:
workbook.Worksheets[1].PivotTables[0].ShowDrill = true/false;

5

This worked perfectly.
Thank you!

6

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.