Spread Studio for .NET表格控件是一个综合性的、用于微软.NET平台的Windows Forms、 ASP.NET、WPF、Silverlight和WinRT应用程序开发的表格控件。它集成了丰富的表格功能、工作表功能，并可以与多种数据源进行绑定。一个Spread控件可以处理多达20亿个工作表，每个工作表可以有20亿行和20亿列，并且支持跨工作表的数据引用和跨工作表的公式引用。Spread控件已经被业界公认为功能最为强大的表格控件。Spread在中国也有了超过10年的使用历史，得到了许多软件开发人员的认可。
Spread加强了中文本地化支持、我们为中文环境添加了本地化资源。Spread控件将在Visual Studio中显示中文，包括设计器界面以及设计时界面。中文菜单和提示消息也将在运行时显示。同时，Spread与Excel文件的兼容性和导入导出性能都得到了进一步的提升。
Spread 表格控件提供了完整功能和可视化元素，包括数据条、颜色标尺、图标集等。这将帮助您以可见方式展示数据，同时高亮感兴趣的单元格或区域，强调特殊数据以及将数据可视化展现。条件格式可以根据设置的条件或标准改变单元格或区域的外观样式。当条件为true，单元格或区域按照条件格式化；当条件为false，单元格或区域不会根据条件格式化。例如，您希望根据单元格的值来改变单元格背景色。如果单元格值小于100，那么背景色为红色。格式化条件为“小于100”其中包含了“小于”和数值条件“100”，格式化条件可以是一个常量或表达式。
下面是实现条件格式化的代码：
C#：
FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle styleMild = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle styleWarm = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle styleHot = new FarPoint.Win.Spread.NamedStyle();
styleCold.BackColor = Color.Blue;
styleCold.ForeColor = Color.White;
styleCool.BackColor = Color.Cyan;
styleMild.BackColor = Color.Lime;
styleWarm.BackColor = Color.Yellow;
styleHot.BackColor = Color.Red;
for (int col = 0; col < 6; col++)
{
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCold,
FarPoint.Win.Spread.ComparisonOperator.LessThanOrEqualTo, "32");
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCool,
FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55");
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleMild,
FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75");
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleWarm,
FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85");
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleHot,
FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85");
}
[Visual Basic]
Dim styleCold As New FarPoint.Win.Spread.NamedStyle()
Dim styleCool As New FarPoint.Win.Spread.NamedStyle()
Dim styleMild As New FarPoint.Win.Spread.NamedStyle()
Dim styleWarm As New FarPoint.Win.Spread.NamedStyle()
Dim styleHot As New FarPoint.Win.Spread.NamedStyle()
styleCold.BackColor = Color.Blue
styleCold.ForeColor = Color.White
styleCool.BackColor = Color.Cyan
styleMild.BackColor = Color.Lime
styleWarm.BackColor = Color.Yellow
styleHot.BackColor = Color.Red
For col As Integer = 0 To 5
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCold,
FarPoint.Win.Spread.ComparisonOperator.LessThanOrEqualTo, "32")
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleCool,
FarPoint.Win.Spread.ComparisonOperator.Between, "32", "55")
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleMild,
FarPoint.Win.Spread.ComparisonOperator.Between, "55", "75")
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleWarm,
FarPoint.Win.Spread.ComparisonOperator.Between, "75", "85")
fpSpread1.ActiveSheet.SetConditionalFormat(0, col, styleHot,
FarPoint.Win.Spread.ComparisonOperator.GreaterThan, "85")
Next col
使用 Spread 设计器实现条件格式化