We're using Excel-templates to generate reports for our clients, and it would be really useful to have GemBox.Spreadsheet update the formulas when you insert or delete a row or column, just like Excel does it. Example 1: Cell A11 has a formula SUM(A1:A10). Now you insert a row at A5, which should be included in the SUM(). Example 2: you have several rows with a formula like C1=A1+B1, C2=A2+B2, etc. now you insert a row at position 2, and the formula in the original row is now C3=A2+B2, but it should be C3=A3+B3.
Official response
Hi,
This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.
Regards,
Mario