Spread Windows Forms 11.0 Product Documentation
GetColumnPageBreaks(Int32) Method
Example 


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
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

Reference

FpSpread Class
FpSpread Members
Overload List