ig.spreadsheet.SpreadsheetUserPromptTrigger
Dependencies
-
changePartOfDataTable
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 25
Changes cannot be made to only a portion of the data table.
-
clearCellContentError
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 0
An error occurred while clearing the contents of the selected cells.
-
conflictingWorksheetName
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 4
The name entered during an in-place edit/rename of a Worksheet Name conflicts with the name of an existing Worksheet.
-
copyInvalidRanges
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 17
The selection is invalid for a copy operation. If there are multiple ranges then the items must have the same start and end row or start and end column without overlapping and without leaving any gaps.
-
deletingLockedColumnCells
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 26
One or more cells are locked within the columns that are being deleted.
-
deletingLockedRowCells
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 27
One or more cells are locked within the rows that are being deleted.
-
deletingWorksheets
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 5
One or more worksheets are being deleted which may result in loss of data.
-
editError
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 2
An error occurred while attempting to update the active cell or selected cells while exiting edit mode.
-
formulaParseError
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 1
An error occurred while parsing the formula entered while in edit mode.
-
general
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 18
An error occurred during some operation other than the ones relating to the other members of this enum.
-
intersectsMergedCells
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 16
The target range(s) intersect with but does not contain one or more merged cells.
-
invalidArrayFormulaLockedState
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 24
The Locked state of the target cells for an array formula are not consistent.
-
invalidCommandForMixedCellSelections
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 8
A command was being invoked that isn't valid when there are a combination of rows or columns and cells selected.
-
invalidCommandForMultipleSelections
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 7
A command was being invoked that isn't valid when there is more than one selected cell ranges.
-
invalidCommandForOverlappingSelections
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 6
A command was being invoked that isn't valid when there are selected cell ranges that overlap.
-
invalidHyperlinkAddress
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 20
An error occurred while trying to navigate to the target address of a hyperlink.
-
invalidHyperlinkReference
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 21
The hyperlink is a reference to a location within the workbook but that location is not a location that currently exists.
-
invalidNameBoxValue
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 9
A value was entered into the name box of the formula bar that did not represent the address to navigate to nor a valid name to use for the selection.
-
invalidProtectedWorksheetChange
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 22
The operation being performed involves one or more cells that are locked in a protected Worksheet.
-
invalidWorksheetName
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 3
The name entered during an in-place edit/rename of a Worksheet Name violates the constraints.
-
noSingleAllowedEditRange
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 23
The operation being performed involves one or more cells that are locked but not all the locked cells can be unlocked by a single range or not all required ranges were unlocked when the editRangePasswordNeeded event was invoked.
-
pasteCellRangeSize
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 10
The source area and target areas of the paste operation do have have the same size.
-
pasteError
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 14
An unspecified error occurred during a paste operation.
-
pasteIntersectsMergedCells
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 15
The target range(s) intersect with but does not contain one or more merged cells.
-
pasteInvalidSheetCount
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 13
The number of selected sheets in the target workbook is not an integral multiple of the number of selected sheets in the source workbook.
-
pasteInvalidSourceRanges
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 12
The selection in the source is invalid. Either it is empty/unset or there are multiple cell ranges in the source that do not form a valid copy selection. There must be at least 1 cell range selected and all items must have the same start and end row or start and end column without overlapping and without leaving any gaps.
-
pasteMultipleSourceAndTargetRanges
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 11
There are multiple cell ranges in the source and target sheets.
-
tableChangeWithMultipleSelectedSheets
- Type:
- ig.spreadsheet.SpreadsheetUserPromptTrigger
- Default:
- 19
The operation cannot be performed when there are multiple sheets selected and the change would affect a table in one of the worksheets.