Spread Studio 表格控件数据可视化：条件格式化

Spread 表格控件提供了完整功能和可视化元素，包括数据条、颜色标尺、图标集等。这将帮助您以可见方式对与数据相关的问题作出回应，同时高亮感兴趣的单元格或区域，强调特殊数据以及将数据可视化展现。条件格式可以根据设置的条件或标准改变单元格或区域的外观样式。当条件为true，单元格或区域按照条件格式化；当条件为false，单元格或区域不会根据条件格式化。

例如，您希望根据单元格的值来改变单元格背景色。如果单元格值小于100，那么背景色为红色。格式化条件为“小于100”其中包含了“小于”和数值条件“100”，格式化添加可以是一个常量或表达式。一些条件格式声明可能包含两个限制条件：例如，如果需要设置当单元格在0至100之间时改变背景色。对于这个用例，格式化条件为“介于”，第一个条件为0，第二个条件为100。

如果两个格式化条件同时设置给同一个单元格，那么第二个格式化条件启作用。

使用代码：

首先定义样式，然后使用样式创建条件格式，设置给单元格。

示例：

示例代码以单元格数值为依据设置条件格式。可以在 B2 单元格中输入数值”77”查看效果。

  1: FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle();

  2: FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle();

  3: FarPoint.Win.Spread.NamedStyle styleMild = new FarPoint.Win.Spread.NamedStyle();

  4: FarPoint.Win.Spread.NamedStyle styleWarm = new FarPoint.Win.Spread.NamedStyle();

  5: FarPoint.Win.Spread.NamedStyle styleHot = new FarPoint.Win.Spread.NamedStyle();

  6:  

  7: 

  8: styleCold.BackColor = Color.Blue;

  9: styleCold.ForeColor = Color.White;

 10: styleCool.BackColor = Color.Cyan;

 11: styleMild.BackColor = Color.Lime;

 12: styleWarm.BackColor = Color.Yellow;

 13: styleHot.BackColor = Color.Red;

 14:  

 15: 

 16: for (int col = 0; col < 6; col++)

 17: {

 18:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThanOrEqualTo, "32");

 19:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55");

 20:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleMild, FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75");

 21:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleWarm, FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85");

 22:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleHot, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85");

 23: }

 24: 

 25: 

VB.NET:

  1: Dim styleCold As New FarPoint.Win.Spread.NamedStyle()

  2: Dim styleCool As New FarPoint.Win.Spread.NamedStyle()

  3: Dim styleMild As New FarPoint.Win.Spread.NamedStyle()

  4: Dim styleWarm As New FarPoint.Win.Spread.NamedStyle()

  5: Dim styleHot As New FarPoint.Win.Spread.NamedStyle()

  6:  

  7: 

  8: styleCold.BackColor = Color.Blue

  9: styleCold.ForeColor = Color.White

 10: styleCool.BackColor = Color.Cyan

 11: styleMild.BackColor = Color.Lime

 12: styleWarm.BackColor = Color.Yellow

 13: styleHot.BackColor = Color.Red

 14:  

 15: 

 16: For col As Integer = 0 To 5

 17:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThanOrEqualTo, "32")

 18:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55")

 19:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleMild, FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75")

 20:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleWarm, FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85")

 21:   fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleHot, FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85")

 22: Next col

使用 Spread 设计器:

1.选择目标格式化单元格。

2.在菜单项“首页”的选项中，点击条件格式化。

3.点击高亮单元格规则

4.设置条件格式化条件。

5.在“文件”菜单中选择“应用并退出”来应用您的变更到组件中并退出设计器。

效果图：