Applies the appearance of one cell to one more other cells.
Syntax
rv = Send_Message(Ctrl, "OLE.CopyAppearance", Field, Record, CopyCell)
Parameters
| Parameter | Description |
|---|---|
| Field | The field position of the cell to be copied |
| Record | The record position of the cell to be copied |
| CopyCell | The cell(s) to receive the copied appearance in the format Field:@FM:Record |
Remarks
The CopyAppearance method copies the appearance of the given cell and applies it to the cells specified in the CellCopy parameter. The CellCopy parameter has two fields: Field and Record. Treat the CellCopy parameter like any index to a cell-specific property. Like index parameters, you may specify multiple cells by using the "All" keyword or by using the range specifier.
When copying appearances, the following properties are copied: CellAlignment, CellColors, CellEditMode, CellFont, CellGridLines, CellMultilined, CellPadding, and CellProtection.
Example
// Copy from one cell to another single cell rv = Send_Message(Ctrl, "OLE.CopyAppearance", 1, 1, 2:@FM:2) // Copy from one cell to a whole record of cells: record 2 rv = Send_Message(Ctrl, "OLE.CopyAppearance", 1, 1, "All":@FM:2) // Copy from one cell to a range of cells: (2, 2) - (5, 5) rv = Send_Message(Ctrl, "OLE.CopyAppearance", 1, 1, "2-5":@FM:"2-5")
