ColPageBreak Property

Applies To

fpSpread control

Description

Sets or returns whether a page break occurs at the specified column when printing the sheet. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetColPageBreak( );
void CSpreadSheet::SetColPageBreak(BOOL value);

Visual Basic

[form.]fpSpread.ColPageBreak[ = boolean%]

Remarks

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property. Set the Col property to specify the column number of the column before which the page break occurs before you set the ColPageBreak property.

Page breaks occur to the left of the specified column.

You can use the PrintNextPageBreakCol property to return the rows at which page breaks occur.

To specify a page break before a row in the sheet, set the Row and RowPageBreak properties.

Spread Designer

Choose the Sheet menu, then the Columns and Rows menu, select the Columns tab, and then choose the Column Page Break option box in the Settings-Current Column group box in the Column and Row Settings dialog box.

Before setting the check box, select the column where you want the page break to occur.

Data Type

Integer (Boolean)

DLL Correspondence

SSGetColPageBreak, SSSetColPageBreak functions