29 June 2005
| Release 1.6.1 29 June 2005 |
Developer's reference |
|
| Reference > N_XLS_WORKSHEET > of_thaw_panes |
of_thaw_panes() method
Divide a worksheet into horizontal or vertical regions known as panes. This method is different from the of_freeze_panes() method in that the splits between the panes will be visible to the user and each pane will have its own scroll bars.
Syntax
| worksheet.of_thaw_panes (x, y, top_row, left_col) |
Parameters
| Y | The double whose value is the vertical position of the split |
| X | The double whose value is the horizontal position of the split |
| Top_row | The unsigned integer whose value is the top-most visible row in the scrolling region of the panes |
| Left_row | The unsigned integer whose value is the left-most visible column in the scrolling region of the panes |
Return value
Integer. Returns 1 if it succeeds and -1 if an error occurs.
Description
The units for Y and X are the same as those used by Excel to specify row height and column width. However, the vertical and horizontal units are different from each other. Therefore you must specify the Y and X parameters in terms of the row heights and column widths that you have set or the default values which are 12.75 for a row and 8.43 for a column.
You can set one of the Y and X parameters as zero if you do not want either a vertical or horizontal split.
Examples
worksheet.of_thaw_panes ( 0, 8.43, 0, 1) //First column worksheet.of_thaw_panes ( 12.75, 0, 1, 0 ) //First row worksheet.of_thaw_panes( 12.75, 8.43, 1, 1 ) // First row and column
| © 2003-2005 Desta, Ltd. All rights reserved. | SupportDesk |