Hi,
Please see attached excel file, in “BillingPivot” tab, a report filter on B3, the values are from G cell of “BillingData” tab.
I want to make the report filter select the max value(in this case the max value is 2006/4/21) after some new records add to BillingData tab by using aspose, and the pivot table should be really filtered, please give me some clue, thanks in advance.
Hi,
Hi,
PivotTable table = workbook.getWorksheets().getSheet(0).getPivotTables().get(0);
PivotField field = table.getPageFields().get(1);
field.setCurrentPageItem((short)(field.getItemCount()-1));
table.setRefreshDataOnOpeningFile(true);
//if need
table.calculateData();
Could you provide instructions on how to do this in the .NET version? I don’t seem to have access to most of these methods; starting with the get methods (I can get the fields another way, but I don’t even have a setCurrentPageItem or anything similar on the field.
Thanks in advance,
Mirek
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
Please download and use the latest version: Aspose.Cells
for .NET v7.3.5.1.
Please use PivotTField.CurrentPageItem the property. Below is the translated code in .NET
C#
Workbook workbook = new Workbook(“D:\Billing.xls”);
PivotTable table = workbook.Worksheets[0].PivotTables[0];
PivotField field = table.PageFields[1];
field.CurrentPageItem = (short)(field.ItemCount - 1);
table.RefreshDataOnOpeningFile = true;
table.CalculateData();
Is there any updates on Ticket Id CELLSJAVA-28115 .
I have a similar requirement.
Hi Nilima,
Thanks for your posting and using Aspose.Cells.
This is actually an old ticket which is non-existent in the current database. Could you please elaborate your requirements in detail in a New Post. We will look into it and create a New Ticket in the current database to support your feature request.
Thanks for your cooperation.