Aspose::Cells::FormatConditionCollection::Add method
Contents
[
Hide
]FormatConditionCollection::Add(const CellArea&, FormatConditionType, OperatorType, const U16String&, const U16String&) method
Adds a formatting condition and effected cell rang to the FormatConditions The FormatConditions can contain up to three conditional formats. References to the other sheets are not allowed in the formulas of conditional formatting.
Vector<int32_t> Aspose::Cells::FormatConditionCollection::Add(const CellArea &cellArea, FormatConditionType type, OperatorType operatorType, const U16String &formula1, const U16String &formula2)
| Parameter | Type | Description |
|---|---|---|
| cellArea | const CellArea& | Conditional formatted cell range. |
| type | FormatConditionType | Type of conditional formatting.It could be one of the members of FormatConditionType. |
| operatorType | OperatorType | Comparison operator.It could be one of the members of OperatorType. |
| formula1 | const U16String& | The value or expression associated with conditional formatting. |
| formula2 | const U16String& | The value or expression associated with conditional formatting |
ReturnValue
[0]:Formatting condition object index;[1] Effected cell rang index.
Remarks
See Also
- Class Vector
- Class CellArea
- Enum FormatConditionType
- Enum OperatorType
- Class U16String
- Class FormatConditionCollection
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
FormatConditionCollection::Add(const CellArea&, FormatConditionType, OperatorType, const char16_t*, const char16_t*) method
Adds a formatting condition and effected cell rang to the FormatConditions The FormatConditions can contain up to three conditional formats. References to the other sheets are not allowed in the formulas of conditional formatting.
Vector<int32_t> Aspose::Cells::FormatConditionCollection::Add(const CellArea &cellArea, FormatConditionType type, OperatorType operatorType, const char16_t *formula1, const char16_t *formula2)
| Parameter | Type | Description |
|---|---|---|
| cellArea | const CellArea& | Conditional formatted cell range. |
| type | FormatConditionType | Type of conditional formatting.It could be one of the members of FormatConditionType. |
| operatorType | OperatorType | Comparison operator.It could be one of the members of OperatorType. |
| formula1 | const char16_t* | The value or expression associated with conditional formatting. |
| formula2 | const char16_t* | The value or expression associated with conditional formatting |
ReturnValue
[0]:Formatting condition object index;[1] Effected cell rang index.
Remarks
See Also
- Class Vector
- Class CellArea
- Enum FormatConditionType
- Enum OperatorType
- Class FormatConditionCollection
- Namespace Aspose::Cells
- Library Aspose.Cells for C++