FormatConditionCollection

FormatConditionCollection

Overview

FormatConditionCollection is a class in Aspose.Cells FOSS for Java.

Represents a collection of format conditions in Excel.

Properties

NameTypeAccessDescription
countintReadReturns the count.
rangeCountintReadReturns the range count.

Methods

SignatureDescription
getCount()intReturns the count.
getRangeCount()intReturns the range count.
get(index: int)FormatConditionReturns the requested item.
add(area: CellArea, type: FormatConditionType, operatorType: OperatorType, formula1: String, formula2: String)intAdds a new item to the current collection.
addCondition(type: FormatConditionType)intAdds condition.
addCondition(type: FormatConditionType, operatorType: OperatorType, formula1: String, formula2: String)intAdds condition.
addArea(area: CellArea)Adds area.
getCellArea(index: int)CellAreaProcesses get cell area.
removeArea(index: int)Removes area.
removeArea(startRow: int, startColumn: int, totalRows: int, totalColumns: int)Removes area.
removeCondition(index: int)Removes condition.