Version

SpreadsheetUserPromptTrigger Enumeration

Identifies the action that led to the prompt being displayed.
Syntax
'Declaration
 
Public Enum SpreadsheetUserPromptTrigger 
   Inherits System.Enum
public enum SpreadsheetUserPromptTrigger : System.Enum 
Members
MemberDescription
ChangePartOfDataTableChanges cannot be made to only a portion of the data table.
ClearCellContentErrorAn error occurred while clearing the contents of the selected cells.
ConflictingWorksheetNameThe name entered during an in-place edit/rename of a Worksheet Name conflicts with the name of an existing Worksheet.
CopyInvalidRangesThe 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.
DeletingLockedColumnCellsOne or more cells are locked within the columns that are being deleted.
DeletingLockedRowCellsOne or more cells are locked within the rows that are being deleted.
DeletingWorksheetsOne or more worksheets are being deleted which may result in loss of data.
EditErrorAn error occurred while attempting to update the active cell or selected cells while exiting edit mode.
FormulaParseErrorAn error occurred while parsing the formula entered while in edit mode.
GeneralAn error occurred during some operation other than the ones relating to the other members of this enum.
IntersectsMergedCellsThe target range(s) intersect with but does not contain one or more merged cells.
InvalidArrayFormulaLockedStateThe Locked state of the target cells for an array formula are not consistent.
InvalidCommandForMixedCellSelectionsA command was being invoked that isn't valid when there are a combination of rows or columns and cells selected.
InvalidCommandForMultipleSelectionsA command was being invoked that isn't valid when there is more than one selected cell ranges.
InvalidCommandForOverlappingSelectionsA command was being invoked that isn't valid when there are selected cell ranges that overlap.
InvalidHyperlinkAddressAn error occurred while trying to navigate to the target address of a hyperlink.
InvalidHyperlinkReferenceThe hyperlink is a reference to a location within the workbook but that location is not a location that currently exists.
InvalidNameBoxValueA 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.
InvalidProtectedWorksheetChangeThe operation being performed involves one or more cells that are locked in a protected Worksheet.
InvalidSortOrFilterRangeThe specified or calculated range for the operation is not valid. It may not intersect the used range or may contain table and non-table regions.
InvalidWorksheetNameThe name entered during an in-place edit/rename of a Worksheet Name violates the constraints.
LargeCopyOperationThe copy operation will include a large number of cells and may take a long time to complete.
LargePasteOperationThe paste operation will affect a large number of cells and may take a long time to complete.
NoSingleAllowedEditRangeThe 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 UltraSpreadsheet.EditRangePasswordNeeded event was invoked.
PasteCellRangeSizeThe source area and target areas of the paste operation do have have the same size.
PasteErrorAn unspecified error occurred during a paste operation.
PasteIntersectsMergedCellsThe target range(s) intersect with but does not contain one or more merged cells.
PasteInvalidSheetCountThe number of selected sheets in the target workbook is not an integral multiple of the number of selected sheets in the source workbook.
PasteInvalidSourceRangesThe 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.
PasteMultipleSheetsTablesA paste of one or more tables cannot be performed when multiple worksheets are selected.
PasteMultipleSourceAndTargetRangesThere are multiple cell ranges in the source and target sheets.
TableChangeWithMultipleSelectedSheetsThe operation cannot be performed when there are multiple sheets selected and the change would affect a table in one of the worksheets.
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also