- GC.Data
- GC
- 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
- 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.DataCharts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.ThreadedComments
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.DataRange
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.Collaboration
- 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
- Collaboration
- GC.Spread.Sheets.AI
OpType
Enumeration: OpType
Defines the Operational type
Table of contents
Enumeration members
- addAutoMerge
- addCellState
- addColumns
- addComment
- addCustomDocProp
- addCustomTheme
- addDataValidator
- addExternalReference
- addNamedStyle
- addPivotCache
- addPivotField
- addPivotSlicerCache
- addPivotTable
- addRows
- addRule
- addShape
- addSheet
- addSheetNamedStyle
- addSheetTabStyle
- addSpan
- addSparklineEx
- addSparklineForGroup
- addSparklineGroup
- addTable
- addTableColumn
- addTableItemSlicerCache
- addTableRow
- addThreadedComment
- addThreadedCommentReply
- clearCustomDocProp
- clearCustomFunction
- clearCustomName
- clearFormatStringName
- clearRange
- clearRule
- clearSheetScopeCustomFunction
- clearSheetScopeCustomName
- clearSheetTabStyle
- clearSheets
- clearSparklineForGroup
- deleteColumns
- deleteGroupItem
- deleteRows
- groupSparkline
- insertGroupItem
- preserveUnsupportedChart
- removeAutoMerge
- removeCellState
- removeComment
- removeCustomDocProp
- removeCustomTheme
- removeDataValidator
- removeNamedStyle
- removePivotCache
- removePivotField
- removePivotSlicerCache
- removePivotTable
- removeRule
- removeShape
- removeSheet
- removeSheetNamedStyle
- removeSheetTabStyle
- removeSpan
- removeSparklineEx
- removeSparklineForGroup
- removeSparklineGroup
- removeTable
- removeTableColumn
- removeTableItemSlicerCache
- removeTableRow
- removeThreadedComment
- removeThreadedCommentReply
- reorderChildShape
- reorderShape
- reorderSheet
- setActiveSheetId
- setAxisOptions
- setAxisSize
- setCellState
- setColumnCount
- setCurrentTheme
- setCustomDocProps
- setCustomFunction
- setCustomName
- setDataValidatorRange
- setDirection
- setFileInfo
- setFilter
- setFormatStringName
- setFrozen
- setGroupItems
- setGroupSparklines
- setOutlineColumnOptions
- setOutlineColumnProperty
- setPrintInfo
- setPrintInfoOption
- setRange
- setRowCount
- setSelectionPolicyAndUnit
- setSheetAreaAutoMerge
- setSheetBackgroundImage
- setSheetName
- setSheetScopeCustomFunction
- setSheetScopeCustomName
- setSheetVisible
- setStartSheetIndex
- setTabSelected
- setTableColumnProperty
- setTableLayoutStyle
- setTableProperty
- setWorkbookOptions
- setWorkbookProperty
- setWorksheetOptions
- showFooter
- showHeader
- showOutline
- sortSwap
- switchPivotCache
- updateCellState
- updateChart
- updateChartSeries
- updateComment
- updateCustomDocProp
- updateCustomTheme
- updateDataValidator
- updateDocProp
- updateDocPropForApp
- updateDocPropForCore
- updateExternalReference
- updateFieldsModel
- updateFilterButtonVisibleInfo
- updateFilterData
- updateFilterRange
- updateFilterSortInfo
- updatePivotCache
- updatePivotCacheField
- updatePivotSlicerCacheProperty
- updatePivotTableLayout
- updatePivotTableOptions
- updateRule
- updateShapeFormula
- updateShapeProp
- updateShapeTransform
- updateSheetDefaultsOptions
- updateSlicerProperty
- updateSortState
- updateSpan
- updateSparkline
- updateSparklineGroup
- updateTableItemSlicerCacheProperty
- updateTablePosition
- updateThreadedComment
- updateThreadedCommentReply
- updateTopLeftPosition
- updateZoom
Enumeration members
addAutoMerge
• addAutoMerge = 311
addAutoMerge
addCellState
• addCellState = 351
addCellState
addColumns
• addColumns = 39
addColumns
addComment
• addComment = 161
addComment
addCustomDocProp
• addCustomDocProp = 21
addCustomDocProp
addCustomTheme
• addCustomTheme = 12
addCustomTheme
addDataValidator
• addDataValidator = 361
addDataValidator
addExternalReference
• addExternalReference = 101
addExternalReference
addNamedStyle
• addNamedStyle = 8
addNamedStyle
addPivotCache
• addPivotCache = 251
addPivotCache
addPivotField
• addPivotField = 275
addPivotField
addPivotSlicerCache
• addPivotSlicerCache = 394
addPivotSlicerCache
addPivotTable
• addPivotTable = 271
addPivotTable
addRows
• addRows = 33
addRows
addRule
• addRule = 301
addRule
addShape
• addShape = 201
addShape
addSheet
• addSheet = 1
addSheet
addSheetNamedStyle
• addSheetNamedStyle = 10
addSheetNamedStyle
addSheetTabStyle
• addSheetTabStyle = 15
addSheetTabStyle
addSpan
• addSpan = 35
addSpan
addSparklineEx
• addSparklineEx = 321
addSparklineEx
addSparklineForGroup
• addSparklineForGroup = 328
addSparklineForGroup
addSparklineGroup
• addSparklineGroup = 324
addSparklineGroup
addTable
• addTable = 171
addTable
addTableColumn
• addTableColumn = 180
addTableColumn
addTableItemSlicerCache
• addTableItemSlicerCache = 391
addTableItemSlicerCache
addTableRow
• addTableRow = 177
addTableRow
addThreadedComment
• addThreadedComment = 410
addThreadedComment
addThreadedCommentReply
• addThreadedCommentReply = 413
addThreadedCommentReply
clearCustomDocProp
• clearCustomDocProp = 23
clearCustomDocProp
clearCustomFunction
• clearCustomFunction = 59
clearCustomFunction
clearCustomName
• clearCustomName = 31
clearCustomName
clearFormatStringName
• clearFormatStringName = 63
clearFormatStringName
clearRange
• clearRange = 51
clearRange
clearRule
• clearRule = 304
clearRule
clearSheetScopeCustomFunction
• clearSheetScopeCustomFunction = 60
clearSheetScopeCustomFunction
clearSheetScopeCustomName
• clearSheetScopeCustomName = 32
clearSheetScopeCustomName
clearSheetTabStyle
• clearSheetTabStyle = 17
clearSheetTabStyle
clearSheets
• clearSheets = 3
clearSheets
clearSparklineForGroup
• clearSparklineForGroup = 330
clearSparklineForGroup
deleteColumns
• deleteColumns = 40
deleteColumns
deleteGroupItem
• deleteGroupItem = 149
deleteGroupItem
deleteRows
• deleteRows = 34
deleteRows
groupSparkline
• groupSparkline = 326
groupSparkline
insertGroupItem
• insertGroupItem = 147
insertGroupItem
preserveUnsupportedChart
• preserveUnsupportedChart = 223
preserveUnsupportedChart
removeAutoMerge
• removeAutoMerge = 312
removeAutoMerge
removeCellState
• removeCellState = 352
removeCellState
removeComment
• removeComment = 162
removeComment
removeCustomDocProp
• removeCustomDocProp = 22
removeCustomDocProp
removeCustomTheme
• removeCustomTheme = 13
removeCustomTheme
removeDataValidator
• removeDataValidator = 363
removeDataValidator
removeNamedStyle
• removeNamedStyle = 9
removeNamedStyle
removePivotCache
• removePivotCache = 252
removePivotCache
removePivotField
• removePivotField = 276
removePivotField
removePivotSlicerCache
• removePivotSlicerCache = 396
removePivotSlicerCache
removePivotTable
• removePivotTable = 272
removePivotTable
removeRule
• removeRule = 303
removeRule
removeShape
• removeShape = 202
removeShape
removeSheet
• removeSheet = 2
removeSheet
removeSheetNamedStyle
• removeSheetNamedStyle = 11
removeSheetNamedStyle
removeSheetTabStyle
• removeSheetTabStyle = 16
removeSheetTabStyle
removeSpan
• removeSpan = 36
removeSpan
removeSparklineEx
• removeSparklineEx = 322
removeSparklineEx
removeSparklineForGroup
• removeSparklineForGroup = 329
removeSparklineForGroup
removeSparklineGroup
• removeSparklineGroup = 325
removeSparklineGroup
removeTable
• removeTable = 172
removeTable
removeTableColumn
• removeTableColumn = 181
removeTableColumn
removeTableItemSlicerCache
• removeTableItemSlicerCache = 393
removeTableItemSlicerCache
removeTableRow
• removeTableRow = 178
removeTableRow
removeThreadedComment
• removeThreadedComment = 412
removeThreadedComment
removeThreadedCommentReply
• removeThreadedCommentReply = 415
removeThreadedCommentReply
reorderChildShape
• reorderChildShape = 209
reorderChildShape
reorderShape
• reorderShape = 203
reorderShape
reorderSheet
• reorderSheet = 4
reorderSheet
setActiveSheetId
• setActiveSheetId = 6
setActiveSheetId
setAxisOptions
• setAxisOptions = 47
setAxisOptions
setAxisSize
• setAxisSize = 45
setAxisSize
setCellState
• setCellState = 354
setCellState
setColumnCount
• setColumnCount = 42
setColumnCount
setCurrentTheme
• setCurrentTheme = 50
setCurrentTheme
setCustomDocProps
• setCustomDocProps = 25
setCustomDocProps
setCustomFunction
• setCustomFunction = 57
setCustomFunction
setCustomName
• setCustomName = 29
setCustomName
setDataValidatorRange
• setDataValidatorRange = 364
setDataValidatorRange
setDirection
• setDirection = 145
setDirection
setFileInfo
• setFileInfo = 53
setFileInfo
setFilter
• setFilter = 121
setFilter
setFormatStringName
• setFormatStringName = 62
setFormatStringName
setFrozen
• setFrozen = 43
setFrozen
setGroupItems
• setGroupItems = 148
setGroupItems
setGroupSparklines
• setGroupSparklines = 327
setGroupSparklines
setOutlineColumnOptions
• setOutlineColumnOptions = 371
setOutlineColumnOptions
setOutlineColumnProperty
• setOutlineColumnProperty = 372
setOutlineColumnProperty
setPrintInfo
• setPrintInfo = 381
setPrintInfo
setPrintInfoOption
• setPrintInfoOption = 382
setPrintInfoOption
setRange
• setRange = 28
setRange
setRowCount
• setRowCount = 41
setRowCount
setSelectionPolicyAndUnit
• setSelectionPolicyAndUnit = 64
setSelectionPolicyAndUnit
setSheetAreaAutoMerge
• setSheetAreaAutoMerge = 313
setSheetAreaAutoMerge
setSheetBackgroundImage
• setSheetBackgroundImage = 56
setSheetBackgroundImage
setSheetName
• setSheetName = 27
setSheetName
setSheetScopeCustomFunction
• setSheetScopeCustomFunction = 58
setSheetScopeCustomFunction
setSheetScopeCustomName
• setSheetScopeCustomName = 30
setSheetScopeCustomName
setSheetVisible
• setSheetVisible = 52
setSheetVisible
setStartSheetIndex
• setStartSheetIndex = 5
setStartSheetIndex
setTabSelected
• setTabSelected = 26
setTabSelected
setTableColumnProperty
• setTableColumnProperty = 182
setTableColumnProperty
setTableLayoutStyle
• setTableLayoutStyle = 176
setTableLayoutStyle
setTableProperty
• setTableProperty = 175
setTableProperty
setWorkbookOptions
• setWorkbookOptions = 7
setWorkbookOptions
setWorkbookProperty
• setWorkbookProperty = 55
setWorkbookProperty
setWorksheetOptions
• setWorksheetOptions = 49
setWorksheetOptions
showFooter
• showFooter = 174
showFooter
showHeader
• showHeader = 173
showHeader
showOutline
• showOutline = 146
showOutline
sortSwap
• sortSwap = 111
sortSwap
switchPivotCache
• switchPivotCache = 254
switchPivotCache
updateCellState
• updateCellState = 353
updateCellState
updateChart
• updateChart = 222
updateChart
updateChartSeries
• updateChartSeries = 221
updateChartSeries
updateComment
• updateComment = 163
updateComment
updateCustomDocProp
• updateCustomDocProp = 24
updateCustomDocProp
updateCustomTheme
• updateCustomTheme = 14
updateCustomTheme
updateDataValidator
• updateDataValidator = 362
updateDataValidator
updateDocProp
• updateDocProp = 18
updateDocProp
updateDocPropForApp
• updateDocPropForApp = 19
updateDocPropForApp
updateDocPropForCore
• updateDocPropForCore = 20
updateDocPropForCore
updateExternalReference
• updateExternalReference = 102
updateExternalReference
updateFieldsModel
• updateFieldsModel = 274
updateFieldsModel
updateFilterButtonVisibleInfo
• updateFilterButtonVisibleInfo = 125
updateFilterButtonVisibleInfo
updateFilterData
• updateFilterData = 128
updateFilterData
updateFilterRange
• updateFilterRange = 126
updateFilterRange
updateFilterSortInfo
• updateFilterSortInfo = 124
updateFilterSortInfo
updatePivotCache
• updatePivotCache = 253
updatePivotCache
updatePivotCacheField
• updatePivotCacheField = 255
updatePivotCacheField
updatePivotSlicerCacheProperty
• updatePivotSlicerCacheProperty = 395
updatePivotSlicerCache
updatePivotTableLayout
• updatePivotTableLayout = 273
updatePivotTableLayout
updatePivotTableOptions
• updatePivotTableOptions = 277
updatePivotTableOptions
updateRule
• updateRule = 302
updateRule
updateShapeFormula
• updateShapeFormula = 205
updateShapeFormula
updateShapeProp
• updateShapeProp = 204
updateShapeProp
updateShapeTransform
• updateShapeTransform = 206
updateShapeTransform
updateSheetDefaultsOptions
• updateSheetDefaultsOptions = 61
updateSheetDefaultsOptions
updateSlicerProperty
• updateSlicerProperty = 397
updateSlicerProperty
updateSortState
• updateSortState = 112
updateSortState
updateSpan
• updateSpan = 37
updateSpan
updateSparkline
• updateSparkline = 331
updateSparkline
updateSparklineGroup
• updateSparklineGroup = 323
updateSparklineGroup
updateTableItemSlicerCacheProperty
• updateTableItemSlicerCacheProperty = 392
updateTableItemSlicerCache
updateTablePosition
• updateTablePosition = 179
updateTablePosition
updateThreadedComment
• updateThreadedComment = 411
updateThreadedComment
updateThreadedCommentReply
• updateThreadedCommentReply = 414
updateThreadedCommentReply
updateTopLeftPosition
• updateTopLeftPosition = 54
updateTopLeftPosition
updateZoom
• updateZoom = 46
updateZoom