PageBreak Property (IRange)

Adds or removes manual page breaks for a range.

Syntax

Visual Basic
C#

'Declaration
 
WriteOnly Property PageBreak As PageBreak

'Usage
 
Dim instance As IRange
 
instance.PageBreak = value

PageBreak PageBreak {set;}

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;
}

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

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

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-2023 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