Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / PrintInfo Class / RowStart Property
Example


In This Topic
    RowStart Property
    In This Topic
    Gets or sets the first row to print when printing a cell range.
    Syntax
    'Declaration
     
    Public Property RowStart As Integer
    'Usage
     
    Dim instance As PrintInfo
    Dim value As Integer
     
    instance.RowStart = value
     
    value = instance.RowStart
    public int RowStart {get; set;}

    Property Value

    Integer row index
    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.
    // 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