Version

UltraSpreadsheetAction Enumeration

Enumeration used to identify an action to be taken by the UltraSpreadsheet
Syntax
'Declaration
 
Public Enum UltraSpreadsheetAction 
   Inherits System.Enum
public enum UltraSpreadsheetAction : System.Enum 
Members
MemberDescription
ActivateAndSelectNextWorksheetActivates and selects the next visible Infragistics.Documents.Excel.Worksheet after the UltraSpreadsheet.ActiveWorksheet
ActivateAndSelectPreviousWorksheetActivates and selects the previous visible Infragistics.Documents.Excel.Worksheet before the UltraSpreadsheet.ActiveWorksheet
ActivateNextOutOfViewWorksheetActivates the visible worksheet that is the last partially visible worksheet tab in view or next visible worksheet if the last visible item is fully in view.
ActivateNextPaneActivates the next SpreadsheetPane if there are multiple panes and they are not frozen.
ActivateNextWorksheetActivates the next visible Infragistics.Documents.Excel.Worksheet after the UltraSpreadsheet.ActiveWorksheet
ActivatePreviousOutOfViewWorksheetActivates the visible worksheet that is before the first worksheet tab in view.
ActivatePreviousPaneActivates the previous SpreadsheetPane if there are multiple panes and they are not frozen.
ActivatePreviousWorksheetActivates the previous visible Infragistics.Documents.Excel.Worksheet before the UltraSpreadsheet.ActiveWorksheet
AddNewWorksheetAdds a new Infragistics.Documents.Excel.Worksheet after the current active worksheet and activates it.
AddTableColumnAdds one column to the end of the UltraSpreadsheet.ActiveTable Note, the selection must be completely within the table and only 1 worksheet may be selected.
AddTableRowAdds one row at the end of the UltraSpreadsheet.ActiveTable. Note, the selection must be completely within the table and not intersect with the header row and only 1 worksheet may be selected.
AlignHorizontalCenterChanges the horizontal alignment of the cell formats for the current selection switching between Center and General.
AlignHorizontalJustifyChanges the horizontal alignment of the cell formats for the current selection switching between Justify and General.
AlignHorizontalLeftChanges the horizontal alignment of the cell formats for the current selection switching between Left and General.
AlignHorizontalRightChanges the horizontal alignment of the cell formats for the current selection switching between Right and General.
AlignVerticalBottomChanges the vertical alignment of the cell formats for the current selection to Bottom.
AlignVerticalMiddleChanges the vertical alignment of the cell formats for the current selection to Middle.
AlignVerticalTopChanges the vertical alignment of the cell formats for the current selection to Top.
AutoFitColumnWidthUpdates the Infragistics.Documents.Excel.WorksheetColumn.Width based on the size of the content in the columns associated with the UltraSpreadsheet.ActiveSelection so that it will be resized based on the size of the contents.
AutoFitRowHeightUpdates the Infragistics.Documents.Excel.WorksheetRow.Height to be -1 for rows associated with the UltraSpreadsheet.ActiveSelection so that it will be resized based on the size of the contents.
CancelRenameWorksheetExits the renaming of a worksheet without committing the changes to the name
CellAboveNavigates to the cell above the active cell.
CellBelowNavigates to the cell below the active cell.
CellInNextSelectionRangeActivates the first cell in the next cell range of the SpreadsheetSelection
CellInPreviousSelectionRangeActivates the first cell in the previous cell range of the SpreadsheetSelection
CellInSelectionAboveNavigates to the cell above within the selection if multiple cells are selected otherwise navigates to the cell above.
CellInSelectionBelowNavigates to the cell below within the selection if multiple cells are selected otherwise navigates to the cell below.
CellInSelectionLeftNavigates to the previous cell within the selection if multiple cells are selected otherwise navigates to the cell to the left.
CellInSelectionRightNavigates to the next cell within the selection if multiple cells are selected otherwise navigates to the cell to the right.
CellInTableLeftNavigates to the previous cell within the UltraSpreadsheet.ActiveCell unless the active cell is within the total row.
CellInTableRightNavigates to the next cell within the UltraSpreadsheet.ActiveTable unless the active cell is within the totql row.
CellLeftNavigates to the cell to the left of the active cell.
CellPageAboveScrolls up one page and activates a cell in the same column and relative visible row.
CellPageBelowScrolls down one page and activates a cell in the same column and relative visible row.
CellPageLeftScrolls left one page and activates a cell in the same row and relative visible column.
CellPageRightScrolls right one page and activates a cell in the same row and relative visible column.
CellRightNavigates to the cell to the right of the active cell.
CellWithDataAboveNavigates to the cell above the active cell that has data or the first cell in the column if there are none with data.
CellWithDataBelowNavigates to the cell below the active cell that has data or the last cell in the column if there are none with data.
CellWithDataLeftNavigates to the cell to the left of the active cell that has data or the first cell in the row if there are none with data.
CellWithDataRightNavigates to the cell to the right of the active cell that has data or the last cell in the row if there are none with data.
CircleInvalidDataChecks the validity of all the cells in the current UltraSpreadsheet.ActiveWorksheet based on their associated DataValidationRule if it has one.
ClearAllFilterAndSortClears all the filter and sort settings for the SpreadsheetSelection.ActiveCell of the UltraSpreadsheet.ActiveSelection. If the active cell is within the UltraSpreadsheet.ActiveTable then the filter and sort information of the table is cleared. If the cell is not within a table the Infragistics.Documents.Excel.Worksheet.FilterSettings sort and filtering are cleared even if the cell is not within its region. The command is not available when there are multiple worksheets selected or if the active cell is in an area that does not have any sorting or filtering.
ClearContentsClears the value of the selected cells.
ClearFilterClears the filter for the column associated with the SpreadsheetSelection.ActiveCell of the UltraSpreadsheet.ActiveSelection. The command is not available when there are multiple worksheets selected or if the active cell is within a column that does not have any filtering. This command may also be executed with a string containing the A1 format cell address of the target cell for the operation.
ClearFormatsResets the cell format for the cells associated with the selection including the row and column cell format for rows and columns that are entirely selected.
ClearHyperlinksRemoves hyperlinks from the selected cells without removing the formatting.
ClearValidationCirclesClears any invalidation circles that are cached for the current UltraSpreadsheet.ActiveWorksheet
CommitRenameWorksheetAttempts to exit the renaming of a worksheet and committing the changes to the name.
ConvertTableToRangeRemoves the UltraSpreadsheet.ActiveTable and converts it to a normal range of cells.
CopyCopies the information from the selection to the clipboard.
CutCopies the information from the selection to the clipboard and clears the contents.
DecreaseFontSizeDecreases the size of the font for the cell format of the current selection based on the current state of the active cell.
DecreaseIndentationDecreases the Indent of the cell format of the current selection based on the current state of each cell and potentially changing other properties such as horizontal alignment to one that supports indentation.
DeleteCellsDeletes the cells associated with the current selection and shifts the cells based on where data is in adjacent cells.
DeleteCellsShiftLeftDeletes the cells associated with the current selection and shifts the cells that exist on the right of the selection to the left.
DeleteCellsShiftUpDeletes the cells associated with the current selection and shifts the cells that exist below of the selection upward.
DeleteColumnsRemoves columns associated with the current selection.
DeleteRowsRemoves rows associated with the current selection.
DeleteTableColumnsDeletes one or more columns in the UltraSpreadsheet.ActiveTable based on the current selection. Note, the selection must be completely within the table and only 1 worksheet may be selected.
DeleteTableRowsDeletes one or more rows in the UltraSpreadsheet.ActiveTable based on the current selection. Note, the selection must be completely within the table and not intersect with the header row and only 1 worksheet may be selected.
DeleteWorksheetsRemoves the selected worksheets from the associated Workbook.
EdgeCellWithDataAboveNavigates to the farthest contiguous cell with data above the active cell. If the active cell has no data or the cell above does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the column if there are no more cells with data.
EdgeCellWithDataBelowNavigates to the farthest contiguous cell with data below the active cell. If the active cell has no data or the cell below does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the column if there are no more cells with data.
EdgeCellWithDataLeftNavigates to the farthest contiguous cell with data to the left of the active cell. If the active cell has no data or the cell to the left does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the row if there are no more cells with data.
EdgeCellWithDataRightNavigates to the farthest contiguous cell with data to the right of the active cell. If the active cell has no data or the cell to the right does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the row if there are no more cells with data.
EnterEditModeStarts in place editing of the UltraSpreadsheet.ActiveCell starting with the current value
EnterEditModeAndClearValueStarts in place editing of the UltraSpreadsheet.ActiveCell starting with an empty value
EnterEndModeChanges the UltraSpreadsheet.IsInEndMode to true
EnterKeyNavigationThe cell adjacent to the active cell in the direction indicated by the UltraSpreadsheet.EnterKeyNavigationDirection should be activated.
ExitEditModeAndCreateArrayFormulaEnds edit mode of the UltraSpreadsheet.ActiveCell and updates all the cells within the selection with an array formula from current edit value.
ExitEditModeAndDiscardChangesEnds edit mode of the UltraSpreadsheet.ActiveCell and discards any changes made while editing.
ExitEditModeAndUpdateActiveCellEnds edit mode of the UltraSpreadsheet.ActiveCell and updates the active cell's value based on the current edit value.
ExitEditModeAndUpdateSelectedCellsEnds edit mode of the UltraSpreadsheet.ActiveCell and updates all the cells within the selection with the cell's value based on the current edit value.
ExitEndModeChanges the UltraSpreadsheet.IsInEndMode to false
FilterByCellColorSimilar to FilterByCellValue except the filter is based on the resolved background color of the active cell.
FilterByCellFontColorSimilar to FilterByCellValue except the filter is based on the resolved text/font color of the active cell.
FilterByCellIconSimilar to FilterByCellValue except the filter is based on the resolved icon of the active cell.
FilterByCellValueFilters the data region based on the current value of the SpreadsheetSelection.ActiveCell of the UltraSpreadsheet.ActiveSelection. If the active cell is within the UltraSpreadsheet.ActiveTable then the filter for the column associated with the active cell is set to the new filter. If the cell is within the Infragistics.Documents.Excel.Filtering.WorksheetFilterSettings.Region of the Infragistics.Documents.Excel.Worksheet.FilterSettings then the filter for the column of that region associated with the active cell is set to the new filter. Otherwise a new region is created for the Infragistics.Documents.Excel.Worksheet.FilterSettings based on the selection and the filter is created for that column.
FirstCellInRowNavigates to the first cell in the row
FirstCellInViewNavigates to the upper left cell in view.
FirstCellInViewWithinSelectionChanges the UltraSpreadsheet.ActiveCell to be the upper left most cell in view within the active selection range.
FirstCellInWorksheetNavigates to the first cell in the Worksheet.
FirstScrollableCellInRowNavigates to the cell of the first scrollable column in the row. This is the same as FirstCellInRow unless there are frozen panes and then the first scrollable column is based on the number of frozen column.
FirstScrollableCellInWorksheetNavigates to the cell for the first scrollable row and column in the Worksheet. This is the same as FirstCellInView unless there are frozen panes and then the first scrollable row and column are based on the number of frozen rows and columns.
FirstUnlockedCellNavigates to the leftmost unlocked cell of the topmost row.
FreezeFirstColumnChanges the DisplayOptions of the active worksheet so that the first currently visible column will be frozen at the left and the right area can scroll from the next column until the last column.
FreezeFirstRowChanges the DisplayOptions of the active worksheet so that the first currently visible row will be frozen at the top and the bottom area can scroll from the next row until the last row.
HideColumnsSets the Infragistics.Documents.Excel.RowColumnBase.Hidden to true for the columns associated with the UltraSpreadsheet.ActiveSelection.
HideRowsSets the Infragistics.Documents.Excel.RowColumnBase.Hidden to true for the rows associated with the UltraSpreadsheet.ActiveSelection.
IncreaseFontSizeIncreases the size of the font for the cell format of the current selection based on the current state of the active cell.
IncreaseIndentationIncreases the Indent of the cell format of the current selection based on the current state of each cell and potentially changing other properties such as horizontal alignment to one that supports indentation.
InsertCellsInserts cells based on the current selection and shifts the cells based on where data is in adjacent cells.
InsertCellsShiftDownInserts cells before the cells associated with the current selection shifting the existing cells down.
InsertCellsShiftRightInserts cells before the cells associated with the current selection shifting the existing cells to the right.
InsertColumnsInserts columns before the columns associated with the current selection. If multiple columns are selected then multiple columns will be inserted.
InsertNewWorksheetsInserts a new Infragistics.Documents.Excel.Worksheet for each selected Worksheet before the active worksheet and activates the first new sheet.
InsertRowsInserts rows before the rows associated with the current selection. If multiple rows are selected then multiple rows will be inserted.
InsertTableColumnsInserts one or more columns in the UltraSpreadsheet.ActiveTable based on the current selection width relative to the left edge of the selection. Note, the selection must be completely within the table and only 1 worksheet may be selected.
InsertTableRowsInserts one or more rows in the UltraSpreadsheet.ActiveTable based on the current selection height relative to the top edge of the selection. Note, the selection must be completely within the table and not intersect with the header row and only 1 worksheet may be selected.
LastCellInViewNavigates to the lower right cell in view.
LastCellInViewWithinSelectionChanges the UltraSpreadsheet.ActiveCell to be the lower right most cell in view within the active selection range.
LastUnlockedCellNavigates to the rightmost unlocked cell of the bottommost row.
LastUsedCellNavigates to the last row and column for which data or formatting have been provided.
LastUsedCellInRowNavigates the column of the end of the used range but stays within the current row of the active cell.
MergeCellsMerges the selected cells into one cell.
MergeCellsAcrossMerge the selected cells in one row into one cell.
MergeCellsAndCenterCombine and center the contents of the selected cells into a new larger cell.
OpenHyperlinkExecutes the hyperlink associated with the selection when a single cell is selected.
PasteUpdates the selection based on the information in the clipboard.
PickFromDropDownListDisplays a list of the string values of the adjacent cells above and below the UltraSpreadsheet.ActiveCell
ReapplyFilterAndSortReapplies the filter and sort settings for the SpreadsheetSelection.ActiveCell of the UltraSpreadsheet.ActiveSelection. If the active cell is within the UltraSpreadsheet.ActiveTable then the filter and sort information of the table is reapplied. If the cell is not within a table the Infragistics.Documents.Excel.Worksheet.FilterSettings sort and filtering are repplied even if the cell is not within its region. The command is not available when there are multiple worksheets selected or if the active cell is within a table that does not have any sorting or filtering.
RedoUsed to re-execute the last change operation that was undo, if possible.
RemoveColumnScrollRegionSplitRemoves the vertical split and sets the LeftPaneWidth of the UnfrozenPaneSettings to 0.
RemoveHyperlinksRemoves hyperlinks associated with the selected cells.
RemoveRowScrollRegionSplitRemoves the horizontal split and sets the TopPaneHeight of the UnfrozenPaneSettings to 0.
RemoveScrollRegionSplitsRemoves both the horizontal and vertical splits so that there is only a single scrolling region remaining.
RenameWorksheetEnters edit mode on the tab associated with the active worksheet.
ResetNameBoxWidthResets the NameBoxWidth to its default value.
ScrollDownScrolls the active pane's row scroll region down by 1 row.
ScrollLeftScrolls the active pane's column scroll region left by 1 column.
ScrollNextWorksheetIncrements the Infragistics.Documents.Excel.WorkbookWindowOptions.FirstVisibleTabIndex to the next visible worksheet
ScrollPageAboveScrolls the active pane's row scroll region up by the size of the viewable area.
ScrollPageBelowScrolls the active pane's row scroll region down by the size of the viewable area.
ScrollPageLeftScrolls the active pane's column scroll region left by the size of the viewable area.
ScrollPageRightScrolls the active pane's column scroll region right by the size of the viewable area.
ScrollPreviousWorksheetDecrements the Infragistics.Documents.Excel.WorkbookWindowOptions.FirstVisibleTabIndex to the previous visible worksheet
ScrollRightScrolls the active pane's column scroll region right by 1 column.
ScrollToFirstWorksheetScrolls the tab area such that the first visible worksheet tab is in view
ScrollToLastWorksheetScrolls the tab area such that the last visible worksheet tab is in view
ScrollUpScrolls the active pane's row scroll region up by 1 row.
SelectActiveCellOnlyChanges the selection such that it only contains the ActiveCell.
SelectAllCellsReplaces the selection range containing the active cell with a selection range that encompasses the entire worksheet.
SelectAllWorksheetsSelects all the visible worksheet tabs within the UltraSpreadsheet.Workbook
SelectCellAboveSelects from the active cell to the cell above the active cell.
SelectCellBelowSelects from the active cell to the cell below the active cell.
SelectCellLeftSelects from the active cell to the cell to the left of the active cell.
SelectCellPageAboveScrolls up one page and selects from the active cell to a cell in the same column and relative visible row.
SelectCellPageBelowScrolls down one page and selects from the active cell to a cell in the same column and relative visible row.
SelectCellPageLeftScrolls left one page and selects from the active cell to a cell in the same row and relative visible column.
SelectCellPageRightScrolls right one page and selects from the active cell to a cell in the same row and relative visible column.
SelectCellRightSelects from the active cell to the cell to the right of the active cell.
SelectCellWithDataAboveSelects from the active cell to the cell above the active cell that has data or the first cell in the column if there are none with data.
SelectCellWithDataBelowSelects from the active cell to the cell below the active cell that has data or the last cell in the column if there are none with data.
SelectCellWithDataLeftSelects from the active cell to the cell to the left of the active cell that has data or the first cell in the row if there are none with data.
SelectCellWithDataRightSelects from the active cell to the cell to the right of the active cell that has data or the last cell in the row if there are none with data.
SelectColumnsReplaces the selection range containing the active cell with a selection range that encompasses the columns for that range.
SelectCurrentArraySelects the region associated with an array formula that is applied to the active cell.
SelectCurrentRegionSelects the cells adjacent to the active cell that have data or selects the entire worksheet if the current region is already selected or the current cell range selection isn't contained within the calculated current region.
SelectEdgeCellWithDataAboveSelects from the active cell to the farthest contiguous cell with data above the active cell. If the active cell has no data or the cell above does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the column if there are no more cells with data.
SelectEdgeCellWithDataBelowSelects from the active cell to the farthest contiguous cell with data below the active cell. If the active cell has no data or the cell below does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the column if there are no more cells with data.
SelectEdgeCellWithDataLeftSelects from the active cell to the farthest contiguous cell with data to the left of the active cell. If the active cell has no data or the cell to the left does not have data, it will navigate to the start of the next cell that has data in that direction or the first cell in the row if there are no more cells with data.
SelectEdgeCellWithDataRightSelects from the active cell to the farthest contiguous cell with data to the right of the active cell. If the active cell has no data or the cell to the right does not have data, it will navigate to the start of the next cell that has data in that direction or the last cell in the row if there are no more cells with data.
SelectEntireTableColumnSelects the cells of the entire columns in the UltraSpreadsheet.ActiveTable based on the portion of the active range of the current selection that intersects with the table.
SelectFirstCellInRowSelects from the active cell to the first cell in the row
SelectFirstCellInViewSelects from the active cell to the upper left cell in view.
SelectFirstCellInWorksheetSelects from the active cell to the first cell in the Worksheet.
SelectFirstScrollableCellInRowSelects from the active cell to the cell of the first scrollable column in the row. This is the same as FirstCellInRow unless there are frozen panes and then the first scrollable column is based on the number of frozen column.
SelectFirstScrollableCellInWorksheetSelects from the active cell to the cell for the first scrollable row and column in the Worksheet. This is the same as FirstCellInView unless there are frozen panes and then the first scrollable row and column are based on the number of frozen rows and columns.
SelectLastCellInViewSelects from the active cell to the lower right cell in view.
SelectLastUsedCellSelects from the active cell to the last row and column for which data or formatting have been provided.
SelectLastUsedCellInRowSelects from the active cell the column of the end of the used range but stays within the current row of the active cell.
SelectRowsReplaces the selection range containing the active cell with a selection range that encompasses the rows for that range.
SelectTableColumnDataSelects the data area of the columns in the UltraSpreadsheet.ActiveTable based on the portion of the active range of the current selection that intersects with the table. If the intersection includes the header or footer rows then the operation is the same as SelectEntireTableColumn
SelectTableRowSelects the cells of the entire rows in the UltraSpreadsheet.ActiveTable based on the portion of the active range of the current selection that intersects with the table.
SelectVisibleCellsOnlyChnages the selection such that it only does not contain any hidden rows or columns.
ShiftEnterKeyNavigationThe cell adjacent to the active cell in the reverse of the direction indicated by the UltraSpreadsheet.EnterKeyNavigationDirection should be activated.
ShowCellDropDownDisplays the dropdown associated with the UltraSpreadsheet.ActiveCell which may be things such as the filter menu dropdown, the list of values from the cell's list type data validation, a list of formulas for a cell in the total row of a table, etc.
ShowCustomSortDialogDisplays the custom sort dialog for the worksheet sort region
ShowFormatCellsDialogDisplays the format cells dialog for the current selection.
SnapColumnScrollRegionSplitAdjusts the width of the left row scroll region such that it is aligned to the edge of a column.
SnapRowScrollRegionSplitAdjusts the height of the top row scroll region such that it is aligned to the edge of a row.
SnapScrollRegionSplitsAdjusts the height of the top and left scrolling regions such that they are aligned to the edge or a row and column respectively.
SortAscendingThis causes an ascending sort for the current selection. The exact changes will depend on whether the current selection is within the UltraSpreadsheet.ActiveTable. If the selection is within a table then the column associated with the SpreadsheetSelection.ActiveCell is sorted ascending. If the selection is not within a table then the data range associated with the selection is sorted ascending via the Infragistics.Documents.Excel.Worksheet.SortSettings. The command is not available if the selection intesects table and non-table cells and cannot be performed if there are multiple selection ranges. This command may also be executed with a string containing the A1 format cell address of the target cell for the operation.
SortByCellColorSorts the data region based on the current background color of the SpreadsheetSelection.ActiveCell of the UltraSpreadsheet.ActiveSelection. If the active cell is within the UltraSpreadsheet.ActiveTable then the sort for the column associated with the active cell is set to the new sort condition. If the cell is within the Infragistics.Documents.Excel.Filtering.WorksheetFilterSettings.Region of the Infragistics.Documents.Excel.Worksheet.FilterSettings then the sort for the column of that region associated with the active cell is set to the new sort condition. Otherwise the Infragistics.Documents.Excel.Worksheet.SortSettings is updated based on the selection and the sort condition is created for that column. This command may also be executed with a string containing the A1 format cell address of the target cell for the operation.
SortByCellFontColorSimilar to SortByCellColor except the sort condition is based on the resolved text/font color of the active cell.
SortByCellIconSimilar to SortByCellColor except the sort condition is based on the resolved icon of the active cell.
SortDescendingThis causes a descending sort for the current selection. The exact changes will depend on whether the current selection is within the UltraSpreadsheet.ActiveTable. If the selection is within a table then the column associated with the SpreadsheetSelection.ActiveCell is sorted descending. If the selection is not within a table then the data range associated with the selection is sorted descending via the Infragistics.Documents.Excel.Worksheet.SortSettings. The command is not available if the selection intesects table and non-table cells and cannot be performed if there are multiple selection ranges. This command may also be executed with a string containing the A1 format cell address of the target cell for the operation.
SwitchToAddToSelectionModeChanges the UltraSpreadsheet.SelectionMode to AddToSelection.
SwitchToExtendSelectionModeChanges the UltraSpreadsheet.SelectionMode to ExtendSelection.
SwitchToNormalSelectionModeChanges the UltraSpreadsheet.SelectionMode to Normal.
ToggleBoldChanges the bold state of the cell format of the current selection based on the bold state of the active cell.
ToggleCellEditModeUsed while in edit mode to change the UltraSpreadsheet.CellEditMode and switch between the modes that control how the arrow keys are handled.
ToggleDoubleUnderlineChanges the underline state of the cell format of the current selection based on the underline state of the active cell.
ToggleFilterThis command turns on or off filtering for the current selection. The exact changes will depend on whether the current selection is within the UltraSpreadsheet.ActiveTable. If within a table and the Infragistics.Documents.Excel.WorksheetTable.IsFilterUIVisible is false, this will ensure the Infragistics.Documents.Excel.WorksheetTable.IsHeaderRowVisible and Infragistics.Documents.Excel.WorksheetTable.IsFilterUIVisible are true; otherwise it will invoke Infragistics.Documents.Excel.WorksheetTable.ClearFilters and set the Infragistics.Documents.Excel.WorksheetTable.IsFilterUIVisible is false. Outside of a table, the property affects the Infragistics.Documents.Excel.Worksheet.FilterSettings. If there is a filtered region then the command invokes the Infragistics.Documents.Excel.Filtering.WorksheetFilterSettings.ClearFilters and then clears/removes the region; otherwise it set the worksheet filter region to a region relative to the selection. The command is not available if the selection intesects table and non-table cells and cannot be performed if there are mulitple selection ranges.
ToggleFreezePanesChanges the DisplayOptions of the active worksheet to add or remove frozen areas. If the worksheet currently has frozen areas then they will be removed. If the worksheet currently has unfrozen splits then they will be converted to frozen splits. Otherwise it will create frozen areas based on the current active cell.
ToggleItalicChanges the italic state of the cell format of the current selection based on the italic state of the active cell.
ToggleShowFormulasInCellsChanges the Infragistics.Documents.Excel.DisplayOptions.ShowFormulasInCells of the selected worksheets.
ToggleSplitPanesChanges the DisplayOptions of the active worksheet to add or remove resizable split areas that are separately scrollable. If the worksheet currently has split areas then the splits will be removed. If the worksheet has frozen areas they will be converted to splits. Otherwise it will create split areas based on the current active cell.
ToggleStrikeThroughChanges the strikethrough state of the cell format of the current selection based on the strikethrough state of the active cell.
ToggleSubscriptChanges the subscript state of the cell format of the current selection based on the subscript state of the active cell.
ToggleSuperscriptChanges the superscript state of the cell format of the current selection based on the superscript state of the active cell.
ToggleTableTotalRowChanges the visibility of the total row in the UltraSpreadsheet.ActiveTable.
ToggleUnderlineChanges the underline state of the cell format of the current selection based on the underline state of the active cell.
ToggleWrapTextChanges the wrap state of the cell format of the current selection based on the wrap state of the active cell.
UndoUsed to reverse the last change operation.
UnhideColumnsSets the Infragistics.Documents.Excel.RowColumnBase.Hidden to false for the columns associated with the UltraSpreadsheet.ActiveSelection.
UnhideRowsSets the Infragistics.Documents.Excel.RowColumnBase.Hidden to false for the rows associated with the UltraSpreadsheet.ActiveSelection.
UnmergeCellsSplit the current cell in multiple cells
UnselectWorksheetsClears the selected worksheet tabs such that only the active tab is selected.
ZoomInChanges the magnification of the currently selected Infragistics.Documents.Excel.Worksheet of the UltraSpreadsheet to a higher value in increments of 10%
ZoomOutChanges the magnification of the currently selected Infragistics.Documents.Excel.Worksheet of the UltraSpreadsheet to a lower value in increments of 10%
ZoomTo100Changes the magnification of the currently selected Infragistics.Documents.Excel.Worksheet of the UltraSpreadsheet to 100%
ZoomToSelectionChanges the magnification of the currently selected Infragistics.Documents.Excel.Worksheet to display the currently selected cells.
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