I’m using the latest version of Aspose.Cells, 188.8.131.52.
I’ve got a Designer Template .xlsx file with two Worksheets in it.
One is a table, populated by SmartMarkers.
The second is a PivotTable, using the Table in the first sheet as a datasource.
In my application, I open the Template, create a WorkbookDesigner object and Process the workbook with a datasource.
The SmartMarker data binds fine, however the PivotTable’s datasource is now incorrect - Aspose.Cells has replaced it with another reference.
If you refer to the attached Solution, you can clearly see in the ‘before’ and ‘after’ variables, that the DataSource changes from the named range ‘Table1’ to a cell reference which is not correct.
It is my expectation that if I set the datasource for a PivotTable to a Table (listobject) then that datasource will remain correctly attached to that table.
I have tried the same using a global named range that covers the span of the table, which works correctly, however I shouldn’t have to duplicate a range like that for every pivot table datasource.
Can you guys take a look at this?