SpreadsheetGear The Performance Spreadsheet Component Company 
PageBreak Property
See Also  Example
SpreadsheetGear Namespace > IRange Interface : PageBreak Property
Adds or removes manual page breaks for a range.

Syntax

C# 
virtual void PageBreak {set;}

Example

C#Copy Code
void SetPageBreak(SpreadsheetGear.IWorksheet worksheet, int row, int col) 
{ 
    worksheet.Cells[row, col].PageBreak = SpreadsheetGear.PageBreak.Manual; 
} 
    
Visual BasicCopy Code
Sub SetPageBreak(worksheet As SpreadsheetGear.IWorksheet, row As Integer, col As Integer)
   worksheet.Cells(row, col).PageBreak = SpreadsheetGear.PageBreak.Manual
End Sub 'SetPageBreak

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.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also