[]
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 + ")");
});
• changePartOfArrayFormula = 4
Specifies the insert row is invalid.
• changeSheetName = 5
Specifies the changed sheet name is invalid.
• copyPaste = 1
Specifies the copy paste is invalid.
• customName = 15
Specifies the value to be set as a custom name is valid.
• cutProtected = 14
Specifies cut value when cell is locked and sheet is protected.
• dataObjectCellTypeInsertData = 16
Specifies a data object cell type can't insert a data to its adjacent cells on the right.
• dragDrop = 3
Specifies the drag drop is invalid.
• dragFill = 2
Specifies the drag fill is invalid.
• editProtected = 13
Specifies edit value when cell is locked and sheet is protected.
• filter = 7
Specifies the add filter is invalid.
• groupProtected = 12
Specifies the group can expand and collapse when sheet is unprotected.
• pivotTable = 10
Specifies the change affect existed pivot table.
• ptOverlapValue = 11
Specifies the pivotTable change will overlap the valued cell.
• setFormula = 0
Specifies the formula is invalid.
• sizeLimitExceeded = 18
The specific event type that is triggered when the size of a file uploaded via the file picker exceeds the limit.
• sort = 9
Specifies sort is invalid.
• table = 6
Specifies the table action is invalid.