Paste Doesn't update formulas

[ERobishaw]

I'm pasting data into a non-db grid using the paste function.

Affected Formula values, however, do not get updated.

How do I manually force the grid to re-calc?

Eric

[Administrator]

Are you using ctl+V to paste what is on the clipboard to the currentcell/selection? I do not see a problem in the Syncfusion\Essential Suite\Grid\Samples\In Depth\FormulaCellSelection sample.

If you want to force a range of cells to recalculate, you can use code like:

GridFormulaCellModel model = (GridFormulaCellModel)this.gridControl1.CellModels["FormulaCell"];
GridFormulaEngine engine = model.Engine;
engine.RecalculateRange(range, true);

[ERobishaw]

I was pasting multiple cells from an Excel spreadsheet.

Funny thing is, the behavior seemed to consistently NOT re-calc... but then started recalcing the next time I ran the code.

Eric