Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_set_first_sheet

of_set_first_sheet() method

Specify which worksheet is the leftmost visible.

Syntax

Worksheet.of_set_first_sheet ( )

Return value

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

Description

The of_activate() method determines which worksheet is initially selected. However, if there are a large number of worksheets the selected worksheet may not appear on the screen. To avoid this you can select which is the leftmost visible worksheet using of_set_first_sheet()