Copy/Paste Formula

[JianLi]

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?

[Administrator]

This should be supported in the 2.0 code base by setting

GridFormulaEngine engine = ((GridFormulaCellModel)this.gridControl1.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;