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