ig.spreadsheet.SpreadsheetUserPromptTrigger

Identifies the action that led to the prompt being displayed.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.ext_web.js
infragistics.xml.js
infragistics.dv_interactivity.js
infragistics.dv_core.js
infragistics.documents.core_core.js
infragistics.excel_core.js
infragistics.ext_ui.js
infragistics.undo.js
  • changePartOfDataTable

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    26

    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:
    18

    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:
    27

    One or more cells are locked within the columns that are being deleted.

  • deletingLockedRowCells

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    28

    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:
    19

    An error occurred during some operation other than the ones relating to the other members of this enum.

  • intersectsMergedCells

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    17

    The target range(s) intersect with but does not contain one or more merged cells.

  • invalidArrayFormulaLockedState

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    25

    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:
    21

    An error occurred while trying to navigate to the target address of a hyperlink.

  • invalidHyperlinkReference

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    22

    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:
    23

    The operation being performed involves one or more cells that are locked in a protected Worksheet.

  • invalidSortOrFilterRange

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    30

    The 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.

  • invalidWorksheetName

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    3

    The name entered during an in-place edit/rename of a Worksheet Name violates the constraints.

  • largeCopyOperation

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    31

    The copy operation will include a large number of cells and may take a long time to complete.

  • largePasteOperation

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    29

    The paste operation will affect a large number of cells and may take a long time to complete.

  • noSingleAllowedEditRange

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    24

    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.

  • pasteMultipleSheetsTables

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    16

    A paste of one or more tables cannot be performed when multiple worksheets are selected.

  • pasteMultipleSourceAndTargetRanges

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    11

    There are multiple cell ranges in the source and target sheets.

  • tableChangeWithMultipleSelectedSheets

    Type:
    ig.spreadsheet.SpreadsheetUserPromptTrigger
    Default:
    20

    The operation cannot be performed when there are multiple sheets selected and the change would affect a table in one of the worksheets.

The current widget has no events.
The current widget has no public methods.

Copyright © 1996 - 2020 Infragistics, Inc. All rights reserved.