Spread Windows Forms 6.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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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