TdxSpreadSheetClipboardPasteOption Enum

Enumerates available paste operation flags.

Declaration

TdxSpreadSheetClipboardPasteOption = (
    cpoValues,
    cpoFormulas,
    cpoComments,
    cpoNumberFormatting,
    cpoStyles,
    cpoColumnWidths,
    cpoSkipBlanks
);

Members

A paste operation inserts only cell values if no other paste operation flag is set. If a source cell contains a parsed formula expression, the paste operation inserts only the calculated value into the corresponding target cell.

| | cpoFormulas |

Pastes text, numbers, and formula expressions without formatting. When the cpoFormulas flag is set, the paste routines automatically add the cpoValues flag to the same paste option set if the flag was missing.

| | cpoComments |

Pastes only comment containers if no other paste operation flag is set.

| | cpoNumberFormatting |

Pastes only cell value formatting patterns if no other paste operation flag is set.

| | cpoStyles |

Pastes cell formatting (appearance and behavior settings stored in a cell object’s Style property set) and ignores values, formula expressions, hyperlinks, comment containers, etc. When the cpoStyles flag is set, paste routines automatically add the cpoNumberFormatting flag to the same option set if the flag was missing.

| | cpoColumnWidths |

Applies source cell widths to target cells.

| | cpoSkipBlanks |

The paste operation omits all empty cells within the source cell range. This flag is in effect only if the cpoValues, cpoFormulas, cpoComments, cpoNumberFormatting, and/or cpoStyles flag is set.

|

Remarks

The TdxSpreadSheetClipboardPasteOptions type references the TdxSpreadSheetClipboardPasteOption type.

See Also

dxSpreadSheetTypes Unit