Paste Doesn't update formulas

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

2 Replies

AD Administrator Syncfusion Team August 16, 2003 06:59 PM UTC

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);


ER ERobishaw August 19, 2003 12:18 AM UTC

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

Loader.
Up arrow icon