Cell.SetFormula

SetFormula(string, object)

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

public void SetFormula(string formula, object value)
ParameterTypeDescription
formulaStringThe formula.
valueObjectThe value(calculated result) of the formula.

See Also


SetFormula(string, bool, bool, object)

Set the formula and the value of the formula.

[Obsolete("Use FormulaParseOptions for more options instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public void SetFormula(string formula, bool isR1C1, bool isLocal, object value)
ParameterTypeDescription
formulaStringThe formula.
isR1C1BooleanWhether the formula is R1C1 formula.
isLocalBooleanWhether the formula is locale formatted.
valueObjectThe 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


SetFormula(string, FormulaParseOptions, object)

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

public void SetFormula(string formula, FormulaParseOptions options, object value)
ParameterTypeDescription
formulaStringThe formula.
optionsFormulaParseOptionsOptions for parsing the formula.
valueObjectThe value(calculated result) of the formula.

See Also