Hi,
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?
Thanks
AD
Administrator
Syncfusion Team
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;
LK
Lee Kyungjong
January 15, 2007 04:21 PM UTC
Thank you for the quick response.