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 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
