Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_set_column_hidden

of_set_column_hidden() method

Set the option to hide a column.

Syntax

worksheet.of_set_column_hidden ( column, hidden )

Parameters

columnThe long whose value is the number of column
hiddenA boolean value that controls whether column 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_column_hidden( 0, true )    	 // Hide first column