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

• changePartOfArrayFormula
• changeSheetName
• copyPaste
• customName
• cutProtected
• dataObjectCellTypeInsertData
• dragDrop
• dragFill
• editProtected
• filter
• groupProtected
• pivotTable
• ptOverlapValue
• setFormula
• sort
• table

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.

sort

• sort = 9

Specifies sort is invalid.

table

• table = 6

Specifies the table action is invalid.