Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / GetColumnPageBreaks Method / GetColumnPageBreaks(Int32) Method
Index of sheet for which to return column page breaks
Example


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

    Parameters

    sheet
    Index of sheet for which to return column page breaks

    Return Value

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