I am having the below 3 issues when using PivotTable with Aspose.
I have a Template.xlsx file with a PivotTable whose DataSource is set to a named range ‘tblOpenPositions’.
This Pivot table has a custom sort set and also 3 conditional format rules.
First I import the MSDStyles worksheet from MSDStyles.xlsx into Template.xlsx so that I can get the custom styles defined for table and pivottable.
I open the file using Aspose and then import data and update the DataSource range. I then call
pivotTable.PivotTableStyleName = “MSDPivotStyle”;
and save the xlsx file the pivottable in the saved file does not have the MSDPivotStyle applied and it is not sorted and also the conditional formats have blanked out all cells in the column (columns B,C and D) as opposed to only only some cells in the columns.
The attached MSDStyles.xlsx file has the custom styles defined for table and pivottable.
The attached PivotTable Issues - Aspose.xlsx has 2 sheets.
Good Pivot : This should be how the pivot should look like after importing data and saving file.
Bad Pivot: This is how the pivot looks like after using aspose.
Please let me know what would be the correct way to go about importing and applying a custom style from a different workbook., and how to maintain the sorting and conditional formats as defined on the pivot in my template.
PivotTable Issues.zip (42.5 KB)