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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formula Cell Range refresh

Thread ID:

Created:

Updated:

Platform:

Replies:

26179 Mar 16,2005 10:47 AM UTC Mar 16,2005 11:46 AM UTC WinForms 1
loading
Tags: GridControl
Vinay
Asked On March 16, 2005 10:47 AM UTC

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 [Syncfusion]
Replied On March 16, 2005 11:46 AM UTC

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;

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon