Formula adjusting

[Lee Kyungjong]

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

[Administrator]

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]

Thank you for the quick response.