TdxSpreadSheetClipboardPasteOption Enum

Enumerates available paste operation flags.

Declaration

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

Members

Name	Description
cpoValues	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.