Free Support Forum - aspose.com

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.

Br,
Andrea Gasparin

OP-9165.zip (296.0 KB)

@andreagasparin,

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.

@andreagasparin,

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.

@andreagasparin,

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)