FarPoint.Win.Spread
ColStart Property
See Also  Example
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > PrintInfo Class : ColStart Property


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

Syntax

Visual Basic (Declaration) 
Public Property ColStart As Integer
Visual Basic (Usage)Copy Code
Dim instance As PrintInfo
Dim value As Integer
 
instance.ColStart = value
 
value = instance.ColStart
C# 
public int ColStart {get; set;}

Return Value

Integer index of the starting column

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);
Visual BasicCopy 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)

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.

See Also