在表格使用中经常需要对特定条件下的单元格进行文本样式、颜色上的特殊显示,如:如果B列数字大于A列,使相应的B列的单元格显示红色。对于单元格条件格式化,Spread Studio for .NET为开发人员提供了便捷的方法,可以通过SetConditionalFormatting方法来设置格式化条件,具体如下:
关键代码:
private void SetRuler()
{
UnaryComparisonConditionalFormattingRule unaryComparisonConditionalFormattingRule1 = new UnaryComparisonConditionalFormattingRule(UnaryComparisonOperator.GreaterThan, "=A1", true);
unaryComparisonConditionalFormattingRule1.BackColor = Color.Red;
unaryComparisonConditionalFormattingRule1.Priority = 8;
fpSpread1.ActiveSheet.SetConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] {
new FarPoint.Win.Spread.Model.CellRange(0, 1, 500, 1)}, new FarPoint.Win.Spread.IConditionalFormattingRule[] {
unaryComparisonConditionalFormattingRule1});
}