Spread Studio for .NET表格控件如何实现单元格条件格式化

作者:控件中国网   出处:控件中国网   2015-08-17 14:59:50   阅读:12

在表格使用中经常需要对特定条件下的单元格进行文本样式、颜色上的特殊显示,如:如果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});
        }
 

Copyright© 2006-2015 ComponentCN.com all rights reserved.重庆磐岩科技有限公司(控件中国网) 版权所有 渝ICP备12000264号 法律顾问:元炳律师事务所
客服软件
live chat