Spread for Windows Forms快速入门(11)---数据筛选

fpSpread1.ActiveSheet.ColumnHeaderVisible = true;

FarPoint.Win.Spread.HideRowFilter hideRowFilter = new FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet);

fpSpread1.ActiveSheet.Columns[1,3].AllowAutoFilter = true;

行筛选指示器

描述

未进行行筛选的表头单元格的外观；这种情况通常出现在无筛选时，或行筛选未生效时。

可以进行行筛选，但是没有被筛除的行时的表头单元格的外观；这种情况通常发生在全部内容满足筛选条件的时候。

可以进行行筛选，并且进行了一部分筛选的表头单元格的外观；这种情况通常发生在根据行内容 进行了一部分行筛选时。

筛选器列表项

描述

（全部）

不论内容,包含或允许在此列的所有行

[内容]

仅包含或允许此列中有特定的单元格内容的行

（空白）

仅包含或允许此列中空白（空单元格）的行

（非空）

仅包含或允许此列中非空的行（非空的单元格），换言之，包含内容的任何单元格。

// 定义应用于筛除行的样式.

FarPoint.Win.Spread.NamedStyle inStyle = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle outStyle = new FarPoint.Win.Spread.NamedStyle();

inStyle.BackColor = Color.LightCyan;

inStyle.ForeColor = Color.DarkRed;

outStyle.BackColor = Color.LemonChiffon;

outStyle.ForeColor = Color.Green;

// 为第一列创建新的筛选设置(使用默认设置).

FarPoint.Win.Spread.FilterColumnDefinition fcdef = new FarPoint.Win.Spread.FilterColumnDefinition(0);

// 创建一个StyleRowFilter对象(样式筛选器), 并添加到上述筛选设置中.

FarPoint.Win.Spread.StyleRowFilter styleFilter = new FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet, inStyle, outStyle);

styleFilter.AddColumn(fcdef);

// 为表单设置已创建的行筛选器对象。

fpSpread1.ActiveSheet.RowFilter = styleFilter;

// 以文本对数据区域进行筛选。

fpSpread1.ActiveSheet.DefaultStyle.CellType = new FarPoint.Win.Spread.CellType.TextCellType();

fpSpread1.ActiveSheet.SetText(0, 0, "Fender");

fpSpread1.ActiveSheet.SetText(1, 0, "Gibson");

fpSpread1.ActiveSheet.SetText(2, 0, "Fender");

fpSpread1.ActiveSheet.SetText(3, 0, "Ibanez");

fpSpread1.ActiveSheet.SetText(4, 0, "Gibson");

fpSpread1.ActiveSheet.SetText(5, 0, "Yamaha");

fpSpread1.ActiveSheet.SetText(0, 1, "AST-100 DMC");

fpSpread1.ActiveSheet.SetText(1, 1, "Les Paul Standard Double Cut Plus");

fpSpread1.ActiveSheet.SetText(2, 1, "ST58-70TX");

fpSpread1.ActiveSheet.SetText(3, 1, "AGS83B");

fpSpread1.ActiveSheet.SetText(4, 1, "Les Paul Supreme");

fpSpread1.ActiveSheet.SetColumnWidth(0, 90);

fpSpread1.ActiveSheet.SetColumnWidth(1, 210);

// Declare the row filter and column definitions.

FarPoint.Win.Spread.FilterColumnDefinitionCollection fcdc = new FarPoint.Win.Spread.FilterColumnDefinitionCollection();

FarPoint.Win.Spread.FilterColumnDefinition fcd1 = new FarPoint.Win.Spread.FilterColumnDefinition(2);

FarPoint.Win.Spread.FilterColumnDefinition fcd2 = new FarPoint.Win.Spread.FilterColumnDefinition(3);

FarPoint.Win.Spread.FilterColumnDefinition fcd3 = new FarPoint.Win.Spread.FilterColumnDefinition(1);

// Add column filter definitions to a collection.

fcdc.Add(fcd1);

fcdc.Add(fcd2);

fcdc.Add(fcd3);

FarPoint.Win.Spread.NamedStyle inStyle = new FarPoint.Win.Spread.NamedStyle();

FarPoint.Win.Spread.NamedStyle outStyle = new FarPoint.Win.Spread.NamedStyle();

inStyle.BackColor = Color.Yellow;

outStyle.BackColor = Color.Aquamarine;

// Apply styles and column filter definitions to the row filter.

FarPoint.Win.Spread.StyleRowFilter rowFilter = new FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet,inStyle,outStyle);

// Apply the column definition to the filter.

rowFilter.ColumnDefinitions = fcdc;

// Apply the row filter to the sheet.

fpSpread1.ActiveSheet.RowFilter = rowFilter;