SpreadsheetGear
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

Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.

See Also

Copyright © 2003-2009 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.