Hi,
Could I get some help please; I may have done something the wrong way in code, or it could really be a bug. We are currently using v7.4.2.5 of Aspose.Cells and we seem to generate an unstable excel file when we clear -> resize a pivot table’s source ListObject if the pivot table’s “Show grand totals for columns” is unticked in the pivot table’s options.
To demonstrate this problem, I have attached a mini project that opens an excel file -> clears a listobject -> resizes the listobject -> and refreshes pivot tables in the workbook.
Please run the project and select the attached “testFile.xlsx” excel file when the Open File Dialog appears.
When the run completes, a message box will tell you where the “generated file.xlsx” file has been saved into (This will be the same directory as where the testFile.xlsx file was saved).
When opening that generated file, there will be a warning prompt stating that there will be some cells overwritten. If you click {No} to the prompt and go to worksheet “Sheet1” you’ll see that the pivot table has the word “Total” right below it (This text isn’t even part of the pivot table; but I have a feeling this came from the hidden grand totals).
Any help would be very much appreciated.
Thank you.