Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_set_row_hidden

of_set_row_hidden() method

Set the option to hide a row.

Syntax

worksheet.of_set_row_hidden ( row, hidden )

Parameters

rowThe long whose value is the number of row
hiddenA boolean value that controls whether row is hidden

Return value

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

Description

This can be used, for example, to hide intermediary steps in a complicated calculation.

Examples

worksheet.of_set_row_hidden( 0, true )    	 // Hide first row