This topic provides information about replay-only actions for testing the WinSpreadsheet™ control.
This topic contains the following sections:
Returns data for the identified 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.
The option supplied is not one of the valid options, valid options are [ sshtCellTypeValue , sshtCellTypeFormula , sshtCellTypeText ]
Activate the identified 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.
Puts the identified cell into edit mode
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.
If a cell is in editmode, exit edit mode by the supplied mode
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 [ sshtUpdateSelectedCells , sshtCreateArrayFormula , sshtUpdateActiveCellOnly , sshtDiscardChanges ]
Appends the supplied text to the cell currently in edit mode
The following table summarizes the action parameters followed by code examples where applicable.
Returns the string representation of the currently active cell.
Returns the string name of the currently active sheet.
Returns the string representation of the selection of just the active cell range.
Returns the string representation of the entire selection of cells.
Returns a value from 10-400, 100 being the default representing the percentage of zoom for the current worksheet.
The following topics provide additional information related to this topic.