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.