Gets the row page breaks for the specified sheet under the current printing conditions with the option to recalculate.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As FpSpread
Dim sheet As Integer
Dim reCalc As Boolean
Dim value() As Integer
value = instance.GetRowPageBreaks(sheet, reCalc) |
Parameters
- sheet
- Index of sheet for which to return row page breaks
- reCalc
- Whether to recalculate the page break
Return Value
Integer array containing the indexes of rows for which page breaks occur
Remarks
Example
This example sets and gets row page breaks.
C# | Copy Code |
---|
// Add this code to 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);
// Add this code to a button click event
int []i;
i = fpSpread1.GetRowPageBreaks(0,true);
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).SetRowPageBreak(5, True)
'Code in button click event
Dim i() As Integer
Dim o As Object
i = FpSpread1.GetRowPageBreaks(0, True)
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