Wrong formula in the table column after insertion of a row (OP-9165)

Hi Support,
The references of a formula (with cell references) inserted to a table column are not updated after the insertion of a row before the table.
I attach a simple program to replicate the issue.

Andrea Gasparin

OP-9165.zip (296.0 KB)


Thanks for the sample project with template file.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample code with template file. I found wrong formula in the table column after insertion of a row in the output PDF file. When I manually refreshed the Pivot table in MS Excel, I got different display for the pivot table, it seams pivot table is not refreshed precisely. I have logged a ticket with an id “CELLSNET-47219” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.


This is to inform you that we have resolved your issue (previously recorded as “CELLSNET-47219”). After performing QA and merging other enhancements and fixes, we will soon provide you with a fixed version.


Please try our latest version/fix: Aspose.Cells for .NET v20.3.2 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.3.2 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.3.2 For .Net4.0.Zip (5.3 MB)

The issues you have found earlier (filed as CELLSNET-47219) have been fixed in Aspose.Cells for .NET v20.4. This message was posted using Bugs notification tool by Amjad_Sahi