Hi,
ASPOSE VERSION : 4.4.0.0
C#.NET : 2.0
we are using the ASPOSE.cell for generate the pivot tables in excel file. We can able to create the pivot table but we can’t able to set filters(page fields) to default values in the C# class file.
For example if we have filter like date and beside that we have one filter combo box contains the list of dates. Assume for Jan 2010 we have the dates 01/01/2010 , 01/02/2010 , 01/03/2010 ,…01/31/2010 ( total of 31 dates).
so in my C# code :
pivotTable1.PageFields[2].CurrentPageItem = 9;
so in the excel sheet - pivot table the filter for date is setting to 01/10/2010.
but if i want to set the date to 01/21/2010 then i have to write the code like pivotTable1.PageFields[2].CurrentPageItem = 20;
but its not working.
The page index is working if its between 1 to 10 otherwise it not taking the value.
So , please advice me ,if we can do it with current aspose 4.4 version or we requires to use new version if yes please provide us the details.