FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > GetRowPageBreaks Method : GetRowPageBreaks(Int32,Boolean) Method |
'Declaration Public Overloads Function GetRowPageBreaks( _ ByVal sheet As Integer, _ ByVal reCalc As Boolean _ ) As Integer()
The reCalc parameter is for optimization; if the GetColumnPageBreaks method is called before this method, set this parameter to false.
// 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); }
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8