Free Support Forum - aspose.com

Automatically copy formulas on RowInsert?

Is there any way to get formulas copied automatically and adjusted for the new row when using RowInsert?

Example:
Old row: A1=1, B1=2, C1=SUM(A1:B2)
New row: A2=(blank), B2=(blank), C2=SUM(A2:B2)

If not, what is the best way to do this and adjust the formulas?

Hi Tomi,

Currently you have to use Cell.Formula to set formula to the new created cell.