Spread Windows Forms 7.0 Product Documentation
GetColumnPageBreaks(Int32) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > GetColumnPageBreaks Method : GetColumnPageBreaks(Int32) Method


sheet
Index of sheet for which to return column page breaks

Glossary Item Box

Gets the column page breaks for the specified sheet under the current printing conditions.

Syntax

Visual Basic (Declaration) 
Public Overloads Function GetColumnPageBreaks( _
   ByVal sheet As Integer _
) As Integer()
Visual Basic (Usage)Copy Code
Dim instance As FpSpread
Dim sheet As Integer
Dim value() As Integer
 
value = instance.GetColumnPageBreaks(sheet)
C# 
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.
C#Copy Code
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); 
    } 

Visual BasicCopy Code
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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.