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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formula adjusting

Thread ID:





54665 Jan 15,2007 07:14 AM UTC Jan 15,2007 04:21 PM UTC WinForms 2
Tags: GridControl
Lee Kyungjong
Asked On January 15, 2007 07:14 AM UTC


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 10:41 AM UTC

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 04:21 PM UTC

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.

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