# GC.Spread.Sheets.InvalidOperationType

## Content

# Enumeration: InvalidOperationType

[Spread](../modules/GC.Spread).[Sheets](../modules/GC.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](GC.Spread.Sheets.InvalidOperationType#changepartofarrayformula)
- [changeSheetName](GC.Spread.Sheets.InvalidOperationType#changesheetname)
- [copyPaste](GC.Spread.Sheets.InvalidOperationType#copypaste)
- [customName](GC.Spread.Sheets.InvalidOperationType#customname)
- [cutProtected](GC.Spread.Sheets.InvalidOperationType#cutprotected)
- [dataObjectCellTypeInsertData](GC.Spread.Sheets.InvalidOperationType#dataobjectcelltypeinsertdata)
- [dragDrop](GC.Spread.Sheets.InvalidOperationType#dragdrop)
- [dragFill](GC.Spread.Sheets.InvalidOperationType#dragfill)
- [editProtected](GC.Spread.Sheets.InvalidOperationType#editprotected)
- [filter](GC.Spread.Sheets.InvalidOperationType#filter)
- [groupProtected](GC.Spread.Sheets.InvalidOperationType#groupprotected)
- [pivotTable](GC.Spread.Sheets.InvalidOperationType#pivottable)
- [ptOverlapValue](GC.Spread.Sheets.InvalidOperationType#ptoverlapvalue)
- [setFormula](GC.Spread.Sheets.InvalidOperationType#setformula)
- [sizeLimitExceeded](GC.Spread.Sheets.InvalidOperationType#sizelimitexceeded)
- [sort](GC.Spread.Sheets.InvalidOperationType#sort)
- [table](GC.Spread.Sheets.InvalidOperationType#table)

## Enumeration members

### <a id="changepartofarrayformula" name="changepartofarrayformula"></a> changePartOfArrayFormula

• **changePartOfArrayFormula** = `4`

Specifies the insert row is invalid.

___

### <a id="changesheetname" name="changesheetname"></a> changeSheetName

• **changeSheetName** = `5`

Specifies the changed sheet name is invalid.

___

### <a id="copypaste" name="copypaste"></a> copyPaste

• **copyPaste** = `1`

Specifies the copy paste is invalid.

___

### <a id="customname" name="customname"></a> customName

• **customName** = `15`

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

___

### <a id="cutprotected" name="cutprotected"></a> cutProtected

• **cutProtected** = `14`

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

___

### <a id="dataobjectcelltypeinsertdata" name="dataobjectcelltypeinsertdata"></a> dataObjectCellTypeInsertData

• **dataObjectCellTypeInsertData** = `16`

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

___

### <a id="dragdrop" name="dragdrop"></a> dragDrop

• **dragDrop** = `3`

Specifies the drag drop is invalid.

___

### <a id="dragfill" name="dragfill"></a> dragFill

• **dragFill** = `2`

Specifies the drag fill is invalid.

___

### <a id="editprotected" name="editprotected"></a> editProtected

• **editProtected** = `13`

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

___

### <a id="filter" name="filter"></a> filter

• **filter** = `7`

Specifies the add filter is invalid.

___

### <a id="groupprotected" name="groupprotected"></a> groupProtected

• **groupProtected** = `12`

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

___

### <a id="pivottable" name="pivottable"></a> pivotTable

• **pivotTable** = `10`

Specifies the change affect existed pivot table.

___

### <a id="ptoverlapvalue" name="ptoverlapvalue"></a> ptOverlapValue

• **ptOverlapValue** = `11`

Specifies the pivotTable change will overlap the valued cell.

___

### <a id="setformula" name="setformula"></a> setFormula

• **setFormula** = `0`

Specifies the formula is invalid.

___

### <a id="sizelimitexceeded" name="sizelimitexceeded"></a> sizeLimitExceeded

• **sizeLimitExceeded** = `18`

The specific event type that is triggered when the size of a file uploaded via the file picker exceeds the limit.

___

### <a id="sort" name="sort"></a> sort

• **sort** = `9`

Specifies sort is invalid.

___

### <a id="table" name="table"></a> table

• **table** = `6`

Specifies the table action is invalid.