threeTrafficLightsUnrimmed改颜色

Lynn.Dou

本帖最后由 liujun 于 2021-8-31 18:14 编辑

image.png423607787.png

请问红绿灯threeTrafficLightsUnrimmed的3个颜色能改吗？比如把红灯、黄灯、绿灯改成蓝色、绿色、紫色？

//红绿灯
let range; // Type: Range
let rangeArr = [];
for(let i = 0; i < 13; i++){
range = new GC.Spread.Sheets.Range(2, 3+3*i, 21, 1);
rangeArr.push(range);
}
var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();
iconSetRule.ranges( rangeArr );
iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeTrafficLightsUnrimmed);
var iconCriteria = iconSetRule.iconCriteria();
iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, -0.02);
iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 0);
iconSetRule.reverseIconOrder(false);
iconSetRule.showIconOnly(false);
sheet.conditionalFormats.addRule(iconSetRule);<span class="ne-text">：</span>