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.
Unfortunately, activation email could not send to your email. Please try again.

Formula adjusting

Thread ID:





54665 Jan 15,2007 02:14 AM Jan 15,2007 11:21 AM Windows Forms 2
Tags: GridControl
Lee Kyungjong
Asked On January 15, 2007 02:14 AM


this.gridControl1.BaseStylesMap["Standard"].StyleInfo.CellType = "FormulaCell";

Type a formula into the all cells.
Select the row(s) or cloumn(s) and do a remove(or insert, paste, move ...etc).
Then the formula must adjust to the new location, But not the all formula.

I'm using v4.4.0.51

Any suggestions?


Administrator [Syncfusion]
Replied On January 15, 2007 05:41 AM

Try setting FormulaCopyFlags property to tell the grid to adjust references in different situations.

GridFormulaEngine engine = ((GridFormulaCellModel)grid.Model.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags = GridFormulaCopyFlags.ClipBoardReferencesAdjusted | GridFormulaCopyFlags.InsDelRangeReferencesUpdated;

Lee Kyungjong
Replied On January 15, 2007 11:21 AM

Thank you for the quick response.


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.

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.