Pivot table with dates does not correctly update

Aspose.Cells Product Family
1

Hello!

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?

Kind regards
Michael

2

@mpohl.arifleet.de,
This issue is reproduced using the sample project and logged in our database for further investigation and fix. You will be notified here once any update is ready to share.

This issue is logged as:
CELLSNET-47633 - Pivot table with dates does not update correctly

3

Thank you for filing the issue, we’re looking forward to a fix.

4

@mpohl.arifleet.de,

Yes, once we figure out your issue, we will update you.

5

@mpohl.arifleet.de,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

6

Great, thanks for the update.

7

The issues you have found earlier (filed as CELLSNET-47633) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (NuGet Gallery | Aspose.Cells 20.10.0).

8

Thank you very much!

9

@mpohl.arifleet.de,
You are welcome.