Gets or sets the last column to print when printing a cell range.

Syntax

Visual Basic (Declaration)
Public Property ColEnd As Integer

Visual Basic (Usage)	Copy Code
Dim instance As PrintInfo Dim value As Integer instance.ColEnd = value value = instance.ColEnd

C#
public int ColEnd {get; set;}

Property Value

Integer index of the ending column

Remarks

If you have set the PrintType property to PrintType.CellRange, set the ColStart, ColEnd, RowStart, and RowEnd properties to specify the range of cells to print.

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

Example

This example shows how to specify that only part of the sheet prints.

C#	Copy Code
// 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);

Copy Code

// 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);

Visual Basic	Copy Code
' 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)

Visual Basic

Copy Code

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

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

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread Windows Forms 6.0 Product Documentation
ColEnd Property
See Also Example Support Options