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

Aspose.Cells Product Family
1

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)

2

@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.

3

@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.

4

@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)

5

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