We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Formula Cell Range refresh

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

1 Reply

AD Administrator Syncfusion Team March 16, 2005 06:46 AM

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;

Loader.
Live Chat Icon For mobile
Up arrow icon