We ran into an issue with Excel pivot tables not correctly updating when dates are involved, using Aspose.Cells in .NET (version 20.9.0). This is the setup:
- We have an Excel table, one column contains dates, also there is a text and a number value.
- The table is the data source for a pivot table, the dates are used as columns, the text for rows and the values are summed up.
- We fill the table with data.
- Then the pivot table is refreshed (using RefreshData(), CalculateData() and CalculateRange()).
The expectation is the pivot table shows the data in the table, but the date columns still show the original headers, not the ones from the changed table data. When the pivot table is refreshed in Excel itself (Data/Connections/Refresh All), it is correctly updated.
Please see the provided Visual Studio solution for an example: Aspose.Cells - no update of pivot with dates.zip
When executed it fills a table and refreshes the Pivot table, but as explained the Month-headers still show the old names.
Did we miss something, or is this a bug?