Circular formula crashes the application

[Thanvir Hussain]

Hi,

When I use a grid with all formula cells and if I enter a formula in cell A1 as =A2 and in A2 as =A1 the program crashes.

Regards
thanvir

[Administrator]

If you set this property, the grid will flag this error as your user enters the circular reference.

          GridFormulaEngine engine = ((GridFormulaCellModel)gridControl1.CellModels["FormulaCell"]).Engine;
            engine.DoCircularCheckInValidating = true;