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

Copy/Paste Formula

We have a grid with formulas. Clipboard Copy-Paste operations work well, but we want to modify formula before pasting it just like Excel does that. E.g. A1 cell contains "=A2*2" formula. After copying it to clipboard and pasting into B1 cell we want to have "=B2*2" formula in B1 cell. For that we should know an address of cell - source of data in addition to the cell contents. This concerns multiselection clipboard operations. What features of Grid we can use for that?

1 Reply

AD Administrator Syncfusion Team May 4, 2004 04:23 AM UTC

This should be supported in the 2.0 code base by setting GridFormulaEngine engine = ((GridFormulaCellModel)this.gridControl1.CellModels["FormulaCell"]).Engine; engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;

Loader.
Live Chat Icon For mobile
Up arrow icon