PageBreak Property (IRange)

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

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

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

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