| FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > PrintInfo Class : ColEnd Property |
'Declaration Public Property ColEnd As Integer
'Usage Dim instance As PrintInfo Dim value As Integer instance.ColEnd = value value = instance.ColEnd
public int ColEnd {get; set;}
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.
// 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)
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
PrintInfo Class
PrintInfo Members
ColStart Property
PrintType Property
RowEnd Property
RowStart Property