Formula Cell Range refresh

[Vinay]

Hi,

I have formula Sum(B1: B2), when a row is inserted between rows 1 and 2 this formula should refresh to sum(B1: B3) as in excel.

Thanks in advance
Regards
Vinay

[Administrator]

You are using a GridControl, correct?

If so, try setting this property.

GridFormulaEngine engine = ((GridFormulaCellModel)gridControl1.Model.CellModels["FormulaCell"]).Engine;
// the following flag allow formulas and name ranges to update references after inserting or deleting rows
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;