getIcon メソッド

特定のiconSetTypeとiconIndexオブジェクトに基づいてアイコンを取得します。

シンタックス

Javascript (Usage)
Javascript (Specification)

var value; // Type: any

// パラメータ
var iconSetType; //タイプ： IconSetType
var iconIndex; //タイプ： number

value = GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon(iconSetType, iconIndex);

function getIcon( 
   iconSetType : IconSetType,
   iconIndex : number
) : any;

パラメータ

iconSetType: アイコンセットのタイプ。
iconIndex: アイコンインデックス。returns {object} 画像のURL文字列、オフセット、幅、および高さを含むオブジェクト。IconSetのアイコンをカスタマイズしたい場合は、関数の戻り値として画像のURL文字列を返します。

使用例

Javascript

// 次のサンプルコードは、アイコンセットルールのアイコンを返します。 activeSheet.setValue(0,0,1,3); activeSheet.setValue(1,0,15,3); activeSheet.setValue(2,0,25,3); activeSheet.setValue(3,0,-1,3); // アイコンを取得します。 var base = GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon; GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon = function (iconSetType, iconIndex) { var icon = base.apply(this, arguments); if (iconSetType === GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored) { if (iconIndex === 0) { return "images/Star2.png"; } else if (iconIndex === 1){ return "images/Rating4.png"; } else if (iconIndex === 2) { return "images/Box4.png"; } } return icon; }; 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 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); activeSheet.conditionalFormats.addRule(iconSetRule);

This example returns the icons for an icon set rule.

Javascript

activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);

var base = GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon;
GC.Spread.Sheets.ConditionalFormatting.IconSetRule.getIcon = function (iconSetType, iconIndex) {
                     var icon = base.apply(this, arguments);
                     if (iconSetType === GC.Spread.Sheets.ConditionalFormatting.IconSetType.threeArrowsColored) {
                         if (iconIndex === 0) {
                             return "images/Star2.png";
                         } else if (iconIndex === 1){
                             return "images/Rating4.png";
                         } else if (iconIndex === 2) {
                             return "images/Box4.png";
                         }
                     }
                     return icon;
                 };

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 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);
activeSheet.conditionalFormats.addRule(iconSetRule);

参照

IconSetRule クラス