SpreadsheetGear 2023
PageBreak Property (IRange)
Example 


SpreadsheetGear Namespace > IRange Interface : PageBreak Property
Adds or removes manual page breaks for a range.
Syntax
'Declaration
 
WriteOnly Property PageBreak As PageBreak
'Usage
 
Dim instance As IRange
 
instance.PageBreak = value
PageBreak PageBreak {set;}
Remarks

Set this property to PageBreak.Manual to add a manual page break, or PageBreak.None to remove a manual page break.

If the range represents entire rows, a page break is added or removed before the first row of the range.

If the range represents entire columns, a page break is added or removed before the first column of the range.

If the range represents neither entire rows nor entire columns, a page break is added or removed before the first row and first column of the range.

To remove all manual page breaks from a worksheet, set IWorksheet.Cells.PageBreak to PageBreak.None.

Example
void SetPageBreak(SpreadsheetGear.IWorksheet worksheet, int row, int col)
{
    worksheet.Cells[row, col].PageBreak = SpreadsheetGear.PageBreak.Manual;
}
Sub SetPageBreak(worksheet As SpreadsheetGear.IWorksheet, row As Integer, col As Integer)
   worksheet.Cells(row, col).PageBreak = SpreadsheetGear.PageBreak.Manual
End Sub 'SetPageBreak
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members