Таблица DocumentAPI.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 | Пустой набор |
Пример
local entries = DocumentAPI.ConditionalFormatIconSetEntries()
local value1 = DocumentAPI.ConditionalFormatValueObject(DocumentAPI.ConditionalFormatValueObjectType_Percent, "0", false)
local entry1 = DocumentAPI.ConditionalFormatIconSetEntry(value1, DocumentAPI.ConditionalFormatIconSet_FiveBoxes, 0)
entries:addEntry(entry1)