请问如何实现excel那样的筛选功能，这个是重点

收藏

首先我们开发的web应用。现在需要实现像excel那样可以随意筛选数据，如何实现。

ZenosZeng · ZenosZeng

Spread中可以通过以下代码来实现过滤操作：

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;

复制代码

hn007 · hn007

好的，谢谢，但是有个问题，符合条件的筛选出来了，带了背景色，能不能把不符合条件控制不出来呢？就如excel一样。

ZenosZeng · ZenosZeng

hn007 你好

该功能和Excel有些区别，Spread中是通过背景色等样式来区分过滤的数据。

hn007 · hn007

貌似可以通过HideRowFilter实现吧

ZenosZeng · ZenosZeng

貌似可以通过HideRowFilter实现吧
hn007 发表于 2013-3-7 13:54:00

多谢hn007提醒，代码如下：

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
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.FilterListBehavior.Default);
FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition(3);
FarPoint.Web.Spread.HideRowFilter hf = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.Sheets[0]);
hf.AddColumn(fcd);
hf.AddColumn(fcd1);
hf.AddColumn(fcd2);
FpSpread1.Sheets[0].RowFilter = hf;
}
}

复制代码

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

[已处理] 请问如何实现excel那样的筛选功能，这个是重点