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 98, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0. SpreadsheetGear for .NET 2006 requires the Microsoft .NET Framework 2.0.

See Also