protected void Page_Load(object sender, EventArgs e)
{
if (this.IsPostBack) return;
FpSpread1.ActiveSheetView.RowCount = 10;
for (int i = 0; i < 10; i++)
{
FpSpread1.ActiveSheetView.SetValue(i, 0, i);
}
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(0, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences | FarPoint.Web.Spread.FilterListBehavior.Default);
FarPoint.Web.Spread.HideRowFilter hf = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.Sheets[0]);
hf.FilterFrozenRows = false;
hf.AddColumn(fcd);
FpSpread1.Sheets[0].RowFilter = hf;
FpSpread1.ActiveSheetView.FrozenRowCount = 3;
FpSpread1.ActiveSheetView.Rows[5].Visible = false;
}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.RowCount = 10
For i As Integer = 0 To 9
FpSpread1.ActiveSheetView.SetValue(i, 0, i)
Next
Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(0, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences Or FarPoint.Web.Spread.FilterListBehavior.[Default])
Dim hf As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.Sheets(0))
hf.FilterFrozenRows = False
hf.AddColumn(fcd)
FpSpread1.Sheets(0).RowFilter = hf
FpSpread1.ActiveSheetView.FrozenRowCount = 3
FpSpread1.ActiveSheetView.Rows(5).Visible = False
End Sub