Version

UltraSpreadsheetState Enumeration

Represents the different states of the UltraSpreadsheet control. Used to evaluate whether a specific command can be executed.
Syntax
'Declaration
 
Public Enum UltraSpreadsheetState 
   Inherits System.Enum
public enum UltraSpreadsheetState : System.Enum 
Members
MemberDescription
AddWorksheetAdding or inserting of worksheets is allowed.
AllAll the available states
ArrowKeysNavigateWithinCellThe spreadsheet is in edit mode and its UltraSpreadsheet.CellEditMode is set so that the arrow keys navigate within the cell.
CanRedoThe UltraSpreadsheet.UndoManager can perform an redo operation.
CanUndoThe UltraSpreadsheet.UndoManager can perform an undo operation.
DeleteWorksheetDeleting of worksheets is allowed.
EnterKeyNavigationThe UltraSpreadsheet.IsEnterKeyNavigationEnabled is true.
HasColumnScrollRegionSplitThere is a vertical splitter between the 2 SpreadsheetColumnScrollRegion instances.
HasColumnsSelectedThere is at least one cell range in the active selection that completely encompasses the cells of one or more columns.
HasFrozenPanesHas frozen sheet panes
HasMultiplePanesHas multiple sheet panes
HasMultipleSelectedWorksheetsThere are multiple selected worksheet tabs.
HasMultipleSelectionRangesThere are 2 or more SpreadsheetSelection.CellRanges in the UltraSpreadsheet.ActiveSelection
HasRowScrollRegionSplitThere is a horizontal splitter between the 2 SpreadsheetRowScrollRegion instances.
HasRowsSelectedThere is at least one cell range in the active selection that completely encompasses the cells of one or more rows.
HasScrollLockThe scroll lock has been toggled.
HasTableThe active cell is part of a WorksheetTable.
HasWorkbookThe Workbook has been provided
HasWorksheetHas a workbook with at least one worksheet.
IsDeleteColumnsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowDeletingColumns is false.
IsDeleteRowsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowDeletingRows is false.
IsFilterProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowFiltering is false.
IsFormatCellsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowFormattingCells is false.
IsFormatColumnsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowFormattingColumns is false.
IsFormatRowsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowFormattingRows is false.
IsInAddToSelectionModeThe UltraSpreadsheet.SelectionMode is set to AddToSelection.
IsInEditModeThe UltraSpreadsheet is currently editing the UltraSpreadsheet.ActiveCell
IsInEndModeThe UltraSpreadsheet.IsInEndMode is true.
IsInExtendedSelectionModeThe UltraSpreadsheet.SelectionMode is set to ExtendSelection.
IsInNameBoxThe keyboard focus is within the namebox.
IsInNormalSelectionModeThe UltraSpreadsheet.SelectionMode is set to Normal.
IsInsertColumnsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowInsertingColumns is false.
IsInsertRowsProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowInsertingRows is false.
IsNavigatingUnlockedCellsOnlyThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.SelectionMode is set to UnlockedCells
IsNextWorksheetTabOutOfViewThere is a tab for a visible Infragistics.Documents.Excel.Worksheet out of view on the right in the tab area.
IsPreviousWorksheetTabOutOfViewThere is a tab for a visible Infragistics.Documents.Excel.Worksheet out of view on the left in the tab area.
IsRenamingWorksheetThe name of a Worksheet is in the process of being changed
IsSingleCellSelectionThere are 1 SpreadsheetSelection.CellRanges in the UltraSpreadsheet.ActiveSelection and that represents a single cell
IsSortProtectedThe associated Worksheet is protected and the Infragistics.Documents.Excel.WorksheetProtection.AllowSorting is false.
IsWorkbookProtectedChanges to the Workbook's structure are not allowed because it has been protected.
IsWorksheetProtectedThe associated Worksheet is protected.
MixedTableCellSelectionThere are table and non-table cells selected or cells from multiple tables
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