Skip to main content linkedinfacebooktwittermenuarrow-up

Auto-Update Formulas when inserting/deleting rows or columns Completed

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

Mario at GemBox


This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.