SpreadsheetGear 2010
PageBreak Property
See Also  Example Send Feedback
SpreadsheetGear Namespace > IRange Interface : PageBreak Property

Adds or removes manual page breaks for a range.

Syntax

Visual Basic (Declaration) 
WriteOnly Property PageBreak As PageBreak
C# 
PageBreak 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

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.