v15 电子表格条件格式

收藏

条件格式图标集具体如何设置有详细的文档吗，看指南里的示例好像没法满足需求，
想要实现等于0 横向大于0 向上小于0 向下的规则该如何写代码设置呢
3SKN0O`O%V}O7BR`5N(P7LK.png928910217.png

Lynn.Dou · Lynn.Dou

您好，
参考以下代码：

sheet.setValue(0,0,0);
sheet.setValue(1,0,0);
sheet.setValue(2,0,3);
sheet.setValue(3,0,-1);
var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();
iconSetRule.ranges([new GC.Spread.Sheets.Range(0, 0, 4, 1)]);
iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored);
var icons = iconSetRule.icons();
icons[0] = {iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored, iconIndex: 0 };
icons[1] = {iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored, iconIndex: 1 };
icons[2] = {iconSetType: GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored, iconIndex: 2 };
var iconCriteria = iconSetRule.iconCriteria();
iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 0);
iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(false, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 0);
sheet.conditionalFormats.addRule(iconSetRule);

复制代码

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

[已处理] v15 电子表格条件格式