PC SOFT

AYUDA EN LÍNEA
DE WINDEV, WEBDEV Y WINDEV MOBILE


WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Otros
Procedimientos almacenados
SpreadsheetSelectPlus (Function)
 
Selects one or more cells in a Spreadsheet control found in a window.
Ejemplo
SpreadsheetSelectMinus(PSHEET_Spreadsheet)
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "A2", "B5")
SpreadsheetStyleSelection(PSHEET_Spreadsheet, psheetBackgroundColor, LightRed)
// Select a range of cells to merge them
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "B1", "D1")
// Merge the cells
ExecuteAAF(PSHEET_Spreadsheet, aafSpreadsheetMerge)
// Select a range of cells to merge them
SpreadsheetSelectPlus(PSHEET_Spreadsheet, "B1", "D1")
// Merge the cells
AAFExecute(PSHEET_Spreadsheet, aafSpreadsheetMerge)
Sintaxis
SpreadsheetSelectPlus(<Spreadsheet Control> [, <Start Cell> [, <End Cell>]])
<Spreadsheet Control>: Control name
Name of Spreadsheet control to use.
<Start Cell>: Optional character string (with quotes)
Name of the cell to select. This parameter has the following format: <Column letter><Row number>. For example: "A32".
If this parameter corresponds:
  • to the name of a column ("A" for example), the specified column is entirely selected.
  • to the number of a row ("2" for example), the specified row is entirely selected.
  • to an empty string (""), all the cells found in the Spreadsheet control are selected.
If this parameter is not specified, all the cells as well as the row and column headers are selected.
If <End Cell> is specified, <Start Cell> corresponds to the first cell to select in a range of cells.
If <End Cell> is not specified, only <Start Cell> is selected.
<End Cell>: Optional character string (with quotes)
Name of the cell corresponding to the end of the range of cells to select. This parameter has the following format: <Column letter><Row number>. For example: "A32".
If this parameter is not specified, only <Start Cell> is selected.
If <End Cell> corresponds to a cell positioned before <Start Cell>, the coordinates are reversed and the selection is performed.
Observaciones
Componente : wd240obj.dll
Versión mínima requerida
  • Versión 20
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario