单元格值为0时能否显示空格

收藏

spread和数据表绑定后，为零的单元格能否显示为空白？

dexteryao · dexteryao

您可以用条件格式，数据为零 foreColor 设置为何背景色一样

FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 0);
unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
unary.Value = 0;
unary.ForeColor = Color.White;
FpSpread1.Sheets[0].ConditionalFormatting.Add(new FarPoint.Web.Spread.ConditionalFormatting(new CellRange(0, 0, 3, 3), unary));

复制代码

szpzr · szpzr

请指点一下！

szpzr · szpzr

color导入using System.Drawing;CellRange需导入命名空间吗？

dexteryao · dexteryao

引用下面命名空间
using System.Drawing;
using FarPoint.Web.Spread.Model;

szpzr · szpzr

谢谢dexteryao ！

dexteryao · dexteryao

		自动登录	找回密码
密码			立即注册

6 个回复