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) |
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 Basic | Copy 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