Formula adjusting


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

2 Replies

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.

Loader.
Up arrow icon