<< Return to Main Index

< Return to Class Index

CGXFormulaSheet::StoreCopyCells

virtual BOOL StoreCopyCells(CGXRange rg, ROWCOL nRow, ROWCOL nCol);

rg

Specifies the source range of cells.

nRow

Specifies the destination row coordinates.

nCol

Specifies the destination column coordinate

Return Value

TRUE if the operation was successful ; FALSE otherwise

Remarks

Duplicates the given source range of cells and places the cells at the destination location. Typically StoreCopyCells will be called as a result of a clipboard copy or ole drag&drop. Cells formulas are duplicated (along with all formatting) and placed in a new location, overwriting existing data in the destination range. Objective Grid automatically translates relative cell references in the copied formulas to reflect their new locations. For example, if cell A10 contains the formula =@SUM(A1..A9) and is copied to cell B10, then B10 will contain the formula =@SUM(B1..B9). Absolute cell references will not be affected.

To create an absolute cell reference - one that Objective Grid will not translate if the cell contents are copied or moved - insert a dollar sign ( $ ) before each component of the cell reference (e.g., $A$1).

See Also

CGXGridCore::CopyCells CGXGridCore::m_nClipboardFlags

CGXFormulaSheet

Class Overview | Class Members