Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / GetRowPageBreaks Method / GetRowPageBreaks(Int32) Method
Sheet index for which to return row page breaks
Example


In This Topic
    GetRowPageBreaks(Int32) Method
    In This Topic
    Gets the row page breaks for the specified sheet under the current printing conditions.
    Syntax
    'Declaration
     
    Public Overloads Function GetRowPageBreaks( _
       ByVal sheet As Integer _
    ) As Integer()
    'Usage
     
    Dim instance As FpSpread
    Dim sheet As Integer
    Dim value() As Integer
     
    value = instance.GetRowPageBreaks(sheet)
    public int[] GetRowPageBreaks( 
       int sheet
    )

    Parameters

    sheet
    Sheet index for which to return row page breaks

    Return Value

    Integer array containing the indexes of rows for which page breaks occur
    Example
    This example gets the row numbers for the row page breaks.
    // Form Load
    FarPoint.Win.Spread.PrintInfo pi = new FarPoint.Win.Spread.PrintInfo();
    pi.UseMax =false;
    fpSpread1.Sheets[0].PrintInfo=pi;
    fpSpread1.Sheets[0].SetRowPageBreak(5,true);
    // Button Click
    int[] i;
    i = fpSpread1.GetRowPageBreaks(0);
    foreach (object o in i)
    {
    listBox1.Items.Add(o);
    }
    
    ' Code in form load event
    Dim pi As New FarPoint.Win.Spread.PrintInfo()
    pi.UseMax = False
    FpSpread1.Sheets(0).PrintInfo = pi
    FpSpread1.Sheets(0).SetRowPageBreak(5, True)
    ' Code in button click event
    Dim i() As Integer
    Dim o As Object
    i = FpSpread1.GetRowPageBreaks(0)
    For Each o In i
    ListBox1.Items.Add(o)
    Next
    
    See Also