FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > FpSpread クラス > GetRowPageBreaks メソッド : GetRowPageBreaks(Int32,Boolean) メソッド |
'Declaration Public Overloads Function GetRowPageBreaks( _ ByVal sheet As Integer, _ ByVal reCalc As Boolean _ ) As Integer()
reCalcは最適化のためのパラメータです。このメソッドの前にGetColumnPageBreaksメソッドが呼び出される場合は、このパラメータを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