We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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

Live Chat Icon For mobile
Up arrow icon