// Evaluates the specified expression and returns the result or error message.
private string Evaluate(string formula)
{
// Set current row index of the data source.
_calcEngine.CurrentIndex = c1FlexGrid1.Selection.TopRow - 1;
// Set the expression.
_calcEngine.Expression = formula;
return(_calcEngine.TryEvaluate(out object result) ? result.ToString() : _calcEngine.GetErrors().FirstOrDefault()?.FullMessage ?? "");
}
private void button1_Click(object sender, System.EventArgs e)
{
_calcEngine.Expression = textBox1.Text;
if (_calcEngine.TryEvaluate(out object result))
{
textBox2.Text = (result ?? "").ToString();
}
else
{
textBox2.Text = _calcEngine.GetErrors().FirstOrDefault()?.FullMessage ?? "";
}
}
// Evaluates the expression.
private void Evaluate()
{
// Set the expression.
_calcEngine.Expression = formula1.Expression;
// Try to evaluate the expression.
if (_calcEngine.TryEvaluate(out object result))
{
// Evaluation is successful. Show evaluation result.
formula1.Result = result.ToString();
}
else
{
// Evaluation is failed. Show error message.
formula1.Result = _calcEngine.GetErrors().FirstOrDefault()?.FullMessage ?? "";
}
}
private string Evaluate(string formula)
{
_calcEngine.Expression = formula;
return(_calcEngine.TryEvaluate(out object result) ? result.ToString() : _calcEngine.GetErrors().FirstOrDefault()?.FullMessage ?? "");
}