This topic provides information about recordable actions for testing the WinSpreadsheet ™ control.
This topic contains the following sections:
Select the identified cell.
The following table summarizes the action parameters followed by code examples where applicable.
The following is the only possible exception to this action and the likely reason causing them.
The selection string provided [sSelectionString] was invalid.
Set the value for the supplied cell
The following table summarizes the action parameters followed by code examples where applicable.
The possible exceptions to this action and the likely reason causing it is:
Object [Workbook] is null or has been disposed.
The following SpreadsheetCell [sCellArg ] was not found.
Unable to enter edit mode
Adds a new sheet to the WinSpreadsheet workbook
The following list contains the possible exceptions to this action and the likely reason causing them.
The point required to perform the operation is not visible.
The [AddNew Worksheet button] is not enabled.
Activates the identified sheet
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
Object [Workbook] is null or has been disposed.
The specified Worksheet index [oSheetArg ] is out of range
The following Worksheet [oSheetArg ] key was not found.
The following Worksheet [oSheetArg ] was not found.
Renames the identified sheet
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
Object [Workbook] is null or has been disposed.
The specified Worksheet index [oSheetArg ] is out of range
The following Worksheet [oSheetArg ] key was not found.
The following Worksheet [oSheetArg ] was not found.
Selects the identified sheet
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
Object [Workbook] is null or has been disposed.
The specified Worksheet index [oSheetArg ] is out of range
The following Worksheet [oSheetArg ] key was not found.
The following Worksheet [oSheetArg ] was not found.
Deselects the identified sheet
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
Object [Workbook] is null or has been disposed.
The specified Worksheet index [oSheetArg ] is out of range
The following Worksheet [oSheetArg ] key was not found.
The following Worksheet [oSheetArg ] was not found.
Cannot deselect the currently active sheet.
Sets the level of zoom
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
The specified value [iZoomLevel ] is out of range.
Perform the supplied command.
The following table summarizes the action parameters followed by code examples where applicable.
The only possible exception to this action and the likely reason causing it is:
The option supplied is not one of the valid options, valid options are [sshtCommandType values]
Types a name into the FormulaNameBox, which either selects the named reference, selects the cells identified by the string, or names the currently selected cells.
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
The [FormulaBar NameBox] is not enabled.
FormulaBar is not visible
This action cannot be performed while in edit mode.
Visit the hyperlink in the supplied cell.
The following table summarizes the action parameters followed by code examples where applicable.
The following list contains the possible exceptions to this action and the likely reason causing them.
Object [Workbook] is null or has been disposed.
The following SpreadsheetCell [sCellArg] was not found.
There was no Hyperlink found in the supplied cell.
The following topics provide additional information related to this topic.