## FormatCondition::SetFormula1(const U16String\&, bool, bool) method


Sets the value or expression associated with this format condition.

```cpp
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](../../vector/)
* Class [U16String](../../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.

```cpp
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](../../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.

```cpp
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](../../vector/)
* Class [U16String](../../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.

```cpp
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](../../vector/)
* Class [FormatCondition](../)
* Namespace [Aspose::Cells](../../)
* Library [Aspose.Cells for C++](../../../)