Hi the API for Aspose Cells about the SetFormula method show this :
public void SetFormula(
string formula,
FormulaParseOptions options,
Object value
)
But what is the “value” parameter??? I don’t know what to set as an input. Please help me.
Regards
It refers to the value of the formula. In some cases, you might want to set some value as formula result/output when not to parse formula for evaluation. We will get back to you with more details soon.
As @Amjad_Sahi said, in some cases user may want to initialize the formula calculated result and do not need to trigger the formula calculation. If it is not your case, please just input it as null(it is also the default value for other APIs of setting formula).