Developer's reference PB2XLS for PowerBuilder

Reference > N_XLS_WORKSHEET > of_set_margin_tb

of_set_margin_tb() method

Set the top and bottom worksheet margins to the same value.

Syntax

worksheet.of_set_margin_tb ( margin )

Parameters

margina double whose value is the margin in inches

Return value

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

Description

This method take a distance in inches as a parameter.
Note: 1 inch = 25.4mm.
The default top and bottom margin is 1.00 inch.

Examples

worksheet.of_set_margin_tb ( 2.00 )	// set the top and bottom margin 2 inch