10金币
版本 @grapecity/spread-sheets@13.0.5
在React 及Typescript中使用,想用条件格式使用自定义的Icon。
但是在定义的 gc.spread.sheets.d.ts中没有找到GC.Spread.Sheets.ConditionalFormatting.IconSetRule 下有getIcon方法,实际也没有执行。
打印geGC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcontIcon也是undefined。
Vscode编辑器 typescript环境也报错 typeof IconSetRule不存在 getIcon Property.
- console.log(GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon)
- GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon = function(
- iconSetType: any,
- iconIndex: any,
- ) {
- console.log(11122);
- if (
- iconSetType === GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored
- ) {
- if (iconIndex === 0) {
- return 'resources/img/splogo.png';
- } else if (iconIndex === 1) {
- return 'resources/img/Rating4.png';
- } else if (iconIndex === 2) {
- return 'resources/img/Box4.png';
- }
- }
- return 'icon';
- };
- var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule(
- GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored,
- [new GC.Spread.Sheets.Range(t.cell[0], t.cell[1], 1, 1)],
- );
- var iconCriteria = iconSetRule.iconCriteria();
- iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(
- true,
- GC.Spread.Sheets.ConditionalFormatting.IconValueType.number,
- 1,
- );
- iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(
- true,
- GC.Spread.Sheets.ConditionalFormatting.IconValueType.number,
- 10,
- );
- iconCriteria[2] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(
- true,
- GC.Spread.Sheets.ConditionalFormatting.IconValueType.number,
- 20,
- );
- iconSetRule.reverseIconOrder(false);
- iconSetRule.showIconOnly(false);
- sheet.conditionalFormats.addRule(iconSetRule);
复制代码
此处的需求是 该单元格为0时 展示一个自定义的icon,不为零时展示另一个不同的icon
|
|