Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

A CopyPasteType value specifies the type of data that will be copied.

Signature
C#
C#
 public sealed class CopyPasteType : TypesafeEnum
Signature
vb.net
vb.net
Public NotInheritable Class CopyPasteType
		Inherits TypesafeEnum
Values

Name

Description

Anchor
All
All
All

Copies all currently supported types, except for row height and column width. Note: The behavior of All may change in the future as additional features are added to the CopyPaste method.

Anchor
AllPlusRowHeightAndColumnWidth
AllPlusRowHeightAndColumnWidth
AllPlusRowHeightAndColumnWidth

Copies all currently supported types, including row height and column width. Note: If you call CopyPaste multiple times on the same worksheet, using this setting may have undesired results.

Anchor
FormulasAndFormatting
FormulasAndFormatting
FormulasAndFormatting

Copy formulas and cell and number formatting.

Anchor
None
None
None

Copies nothing. You must then set the behavior of CopyPaste by setting individual properties on the CopyPasteProperties object before calling the CopyPaste method.

Anchor
ValuesAndFormatting
ValuesAndFormatting
ValuesAndFormatting

Copy cell values and cell and number formatting.

Anchor
ValuesFormulasAndFormatting
ValuesFormulasAndFormatting
ValuesFormulasAndFormatting

Copy cell values, formulas, and cell and number formatting.

Anchor
ValuesOnly
ValuesOnly
ValuesOnly

Copy only cell values.