Перечисление ConditionalFormatIconSet
Перечисление ConditionalFormatIconSet содержит наборы значков, которые используются в условном форматировании. Используется в методах ConditionalFormatIconSetEntry.getIconSet() и ConditionalFormatIconSetEntry.setIconSet().
| Значение | Набор значков |
|---|---|
ConditionalFormatIconSet.ThreeArrows | |
ConditionalFormatIconSet.ThreeArrowsGray | |
ConditionalFormatIconSet.ThreeFlags | |
ConditionalFormatIconSet.ThreeTrafficLights1 | |
ConditionalFormatIconSet.ThreeTrafficLights2 | |
ConditionalFormatIconSet.ThreeSigns | |
ConditionalFormatIconSet.ThreeSymbols | |
ConditionalFormatIconSet.ThreeSymbols2 | |
ConditionalFormatIconSet.ThreeStars | |
ConditionalFormatIconSet.ThreeTriangles | |
ConditionalFormatIconSet.ThreeSmilies | Не поддерживается |
ConditionalFormatIconSet.ThreeColorSmilies | Не поддерживается |
ConditionalFormatIconSet.FourArrows | |
ConditionalFormatIconSet.FourArrowsGray | |
ConditionalFormatIconSet.FourRedToBlack | |
ConditionalFormatIconSet.FourRating | |
ConditionalFormatIconSet.FourTrafficLights | |
ConditionalFormatIconSet.FiveArrows | |
ConditionalFormatIconSet.FiveArrowsGray | |
ConditionalFormatIconSet.FiveRating | |
ConditionalFormatIconSet.FiveQuarters | |
ConditionalFormatIconSet.FiveBoxes | |
ConditionalFormatIconSet.NoIcons | Пустой набор |
Пример
var entries = new ConditionalFormatIconSetEntries();
var value1 = new ConditionalFormatValueObject(ConditionalFormatValueObjectType.Percent, "0", false);
var entry1 = new ConditionalFormatIconSetEntry(value1, ConditionalFormatIconSet.FiveBoxes, 0);
entries.addEntry(entry1);