SpreadsheetGear 2017
PageBreak Property (IRange)
Example 






SpreadsheetGear Namespace > IRange Interface : PageBreak Property
Adds or removes manual page breaks for a range.
Syntax
'Declaration
 

WriteOnly Property PageBreak As PageBreak
'Usage
 

Dim instance As IRange
 
instance.PageBreak = value
PageBreak PageBreak {set;}
write-only property PageBreak: PageBreak; 
function set PageBreak : PageBreak
__property void set_PageBreak( 
   PageBreak value
);
property PageBreak PageBreak {
   void set (    PageBreak value);
}
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.

Example
void SetPageBreak(SpreadsheetGear.IWorksheet worksheet, int row, int col)
{
    worksheet.Cells[row, col].PageBreak = SpreadsheetGear.PageBreak.Manual;
}
Sub SetPageBreak(worksheet As SpreadsheetGear.IWorksheet, row As Integer, col As Integer)
   worksheet.Cells(row, col).PageBreak = SpreadsheetGear.PageBreak.Manual
End Sub 'SetPageBreak
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members

 

 

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

Copyright © 2003-2020 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Send Feedback