Aspose::Cells::FormatCondition::SetFormula1 method
FormatCondition::SetFormula1(const U16String&, bool, bool) method
Sets the value or expression associated with this format condition.
void Aspose::Cells::FormatCondition::SetFormula1(const U16String &formula, bool isR1C1, bool isLocal)
| Parameter | Type | Description |
|---|---|---|
| formula | const U16String& | The value or expression associated with this format condition. If the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”. |
| isR1C1 | bool | Whether the formula is R1C1 formula. |
| isLocal | bool | Whether the formula is locale formatted. |
See Also
- Class Vector
- Class U16String
- Class FormatCondition
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
FormatCondition::SetFormula1(const char16_t*, bool, bool) method
Sets the value or expression associated with this format condition.
void Aspose::Cells::FormatCondition::SetFormula1(const char16_t *formula, bool isR1C1, bool isLocal)
| Parameter | Type | Description |
|---|---|---|
| formula | const char16_t* | The value or expression associated with this format condition. If the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”. |
| isR1C1 | bool | Whether the formula is R1C1 formula. |
| isLocal | bool | Whether the formula is locale formatted. |
See Also
- Class Vector
- Class FormatCondition
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
FormatCondition::SetFormula1(const U16String&) method
Gets and sets the value or expression associated with conditional formatting.
void Aspose::Cells::FormatCondition::SetFormula1(const U16String &value)
Remarks
Please add all areas before setting formula. For setting formula for this condition, if the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”.
See Also
- Class Vector
- Class U16String
- Class FormatCondition
- Namespace Aspose::Cells
- Library Aspose.Cells for C++
FormatCondition::SetFormula1(const char16_t*) method
Gets and sets the value or expression associated with conditional formatting.
void Aspose::Cells::FormatCondition::SetFormula1(const char16_t *value)
Remarks
Please add all areas before setting formula. For setting formula for this condition, if the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”.
See Also
- Class Vector
- Class FormatCondition
- Namespace Aspose::Cells
- Library Aspose.Cells for C++