LoadOffsetFromBottom プロパティ

この位置までスクロールした後にSpreadに次の行セットがロードされる、ビュー内の（一番下の行からの）行インデックスを取得または設定します。

構文

Visual Basic
C#

'Declaration
 
Public Property LoadOffsetFromBottom As Integer

public int LoadOffsetFromBottom {get; set;}

例

次のサンプルコードは、LoadOffsetFromBottomプロパティを設定します。

C#
Visual Basic

protected void Page_Load(object sender, System.EventArgs e)
{
    FpSpread1.ActiveSheetView.RowCount = 100;
    FpSpread1.ActiveSheetView.PageSize = 200;
    FpSpread1.ActiveSheetView.AllowPage = false;

    FpSpread1.AllowLoadOnDemand = true;
    FpSpread1.LoadInitRowCount = 50;
    FpSpread1.LoadRowIncrement = 15;
    FpSpread1.ActiveSheetView.LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background;
    FpSpread1.ActiveSheetView.LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.OffsetBased;
    FpSpread1.ActiveSheetView.LoadOffsetFromBottom = 20;
    FpSpread1.ActiveSheetView.LoadOnDemandInterval = 1000; // this setting is meaningless in OffsetBased trigger mode
}

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    FpSpread1.ActiveSheetView.RowCount = 100
    FpSpread1.ActiveSheetView.PageSize = 200
    FpSpread1.ActiveSheetView.AllowPage = False

    FpSpread1.AllowLoadOnDemand = True
    FpSpread1.LoadInitRowCount = 50
    FpSpread1.LoadRowIncrement = 15
    FpSpread1.ActiveSheetView.LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background
    FpSpread1.ActiveSheetView.LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.OffsetBased
    FpSpread1.ActiveSheetView.LoadOffsetFromBottom = 20
    FpSpread1.ActiveSheetView.LoadOnDemandInterval = 1000 ' this setting is meaningless in OffsetBased trigger mode
End Sub

参照

SheetView クラス
 SheetView メンバ