- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
-
GC.Spread.Sheets
- Classes
-
Enumerations
- PasteOperationOptions
- AllSheetsListVisibility
- AutoFitType
- ButtonImageType
- ButtonPosition
- ButtonVisibility
- CalendarPage
- CalendarStartDay
- CaptionAlignment
- CellStatesType
- ClearPendingChangeType
- ClipboardPasteOptions
- CopyPasteHeaderOptions
-
CopyToOptions
- DropdownListValue
- DropDownType
- EditorStatus
- FilterActionType
- GroupSort
- HeaderAutoText
- HeaderOptions
- HorizontalAlign
- HorizontalPosition
- HyperlinkTargetType
- IconPosition
- ImageLayout
- ImeMode
- InsertShiftCell
- InvalidOperationType
- LabelAlignment
- LabelVisibility
- LayoutDirection
- LayoutDisplayAs
- LineStyle
- ListType
- NumbersFitMode
- PatternType
- RangeChangedAction
- ReferenceStyle
- ResizeMode
- ResizeZeroIndicator
- RowColumnStates
- ScrollbarAppearance
- SelectionPolicy
- SelectionUnit
- SheetArea
- SheetTabVisible
- SheetType
- ShowResizeTip
- ShowScrollTip
- SortState
- StorageType
- TableRemoveOptions
- TabStripPosition
- TextDecorationType
- TextDirectionType
- UsedRangeType
- ValueType
- VertAlign
- VerticalAlign
- VerticalPosition
- VisualState
- ClipboardActionType
- CornerPosition
- CalculationMode
- CalculationType
- OpenMode
- FileType
- SheetTabState
- AllowDragHeaderToMove
- Interfaces
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel
GC.Spread.Sheets.CopyToOptions
Enumeration: 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 = 16383
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.