[]
        
(Showing Draft Content)

GC.Spread.Sheets.InvalidOperationType

Enumeration: InvalidOperationType

Spread.Sheets.InvalidOperationType

Identifies which operation was invalid.

example

//This example gets the invalid type.
activeSheet.getCell(1,1).locked(true);
activeSheet.options.isProtected = true;
activeSheet.getCell(1,1).value(2);
//Bind event
activeSheet.bind(GC.Spread.Sheets.Events.InvalidOperation, function (e, info) {
        alert("Message (" + info.invalidType + ")");
});

Table of contents

Enumeration members

Enumeration members

changePartOfArrayFormula

changePartOfArrayFormula = 4

Specifies the insert row is invalid.


changeSheetName

changeSheetName = 5

Specifies the changed sheet name is invalid.


copyPaste

copyPaste = 1

Specifies the copy paste is invalid.


customName

customName = 15

Specifies the value to be set as a custom name is valid.


cutProtected

cutProtected = 14

Specifies cut value when cell is locked and sheet is protected.


dataObjectCellTypeInsertData

dataObjectCellTypeInsertData = 16

Specifies a data object cell type can't insert a data to its adjacent cells on the right.


dragDrop

dragDrop = 3

Specifies the drag drop is invalid.


dragFill

dragFill = 2

Specifies the drag fill is invalid.


editProtected

editProtected = 13

Specifies edit value when cell is locked and sheet is protected.


filter

filter = 7

Specifies the add filter is invalid.


groupProtected

groupProtected = 12

Specifies the group can expand and collapse when sheet is unprotected.


pivotTable

pivotTable = 10

Specifies the change affect existed pivot table.


ptOverlapValue

ptOverlapValue = 11

Specifies the pivotTable change will overlap the valued cell.


setFormula

setFormula = 0

Specifies the formula is invalid.


table

table = 6

Specifies the table action is invalid.