Inserting rows breaking formulae

Aspose.Cells Product Family
1
I have a sheet which has many formulae which link to an external workbook. e.g.='[out.xlsx]Giving'!$C$5

I insert some rows at the top of this workbook,
ws.Cells.InsertRows(0, 15, True)

However instead of leaving these absolute formula references alone, the formula is changed to reference $C$20. Which shouldn't happen, and thus breaks the workbook.

Is there a way to get Aspose.Cells to handle this situation. It does all the non-external references in formulae perfectly well.

Thanks
Aspose.Cells for .NET
v17.2.0.0


2

Hi,


Thanks for providing us details.

Could you provide us your template file, we will check it soon.

Thank you.
3

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix.

This issue has been logged as

  • CELLSNET-45253 - Inserting rows breaking formulas linking to external workbook

4

Hi,


This is to inform you that we have fixed your issue “CELLSNET-45253” now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Thank you.
5
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

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

and let us know your feedback.
6

You really should give lessons to other vendors on how to respond to customers issues.

Confirmed as fixed, many thanks, you rock!

7
Hi,

Thanks for your appreciation and using Aspose.Cells.

It is good to know that your issue is resolved with the latest fix. Let us know if you encounter any other issue, we will be glad to look into it and help you further.
8

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

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