Cell.SetFormula

SetFormula(string, object)

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

public void SetFormula(string formula, object value)

Parameter	Type	Description
formula	String	The formula.
value	Object	The value(calculated result) of the formula.

See Also

• class Cell
• namespace Aspose.Cells
• assembly Aspose.Cells

---

SetFormula(string, FormulaParseOptions)

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

public void SetFormula(string formula, FormulaParseOptions options)

Parameter	Type	Description
formula	String	The formula.
options	FormulaParseOptions	Options for parsing the formula.

See Also

• class FormulaParseOptions
• class Cell
• namespace Aspose.Cells
• assembly Aspose.Cells

---

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)

Parameter	Type	Description
formula	String	The formula.
isR1C1	Boolean	Whether the formula is R1C1 formula.
isLocal	Boolean	Whether the formula is locale formatted.
value	Object	The 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

• class Cell
• namespace Aspose.Cells
• assembly Aspose.Cells

---

SetFormula(string, FormulaParseOptions, object)

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

public void SetFormula(string formula, FormulaParseOptions options, object value)

Parameter	Type	Description
formula	String	The formula.
options	FormulaParseOptions	Options for parsing the formula.
value	Object	The value(calculated result) of the formula.

See Also

• class FormulaParseOptions
• class Cell
• namespace Aspose.Cells
• assembly Aspose.Cells