Enumeration: CopyToOptions

Spread.Sheets.CopyToOptions

Specifies the copy to option.

example

//This example uses the CopyToOption enumeration.
activeSheet.getCell(0,0).value("1");
activeSheet.copyTo(0,0,1,1,2,2,GC.Spread.Sheets.CopyToOptions.value);

Table of contents

Enumeration members

• all
• altText
• bindingPath
• comment
• conditionalFormat
• defaultValue
• formula
• hyperlink
• outline
• span
• sparkline
• style
• tag
• value

Enumeration members

all

• all = 8191

Indicates all types of data.

altText

• altText = 4096

Indicates the type of data is an alternative text.

bindingPath

• bindingPath = 256

Indicates the type of data is a binding path.

comment

• comment = 4

Indicates the type of data is a comment.

conditionalFormat

• conditionalFormat = 512

Indicates the type of data is a conditional format.

defaultValue

• defaultValue = 2048

Indicates the type of data is a defaultValue.

formula

• formula = 2

Indicates the type of data is a formula.

hyperlink

• hyperlink = 1024

Indicates the type of data is a hyperlink.

outline

• outline = 8

Indicates to copy a range group.

span

• span = 32

Indicates to copy a span.

sparkline

• sparkline = 16

Indicates the type of data is a sparkline.

style

• style = 64

Indicates the type of data is a style.

tag

• tag = 128

Indicates the type of data is a tag.

value

• value = 1

Indicates the type of data is pure data.