SpreadsheetGear Namespace > IRange Interface : PageBreak Property (IRange) |
Adds or removes manual page breaks for a range.
[Visual Basic]
Overridable WriteOnly Property PageBreak
[C#]
virtual void PageBreak {set;}
[C++]
__property virtual void set_PageBreak(
void value
);
[C++/CLI]
virtual property void PageBreak {
void set (void value);
}
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.
[C#]
void SetPageBreak(SpreadsheetGear.IWorksheet worksheet, int row, int col)
{
worksheet.Cells[row, col].PageBreak = SpreadsheetGear.PageBreak.Manual;
}
[Visual Basic]
Sub SetPageBreak(worksheet As SpreadsheetGear.IWorksheet, row As Integer, col As Integer)
worksheet.Cells(row, col).PageBreak = SpreadsheetGear.PageBreak.Manual
End Sub 'SetPageBreak
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
IRange Interface | IRange Members
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.