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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Paste Doesn't update formulas

Thread ID:

Created:

Updated:

Platform:

Replies:

6552 Aug 16,2003 06:18 PM UTC Aug 19,2003 12:18 AM UTC WinForms 2
loading
Tags: GridControl
ERobishaw
Asked On August 16, 2003 06:18 PM UTC

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 [Syncfusion]
Replied On 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);

ERobishaw
Replied On 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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon