WinSpreadsheet - Enumerations Reference

WinSpreadsheet Enumerations Reference

Introduction

This topic provides reference material on the common enumerations used for testing the WinSpreadsheet™ control.

SshtCellDataType

This enumeration represents the type of cell data that will be returned from the GetCellData action.

The following table lists all the values of the enumeration.

Enumeration	Description
sshtCellTypeValue	Value 1 – Represents returning of the value of the cell. So if a formula is being used in the cell this will return the calculated value.
sshtCellTypeFormula	Value 2 – Represents returning the formula of a cell if it has one, if it does not will return an empty string.
sshtCellTypeText	Value 3 – Represents returning the formatted text of the cell.
sshtCellTypeHyperlink	Value 4 – Represents returning a string of the hyperlink of the cell.
sshtCellTypeTooltip	Value 5 – Represents returning a string of the tooltip of the cell.
sshtIsCellDataValid	Value 6 – Represents returning a bool whether the value of the cell is valid.

SshtExitEditType

This enumeration represents the different means to commit or discard the data when the cell is done editing.

The following table lists all the values of the enumeration.

Enumeration	Description
sshtUpdateSelectedCells	Value 1 – Represents committing the data entered to every currently selected cell.
sshtCreateArrayFormula	Value 2 – Represents committing the data as an array formula, which only affects the active cell range, if more than range of cells is selected.
sshtUpdateActiveCellOnly	Value 3 – Represents committing the data to only the currently active cell.
sshtDiscardChanges	Value 4 – Represents discarding the modified cell data and reverting to the previous data.

SshtCommandType

This enumeration represents the executable commands that can be invoked via the PerformCommand method supported by WinSpreadsheet. As these commands execute the similarly named IG Controls commands, for more information review the online documentation

Listed below are the commands of the Infragistics.Controls.Grids.SpreadsheetCommandType .

