Spread Windows Forms 7.0 Product Documentation
GetRowPageBreaks(Int32,Boolean) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > GetRowPageBreaks Method : GetRowPageBreaks(Int32,Boolean) Method


sheet
Index of sheet for which to return row page breaks
reCalc
Whether to recalculate the page break

Glossary Item Box

Gets the row page breaks for the specified sheet under the current printing conditions with the option to recalculate.

Syntax

Visual Basic (Declaration) 
Public Overloads Function GetRowPageBreaks( _
   ByVal sheet As Integer, _
   ByVal reCalc As Boolean _
) As Integer()
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)
C# 
public int[] GetRowPageBreaks( 
   int sheet,
   bool 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

The reCalc parameter is for optimization; if the GetColumnPageBreaks method is called before this method, set this parameter to false.

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

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