Free Support Forum - aspose.com

Updating formulas after row or column insert

I've noticed that when you insert a row or column, the formulas in the worksheet are not updated to reflect a change in position of the cells like in Excel. Does this functionality exist already? I know I can trap the column/row Inserted/Deleted events and iterate through the cells collection and try to update them myself. I was just wondering if I'm missing a method or if someone has already accomplished this task. Really love the product!!

Hi,

Currently, the control can't update references automatically after row/colurmn insert/delete. But we think that this is a valuable feature. We will try to find a solution to implement this feature.

Thank you very much for loving our product.