Excel.Interfaces.IconSetConditionalFormatLoadOptions interface

表示条件格式的 IconSet 条件。Represents an IconSet criteria for conditional formatting.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性

$all
criteria

用于条件图标的规则和潜在自定义图标的条件和 IconSets 的数组。An array of Criteria and IconSets for the rules and potential custom icons for conditional icons. 请注意, 对于第一个条件, 只有自定义图标可以修改, 而类型、公式和运算符在设置时将被忽略。Note that for the first criterion only the custom icon can be modified, while type, formula, and operator will be ignored when set.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

reverseIconOrder

如果为 true, 则反转 IconSet 的图标订单。If true, reverses the icon orders for the IconSet. 请注意, 如果使用自定义图标, 则不能设置此设置。Note that this cannot be set if custom icons are used.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

showIconOnly

如果为 true,则隐藏值并仅显示图标。If true, hides the values and only shows icons.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

style

如果设置, 则显示条件格式的 IconSet 选项。If set, displays the IconSet option for the conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

criteria

用于条件图标的规则和潜在自定义图标的条件和 IconSets 的数组。An array of Criteria and IconSets for the rules and potential custom icons for conditional icons. 请注意, 对于第一个条件, 只有自定义图标可以修改, 而类型、公式和运算符在设置时将被忽略。Note that for the first criterion only the custom icon can be modified, while type, formula, and operator will be ignored when set.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

criteria?: boolean;

属性值

boolean

reverseIconOrder

如果为 true, 则反转 IconSet 的图标订单。If true, reverses the icon orders for the IconSet. 请注意, 如果使用自定义图标, 则不能设置此设置。Note that this cannot be set if custom icons are used.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

reverseIconOrder?: boolean;

属性值

boolean

showIconOnly

如果为 true,则隐藏值并仅显示图标。If true, hides the values and only shows icons.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

showIconOnly?: boolean;

属性值

boolean

style

如果设置, 则显示条件格式的 IconSet 选项。If set, displays the IconSet option for the conditional format.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

style?: boolean;

属性值

boolean