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)
ParameterTypeDescription
formulaconst 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: “="=…"”.
isR1C1boolWhether the formula is R1C1 formula.
isLocalboolWhether the formula is locale formatted.

See Also

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)
ParameterTypeDescription
formulaconst 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: “="=…"”.
isR1C1boolWhether the formula is R1C1 formula.
isLocalboolWhether the formula is locale formatted.

See Also

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

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