Skip to main content

Таблица 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)