GrapeCity.Documents.Excel.IVPageBreak

IVPageBreak Interface

Represents a vertical page break.

A vertical page break defines where printed content is split into the next page across columns. You can obtain an IVPageBreak from VPageBreaks, inspect its location with Location, determine whether it spans the full sheet or only the print area with Extent, or remove it with Delete().

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IVPageBreak

Public Interface IVPageBreak

Examples

worksheet.Range["A1:F10"].Value = "Data";
IVPageBreaks pageBreaks = worksheet.VPageBreaks;
pageBreaks.Add(worksheet.Range["D1"]);
IVPageBreak pageBreak = pageBreaks[0];
IRange location = pageBreak.Location;
PageBreakExtent extent = pageBreak.Extent;

Properties

Name	Description
Extent	Returns the extent of the specified page break: the entire worksheet or only the print area. The returned value indicates whether the vertical page break applies to the entire worksheet or only within the print area.
Location	Returns the range that defines the page-break location. Horizontal page breaks are aligned with the top edge of the location range; vertical page breaks are aligned with the left edge of the location range.

Name

Description

Extent

Returns the extent of the specified page break: the entire worksheet or only the print area.

The returned value indicates whether the vertical page break applies to the entire worksheet or only within the print area.

Location

Returns the range that defines the page-break location.

Horizontal page breaks are aligned with the top edge of the location range; vertical page breaks are aligned with the left edge of the location range.

Methods

Name	Description
Delete()	Deletes this vertical page break. Use this method to remove a page break that was previously added to the worksheet's VPageBreaks collection.

Name

Description

Delete()

Deletes this vertical page break.

Use this method to remove a page break that was previously added to the worksheet's VPageBreaks collection.