[]
        
(Showing Draft Content)

OpType

All Op Types are referenced here for subsequent user filtering or participation in undo events

/**
 * Defines the Operational type
 * @enum {number}
 * @public
 */
export enum OpType{
    /**
     * addSheet
     */
    addSheet= 1,
    /**
     * removeSheet
     */
    removeSheet= 2,
    /**
     * clearSheets
     */
    clearSheets= 3,
    /**
     * reorderSheet
     */
    reorderSheet= 4,
    /**
     * setStartSheetIndex
     */
    setStartSheetIndex= 5,
    /**
     * setActiveSheetId
     */
    setActiveSheetId= 6,
    /**
     * setWorkbookOptions
     */
    setWorkbookOptions= 7,
    /**
     * addNamedStyle
     */
    addNamedStyle= 8,
    /**
     * removeNamedStyle
     */
    removeNamedStyle= 9,
    /**
     * addSheetNamedStyle
     */
    addSheetNamedStyle= 10,
    /**
     * removeSheetNamedStyle
     */
    removeSheetNamedStyle= 11,
    /**
     * addCustomTheme
     */
    addCustomTheme= 12,
    /**
     * removeCustomTheme
     */
    removeCustomTheme= 13,
    /**
     * updateCustomTheme
     */
    updateCustomTheme= 14,
    /**
     * addSheetTabStyle
     */
    addSheetTabStyle= 15,
    /**
     * removeSheetTabStyle
     */
    removeSheetTabStyle= 16,
    /**
     * clearSheetTabStyle
     */
    clearSheetTabStyle= 17,
    /**
     * updateDocProp
     */
    updateDocProp= 18,
    /**
     * updateDocPropForApp
     */
    updateDocPropForApp= 19,
    /**
     * updateDocPropForCore
     */
    updateDocPropForCore= 20,
    /**
     * addCustomDocProp
     */
    addCustomDocProp= 21,
    /**
     * removeCustomDocProp
     */
    removeCustomDocProp= 22,
    /**
     * clearCustomDocProp
     */
    clearCustomDocProp= 23,
    /**
     * updateCustomDocProp
     */
    updateCustomDocProp= 24,
    /**
     * setCustomDocProps
     */
    setCustomDocProps= 25,
    /**
     * setTabSelected
     */
    setTabSelected= 26,
    /**
     * setSheetName
     */
    setSheetName= 27,
    /**
     * setRange
     */
    setRange= 28,
    /**
     * setCustomName
     */
    setCustomName= 29,
    /**
     * setSheetScopeCustomName
     */
    setSheetScopeCustomName= 30,
    /**
     * clearCustomName
     */
    clearCustomName= 31,
    /**
     * clearSheetScopeCustomName
     */
    clearSheetScopeCustomName= 32,
    /**
     * addRows
     */
    addRows= 33,
    /**
     * deleteRows
     */
    deleteRows= 34,
    /**
     * addSpan
     */
    addSpan= 35,
    /**
     * removeSpan
     */
    removeSpan= 36,
    /**
     * updateSpan
     */
    updateSpan= 37,
    /**
     * addColumns
     */
    addColumns= 39,
    /**
     * deleteColumns
     */
    deleteColumns= 40,
    /**
     * setRowCount
     */
    setRowCount= 41,
    /**
     * setColumnCount
     */
    setColumnCount= 42,
    /**
     * setFrozen
     */
    setFrozen= 43,
    /**
     * setAxisSize
     */
    setAxisSize= 45,
    /**
     * updateZoom
     */
    updateZoom= 46,
    /**
     * setAxisOptions
     */
    setAxisOptions= 47,
    /**
     * setWorksheetOptions
     */
    setWorksheetOptions= 49,
    /**
     * setCurrentTheme
     */
    setCurrentTheme= 50,
    /**
     * clearRange
     */
    clearRange= 51,
    /**
     * setSheetVisible
     */
    setSheetVisible= 52,
    /**
     * setFileInfo
     */
    setFileInfo= 53,
    /**
     * updateTopLeftPosition
     */
    updateTopLeftPosition= 54,
    /**
     * setWorkbookProperty
     */
    setWorkbookProperty= 55,
    /**
     * setSheetBackgroundImage
     */
    setSheetBackgroundImage= 56,
    /**
     * setCustomFunction
     */
    setCustomFunction= 57,
    /**
     * setSheetScopeCustomFunction
     */
    setSheetScopeCustomFunction= 58,
    /**
     * clearCustomFunction
     */
    clearCustomFunction= 59,
    /**
     * clearSheetScopeCustomFunction
     */
    clearSheetScopeCustomFunction= 60,
    /**
     * updateSheetDefaultsOptions
     */
    updateSheetDefaultsOptions= 61,
    /**
     * setFormatStringName
     */
    setFormatStringName= 62,
    /**
     * clearFormatStringName
     */
    clearFormatStringName= 63,
    /**
     * setSelectionPolicyAndUnit
     */
    setSelectionPolicyAndUnit= 64,
    /**
     * addSheetTab
     */
    addSheetTab= 65,
    /**
     * removeSheetTab
     */
    removeSheetTab= 66,
    /**
     * clearSheetTabs
     */
    clearSheetTabs= 67,
    /**
     * setSheetTabSelected
     */
    setSheetTabSelected= 68,
    /**
     * setSheetTabName
     */
    setSheetTabName= 69,
    /**
     * setSheetTabVisible
     */
    setSheetTabVisible= 70,
    /**
     * addNamedCellTemplate
     */
    addNamedCellTemplate= 71,
    /**
     * removeNamedCellTemplate
     */
    removeNamedCellTemplate= 72,
    /**
     * clearNamedCellTemplates
     */
    clearNamedCellTemplates= 73,
    /**
     * addExternalReference
     */
    addExternalReference= 101,
    /**
     * updateExternalReference
     */
    updateExternalReference= 102,
    /**
     * sortSwap
     */
    sortSwap= 111,
    /**
     * updateSortState
     */
    updateSortState= 112,
    /**
     * setFilter
     */
    setFilter= 121,
    /**
     * updateFilterSortInfo
     */
    updateFilterSortInfo= 124,
    /**
     * updateFilterButtonVisibleInfo
     */
    updateFilterButtonVisibleInfo= 125,
    /**
     * updateFilterRange
     */
    updateFilterRange= 126,
    /**
     * updateFilterData
     */
    updateFilterData= 128,
    /**
     * setDirection
     */
    setDirection= 145,
    /**
     * showOutline
     */
    showOutline= 146,
    /**
     * insertGroupItem
     */
    insertGroupItem= 147,
    /**
     * setGroupItems
     */
    setGroupItems= 148,
    /**
     * deleteGroupItem
     */
    deleteGroupItem= 149,
    /**
     * addComment
     */
    addComment= 161,
    /**
     * removeComment
     */
    removeComment= 162,
    /**
     * updateComment
     */
    updateComment= 163,
    /**
     * addTable
     */
    addTable= 171,
    /**
     * removeTable
     */
    removeTable= 172,
    /**
     * showHeader
     */
    showHeader= 173,
    /**
     * showFooter
     */
    showFooter= 174,
    /**
     * setTableProperty
     */
    setTableProperty= 175,
    /**
     * setTableLayoutStyle
     */
    setTableLayoutStyle= 176,
    /**
     * addTableRow
     */
    addTableRow= 177,
    /**
     * removeTableRow
     */
    removeTableRow= 178,
    /**
     * updateTablePosition
     */
    updateTablePosition= 179,
    /**
     * addTableColumn
     */
    addTableColumn= 180,
    /**
     * removeTableColumn
     */
    removeTableColumn= 181,
    /**
     * setTableColumnProperty
     */
    setTableColumnProperty= 182,
    /**
     * addShape
     */
    addShape= 201,
    /**
     * removeShape
     */
    removeShape= 202,
    /**
     * reorderShape
     */
    reorderShape= 203,
    /**
     * updateShapeProp
     */
    updateShapeProp= 204,
    /**
     * updateShapeFormula
     */
    updateShapeFormula= 205,
    /**
     * updateShapeTransform
     */
    updateShapeTransform= 206,
    /**
     * reorderChildShape
     */
    reorderChildShape= 209,
    /**
     * updateChildShapeProp
     */
    updateShapeCollectionOption= 210,
    /**
     * updateChartSeries
     */
    updateChartSeries= 221,
    /**
     * updateChart
     */
    updateChart= 222,
    /**
     * preserveUnsupportedChart
     */
    preserveUnsupportedChart= 223,
    /**
     * addPivotCache
     */
    addPivotCache= 251,
    /**
     * removePivotCache
     */
    removePivotCache= 252,
    /**
     * updatePivotCache
     */
    updatePivotCache= 253,
    /**
     * switchPivotCache
     */
    switchPivotCache= 254,
    /**
     * updatePivotCacheField
     */
    updatePivotCacheField= 255,
    /**
     * addPivotTable
     */
    addPivotTable= 271,
    /**
     * removePivotTable
     */
    removePivotTable= 272,
    /**
     * updatePivotTableLayout
     */
    updatePivotTableLayout= 273,
    /**
     * updateFieldsModel
     */
    updateFieldsModel= 274,
    /**
     * addPivotField
     */
    addPivotField= 275,
    /**
     * removePivotField
     */
    removePivotField= 276,
    /**
     * updatePivotTableOptions
     */
    updatePivotTableOptions= 277,
    /**
     * addRule
     */
    addRule= 301,
    /**
     * updateRule
     */
    updateRule= 302,
    /**
     * removeRule
     */
    removeRule= 303,
    /**
     * clearRule
     */
    clearRule= 304,
    /**
     * addAutoMerge
     */
    addAutoMerge= 311,
    /**
     * removeAutoMerge
     */
    removeAutoMerge= 312,
    /**
     * setSheetAreaAutoMerge
     */
    setSheetAreaAutoMerge= 313,
    /**
     * addSparklineEx
     */
    addSparklineEx= 321,
    /**
     * removeSparklineEx
     */
    removeSparklineEx= 322,
    /**
     * updateSparklineGroup
     */
    updateSparklineGroup= 323,
    /**
     * addSparklineGroup
     */
    addSparklineGroup= 324,
    /**
     * removeSparklineGroup
     */
    removeSparklineGroup= 325,
    /**
     * groupSparkline
     */
    groupSparkline= 326,
    /**
     * setGroupSparklines
     */
    setGroupSparklines= 327,
    /**
     * addSparklineForGroup
     */
    addSparklineForGroup= 328,
    /**
     * removeSparklineForGroup
     */
    removeSparklineForGroup= 329,
    /**
     * clearSparklineForGroup
     */
    clearSparklineForGroup= 330,
    /**
     * updateSparkline
     */
    updateSparkline= 331,
    /**
     * addCellState
     */
    addCellState= 351,
    /**
     * removeCellState
     */
    removeCellState= 352,
    /**
     * updateCellState
     */
    updateCellState= 353,
    /**
     * setCellState
     */
    setCellState= 354,
    /**
     * addDataValidator
     */
    addDataValidator= 361,
    /**
     * updateDataValidator
     */
    updateDataValidator= 362,
    /**
     * removeDataValidator
     */
    removeDataValidator= 363,
    /**
     * setDataValidatorRange
     */
    setDataValidatorRange= 364,
    /**
     * setOutlineColumnOptions
     */
    setOutlineColumnOptions= 371,
    /**
     * setOutlineColumnProperty
     */
    setOutlineColumnProperty= 372,
    /**
     * setPrintInfo
     */
    setPrintInfo= 381,
    /**
     * setPrintInfoOption
     */
    setPrintInfoOption= 382,
    /**
     * addTableItemSlicerCache
     */
    addTableItemSlicerCache= 391,
    /**
     * updateTableItemSlicerCache
     */
    updateTableItemSlicerCacheProperty= 392,
    /**
     * removeTableItemSlicerCache
     */
    removeTableItemSlicerCache= 393,
    /**
     * addPivotSlicerCache
     */
    addPivotSlicerCache= 394,
    /**
     * updatePivotSlicerCache
     */
    updatePivotSlicerCacheProperty= 395,
    /**
     * removePivotSlicerCache
     */
    removePivotSlicerCache= 396,
    /**
     * updateSlicerProperty
     */
    updateSlicerProperty= 397,
    /**
     * addThreadedComment
     */
    addThreadedComment= 410,
    /**
     * updateThreadedComment
     */
    updateThreadedComment= 411,
    /**
     * removeThreadedComment
     */
    removeThreadedComment= 412,
    /**
     * addThreadedCommentReply
     */
    addThreadedCommentReply= 413,
    /**
     * updateThreadedCommentReply
     */
    updateThreadedCommentReply= 414,
    /**
     * removeThreadedCommentReply
     */
    removeThreadedCommentReply= 415,
    /**
     * setRelationships
     */
    setRelationships= 421,
    /**
     * addDataManagerTable
     */
    addDataManagerTable= 423,
    /**
     * removeDataManagerTable
     */
    removeDataManagerTable= 424,
    /**
     * setDataManagerTableName
     */
    setDataManagerTableName= 425,
    /**
     * setDataManagerTableOptions
     */
    setDataManagerTableOptions= 426,
    /**
     * setPrimaryKey
     */
    setPrimaryKey= 427,
    /**
     * addView
     */
    addView= 429,
    /**
     * removeView
     */
    removeView= 430,
    /**
     * setViewsOptions
     */
    setViewsOptions= 432,
    /**
     * setViewColumns
     */
    setViewColumns= 434,
    /**
     * setDataManagerSortInfo
     */
    setDataManagerSortInfo= 437,
    /**
     * setDataManagerFilterInfo
     */
    setDataManagerFilterInfo= 438,
    /**
     * setDataManagerGroupInfo
     */
    setDataManagerGroupInfo= 439,
    /**
     * setPinnedColumns
     */
    setPinnedColumns= 440,
    /**
     * setPinnedRows
     */
    setPinnedRows= 448,
    /**
     * updateLocalRecord
     */
    updateLocalRecord= 441,
    /**
     * insertLocalRecord
     */
    insertLocalRecord= 442,
    /**
     * removeLocalRecord
     */
    removeLocalRecord= 443,
    /**
     * addLocalColumn
     */
    addLocalColumn= 444,
    /**
     * removeLocalColumn
     */
    removeLocalColumn= 445,
    /**
     * updateLocalColumn
     */
    updateLocalColumn= 446,
    /**
     * setDataManagerTableSchema
     */
    setDataManagerTableSchema= 447,
    /**
     * updateTableSheetDataView
     */
    updateTableSheetDataView= 451,
    /**
     * updateTableSheetOptions
     */
    updateTableSheetOptions= 452,
    /**
     * updateTableSheetRowActionOptions
     */
    updateTableSheetRowActionOptions= 453,
    /**
     * updateTableSheetCurrentTheme
     */
    updateTableSheetCurrentTheme= 454,
    /**
     * updateTableSheetDefaults
     */
    updateTableSheetDefaults= 455,
    /**
     * updateTableSheetPrintInfo
     */
    updateTableSheetPrintInfo= 456,
    /**
     * updateTableSheetFreeHeaderArea
     */
    updateTableSheetFreeHeaderArea= 457,
    /**
     * setTableSheetFilterInfo
     */
    setTableSheetFilterInfo= 458,
    /**
     * setTableSheetSortInfo
     */
    setTableSheetSortInfo= 459,
    /**
     * addRichDataImage
     */
    addRichDataImage= 501,
    /**
     * removeRichDataImage
     */
    removeRichDataImage= 502
}