When adding rows near a ListObject containing formula- those formulae are wrongly duplicated

[BaxEnergy]

There is an issue when adding rows near an Excel ListObject containing formulae in its listColumns.

Basically when the amount of added rows intersect the table below, its formule are copied upward.

Here is the code to reproduce the issue:

Workbook wb = new Workbook(“Test.xlsx”);

wb.Worksheets[0].Cells.InsertRows(4, 3);

wb.Save(“TestOutput.xlsx”);

[Amjad_Sahi]

Hi,

Thanks for providing us template file and sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with your template file. I found when adding rows near a ListObject containing formulas, those formulae are wrongly duplicated upward (into those (blank) inserted rows). I have logged a ticket with an id “CELLSNET-45373” for your issue. We will look into it soon.

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

Thank you.

[shakeel.faiz]

Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.5.3 (.NET 2.0) compiled in .NET Framework 2.0.

Aspose.Cells for .NET v17.5.3 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.

[BaxEnergy]

The fix worked fine for us, thanks

[Amjad_Sahi]

Hi,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.

[aspose.notifier]

The issues you have found earlier (filed as CELLSNET-45373) have been fixed in Aspose.Cells for .NET 17.6.

---

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.