Skip to main content

Auto-Update Formulas when inserting/deleting rows or columns - Community / GemBox.Spreadsheet Feature Request - GemBox Support Center

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.

Comment (1)

Mario - GemBox
Hi,

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


Regards,

Mario
GemBox d.o.o.