PowerTools SPREAD for ASP.NET 8.0J
LoadOffsetFromBottom プロパティ

この位置までスクロールした後にSpreadに次の行セットがロードされる、ビュー内の(一番下の行からの)行インデックスを取得または設定します。
構文
'Declaration
 
Public Property LoadOffsetFromBottom As Integer
public int LoadOffsetFromBottom {get; set;}
次のサンプルコードは、LoadOffsetFromBottomプロパティを設定します。
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 メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.