fpspread能否把标题行做成下拉框的形式？

收藏

fpspread能否把标题行做成下拉框的形式？实现类似于excel 的筛选功能。

dexteryao · dexteryao

有Filter的功能

FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle();
FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle();
instyle.BackColor = Color.Yellow;
outstyle.BackColor = Color.Aquamarine;
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences | FarPoint.Web.Spread.FilterListBehavior.Default);
FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2);
FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition();
FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets[0], instyle, outstyle);
sf.AddColumn(fcd);
sf.AddColumn(fcd1);
sf.AddColumn(fcd2);
FpSpread1.Sheets[0].RowFilter = sf;

复制代码

Jinkrin · Jinkrin

dexteryao 发表于 2016-7-6 11:26
有Filter的功能

非常感谢，但我是要在用VB的C/S程序里面实现，怎么做？

dexteryao · dexteryao

你去文档里搜索下filter，会有相关内容，C#和VB代码都有。
文档在 C:\Program Files (x86)\GrapeCity\Spread Studio 9\Docs\ASP.NET\FarPoint.Web.Spread.9.0.chm

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If (IsPostBack) Then
Return
End If
For i As Integer = 0 To FpSpread1.ActiveSheetView.RowCount - 1
For j As Integer = 0 To FpSpread1.ActiveSheetView.ColumnCount - 1
FpSpread1.ActiveSheetView.Cells(i, j).Value = i + j
Next
Next
Dim fbc As New FarPoint.Web.Spread.FilterBarCellType()
fbc.MenuType = FarPoint.Web.Spread.FilterMenuType.Auto
FpSpread1.ActiveSheetView.FilterBar.DefaultStyle.CellType = fbc
FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
End Sub

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] fpspread能否把标题行做成下拉框的形式？