Spread Windows Forms 11.0 Product Documentation
PageEnd Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > PrintInfo Class : PageEnd Property
Gets or sets the last page to print when printing a page range.
Syntax
'Declaration
 
Public Property PageEnd As Integer
'Usage
 
Dim instance As PrintInfo
Dim value As Integer
 
instance.PageEnd = value
 
value = instance.PageEnd
public int PageEnd {get; set;}

Property Value

Integer number of the ending page
Remarks

When you set the PrintType property to PrintType.PageRange, set the PageStart and PageEnd properties to specify the range of pages to print.

This property does not have an effect unless the PrintType property is set to PrintType.PageRange.

Example
This example shows how to specify that only part of the sheet prints.
// Typically, not all of these settings are used together but are included here for illustration purposes

// Create the printer settings object
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo(); 

// Allow printing of only 20 columns and 20 rows of cells
printset.ColStart = 1;
printset.ColEnd = 20;
printset.RowStart = 1;
printset.RowEnd = 20;
printset.PrintType = FarPoint.Win.Spread.PrintType.CellRange;

// Allow printing of only five pages
printset.PageStart = 1;
printset.PageEnd = 5;

// Allow printing of the cell notes together at the end
printset.PrintNotes = FarPoint.Win.Spread.PrintNotes.AtEnd;

// Allow printing of the shapes
printset.PrintShapes = true;

// Allow printing of only rows and columns up to the last ones with data 
printset.UseMax = True;

// Assign the printer settings to the sheet and print it
fpSpread1.Sheets[0].PrintInfo = printset; 
fpSpread1.PrintSheet(0);
' Typically, not all of these settings are used together but are included here for illustration purposes

' Create the printer settings object
Dim printset As New FarPoint.Win.Spread.PrintInfo

' Allow printing of only 20 columns and 20 rows of cells
printset.ColEnd = 20
printset.ColStart = 1
printset.RowStart = 1
printset.RowEnd = 20
printset.PrintType = FarPoint.Win.Spread.PrintType.CellRange

' Allow printing of only five pages
printset.PageStart = 1
printset.PageEnd = 5

' Allow printing of the cell notes together at the end
printset.PrintNotes = FarPoint.Win.Spread.PrintNotes.AtEnd

' Allow printing of the shapes
printset.PrintShapes = True

' Allow printing of only rows and columns up to the last ones with data 
printset.UseMax = true

' Assign the printer settings to the sheet and print it
FpSpread1.Sheets(0).PrintInfo = printset
FpSpread1.PrintSheet(0)
See Also

Reference

PrintInfo Class
PrintInfo Members
PageStart Property
PrintType Property

User-Task Documentation

Printing Particular Pages