Release 1.6.1
29 June 2005		 Developer's reference PB2XLS for PowerBuilder
Reference > N_XLS_FORMAT > of_set_merge

of_set_merge() method

Align text across two or more adjacent cells.

Syntax

format.of_set_merge ( )

Return value

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

Description

This only allows simple Excel5 style horizontal merging which Excel refers to as "center across selection". The of_merge_write() method allows you to do Excel97+ style formatting where the cells can contain other types of alignment in addition to the merging.

Examples 

format.of_set_merge ( )
worksheet.of_write (0, 0, 'Merged cells', format )
worksheet.of_write (0, 1, format )
© 2003-2005 Desta, Ltd. All rights reserved. SupportDesk