sshtActivatePreviousPane	sshtClearContents
sshtActivateNextPane	sshtSelectCurrentArray
sshtCellInSelectionRight	sshtCellInNextSelectionRange
sshtCellInSelectionLeft	sshtCellInPreviousSelectionRange
sshtCellInSelectionAbove	sshtSelectVisibleCellsOnly
sshtCellInSelectionBelow	sshtSelectActiveCellOnly
sshtCellRight	sshtRedo
sshtCellLeft	sshtUndo
sshtCellAbove	sshtEnterKeyNavigation
sshtCellBelow	sshtShiftEnterKeyNavigation
sshtCellWithDataLeft	sshtHideColumns
sshtCellWithDataRight	sshtUnhideColumns
sshtCellWithDataAbove	sshtHideRows
sshtCellWithDataBelow	sshtUnhideRows
sshtEdgeCellWithDataLeft	sshtAutoFitRowHeight
sshtEdgeCellWithDataRight	sshtAutoFitColumnWidth
sshtEdgeCellWithDataAbove	sshtMergeCellsAcross
sshtEdgeCellWithDataBelow	sshtMergeCells
sshtCellPageBelow	sshtMergeCellsAndCenter
sshtCellPageAbove	sshtUnmergeCells
sshtCellPageRight	sshtAddNewWorksheet
sshtCellPageLeft	sshtInsertNewWorksheets
sshtScrollLeft	sshtActivateNextWorksheet
sshtScrollRight	sshtActivatePreviousWorksheet
sshtScrollUp	sshtActivateAndSelectNextWorksheet
sshtScrollDown	sshtActivateAndSelectPreviousWorksheet
sshtScrollPageLeft	sshtScrollNextWorksheet
sshtScrollPageRight	sshtScrollPreviousWorksheet
sshtScrollPageAbove	sshtScrollToFirstWorksheet
sshtScrollPageBelow	sshtScrollToLastWorksheet
sshtFirstCellInRow	sshtActivatePreviousOutOfViewWorksheet
sshtFirstCellInView	sshtActivateNextOutOfViewWorksheet
sshtFirstCellInWorksheet	sshtSelectAllWorksheets
sshtFirstScrollableCellInRow	sshtUnselectWorksheets
sshtFirstScrollableCellInWorksheet	sshtRenameWorksheet
sshtLastCellInView	sshtDeleteWorksheets
sshtEnterEndMode	sshtZoomIn
sshtExitEndMode	sshtZoomOut
sshtLastUsedCell	sshtZoomToSelection
sshtLastUsedCellInRow	sshtZoomTo100
sshtSelectCurrentRegion	sshtToggleBold
sshtSelectCellRight	sshtToggleItalic
sshtSelectCellLeft	sshtToggleStrikeThrough
sshtSelectCellAbove	sshtToggleWrapText
sshtSelectCellBelow	sshtIncreaseIndentation
sshtSelectCellWithDataLeft	sshtDecreaseIndentation
sshtSelectCellWithDataRight	sshtIncreaseFontSize
sshtSelectCellWithDataAbove	sshtDecreaseFontSize
sshtSelectCellWithDataBelow	sshtAlignHorizontalCenter
sshtSelectEdgeCellWithDataLeft	sshtAlignHorizontalJustify
sshtSelectEdgeCellWithDataRight	sshtAlignHorizontalLeft
sshtSelectEdgeCellWithDataAbove	sshtAlignHorizontalRight
sshtSelectEdgeCellWithDataBelow	sshtAlignVerticalTop
sshtSelectCellPageBelow	sshtAlignVerticalMiddle
sshtSelectCellPageAbove	sshtAlignVerticalBottom
sshtSelectCellPageRight	sshtToggleSplitPanes
sshtSelectCellPageLeft	sshtToggleFreezePanes
sshtSelectFirstCellInRow	sshtFreezeFirstRow
sshtSelectFirstCellInView	sshtFreezeFirstColumn
sshtSelectFirstCellInWorksheet	sshtRemoveColumnScrollRegionSplit
sshtSelectFirstScrollableCellInRow	sshtSnapColumnScrollRegionSplit
sshtSelectFirstScrollableCellInWorksheet	sshtRemoveRowScrollRegionSplit
sshtSelectLastCellInView	sshtSnapRowScrollRegionSplit
sshtSelectLastUsedCell	sshtRemoveScrollRegionSplits
sshtSelectLastUsedCellInRow	sshtSnapScrollRegionSplits
sshtSelectRows	sshtDeleteRows
sshtSelectColumns	sshtInsertRows
sshtSelectAllCells	sshtDeleteColumns
sshtSwitchToNormalSelectionMode	sshtInsertColumns
sshtSwitchToExtendSelectionMode	sshtCut
sshtSwitchToAddToSelectionMode	sshtCopy
sshtFirstCellInViewWithinSelection	sshtPaste
sshtLastCellInViewWithinSelection	sshtToggleCellEditMode
sshtEnterEditMode	sshtInsertCellsShiftRight
sshtEnterEditModeAndClearValue	sshtInsertCellsShiftDown
sshtExitEditModeAndUpdateActiveCell	sshtDeleteCellsShiftLeft
sshtExitEditModeAndUpdateSelectedCells	sshtDeleteCellsShiftUp
sshtExitEditModeAndCreateArrayFormula	sshtInsertCells
sshtExitEditModeAndDiscardChanges	sshtDeleteCells
sshtClearFormats	sshtToggleShowFormulasInCells
sshtToggleUnderline	sshtToggleDoubleUnderline
sshtFirstUnlockedCell	sshtLastUnlockedCell
sshtToggleSuperscript	sshtToggleSubscript
sshtOpenHyperlink	sshtRemoveHyperlinks
sshtClearHyperlinks

SshtSubItemType

This enumeration representing the selectable item types for the WinSpreadsheet.

The following table lists all the values of the enumeration.

Enumeration	Description
sshtCell	Value 1 – SubItem representing a Spreadsheet cell
sshtColumn	Value 2 – SubItem representing a Spreadsheet column
sshtRow	Value 3 – SubItem representing a Spreadsheet row
sshtSheet	Value 4 – SubItem representing a Spreadsheet Worksheet
sshtFormulaBarNameBox	Value 5 – SubItem representing the formula bar name box
sshtFormulaBarTextEditor	Value 6 – SubItem representing the formula bar Text editor

Topic	Purpose
WinSpreadsheet - Recordable Actions	This topic provides information about the recordable user actions for testing the WinSpreadsheet™ control.
WinSpreadsheet - Replay-Only Actions	This topic provides information about the replay only user actions for testing the WinSpreadsheet™ control.

Windows Forms Test Automation for UFT | Help Topics

WinSpreadsheet - Enumerations Reference