The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
ADAdministrator 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);
ERERobishawAugust 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