set_formula method

set_formula

Set the formula and the value(calculated result) of the formula.

def set_formula(self, formula, value):
    ...
ParameterTypeDescription
formulastrThe formula.
valueanyThe value(calculated result) of the formula.

set_formula

Set the formula and the value(calculated result) of the formula.

def set_formula(self, formula, options, value):
    ...
ParameterTypeDescription
formulastrThe formula.
optionsFormulaParseOptionsOptions for parsing the formula.
valueanyThe value(calculated result) of the formula.

set_formula

Set the formula and the value of the formula.

def set_formula(self, formula, is_r1c1, is_local, value):
    ...
ParameterTypeDescription
formulastrThe formula.
is_r1c1boolWhether the formula is R1C1 formula.
is_localboolWhether the formula is locale formatted.
valueanyThe value of the formula.

Remarks

NOTE: This class is now obsolete. Instead, please use Cell.SetFormula(string,FormulaParseOptions,object). This property will be removed 12 months later since December 2019. Aspose apologizes for any inconvenience you may have experienced.

See Also