Spread Windows Forms 9.0 Product Documentation
GetRowPageBreaks(Int32) Method
Example 


Sheet index for which to return row page breaks
Gets the row page breaks for the specified sheet under the current printing conditions.
Syntax
'Declaration
 
Public Overloads Function GetRowPageBreaks( _
   ByVal sheet As Integer _
) As Integer()
'Usage
 
Dim instance As FpSpread
Dim sheet As Integer
Dim value() As Integer
 
value = instance.GetRowPageBreaks(sheet)
public int[] GetRowPageBreaks( 
   int sheet
)

Parameters

sheet
Sheet index for which to return row page breaks

Return Value

Integer array containing the indexes of rows for which page breaks occur
Example
This example gets the row numbers for the row page breaks.
// Form Load
FarPoint.Win.Spread.PrintInfo pi = new FarPoint.Win.Spread.PrintInfo();
pi.UseMax =false;
fpSpread1.Sheets[0].PrintInfo=pi;
fpSpread1.Sheets[0].SetRowPageBreak(5,true);
// Button Click
int[] i;
i = fpSpread1.GetRowPageBreaks(0);
foreach (object o in i)
{
listBox1.Items.Add(o);
}
' Code in form load event
Dim pi As New FarPoint.Win.Spread.PrintInfo()
pi.UseMax = False
FpSpread1.Sheets(0).PrintInfo = pi
FpSpread1.Sheets(0).SetRowPageBreak(5, True)
' Code in button click event
Dim i() As Integer
Dim o As Object
i = FpSpread1.GetRowPageBreaks(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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.