I can’t find these properties in Aspose.Cells. Could you please fix it or show me they, if such properties already exist?
Ribbon -> PivotTable Tools -> Options -> PivotTable -> Options:
Layout & Format
When in compact form indent row labels: xx character(s)
Totals & Filters
Allow multiple filters per field
Show contextual tooltips
Show properties in tooltips
Show the Values row
Show items with no data on rows
Show items with no data on columns
Field list: Sort A to Z <<–>> Sort in data source order
Print expand/collapse buttons when displayed on PivotTable
Number of items to retain per field:
Enable cell editing in the values area
I am using Excel 2010 and Aspose.Cells 18.104.22.168.
Please download: Aspose.Cells for .NET v22.214.171.124
Please use pivottable.PrintDrill
We cannot support these properties in Excel 2003 which are saved by Excel2007 now. We will support it later.
We cannot support the pivottable that is using OLAP now, we will support it later.
We have fixed it in the latest version: Aspose.Cells for .NET v126.96.36.199.
Thanks for your xls file.
We have forwarded your issue to our development team and logged it. Once, we will get some update relating to it, we will let you know asap.
The issues you have found earlier (filed as CELLSNET-40179) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)
Your issue should be fixed in it.
Let us know your feedback.