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.
Up arrow icon