Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_set_selection

of_set_selection() method

Specify which cell or cells are selected in a worksheet.

Syntax

worksheet.of_set_selection ( first_row, first_col{, last_row, last_col} )

Parameters

First_rowThe unsigned integer whose value is the number of first row in the range
First_colThe unsigned integer whose value is the number of first column in the range
Last_row(optional)The unsigned integer whose value is the number of last row in the range
Last_col(optional)The unsigned integer whose value is the number of last column in the range

Return value

Integer. Returns 1 if it succeeds and -1 if an error occurs.

Description

The most common requirement is to select a single cell, in which case last_row and last_col can be omitted. The active cell within a selected range is determined by the order in which first and last are specified.

Examples

worksheet1.of_set_selection( 0, 0 )    	 // select cell A1
worksheet2.of_set_selection( 0, 0, 2, 0 )    	 // select cells A1:A3