See Also

IRange Interface  | IRange Members

Requirements

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

Language

Visual Basic

C#

C++

C++/CLI

Show All

See Also Languages SpreadsheetGear The Performance Spreadsheet Component Company 

PageBreak Property

SpreadsheetGear Namespace > IRange Interface : PageBreak Property (IRange)

Adds or removes manual page breaks for a range.

[Visual Basic]
Overridable WriteOnly Property PageBreak
[C#]
virtual void PageBreak {set;}
[C++]
__property virtual void set_PageBreak(    void value );
[C++/CLI]
virtual property void PageBreak {    void set (void 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

[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

Requirements

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

See Also

IRange Interface  | IRange Members

 

 


See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.