public override double VisitMinMaxExpr([NotNull] ExcelParser.MinMaxExprContext context)
{
var expr = context.GetText();
int start = 4; // MAX(132,2654) expr[4] = 1
int length = expr.IndexOf(')') - start; // length = Length ("132,2564")
expr = expr.Substring(start, length); // MAX(132,2654) -> 132,2654
string[] numbers = expr.Split(','); // "132,2564" -> [0] = "132" [1] = "2564"
double first = Convert.ToDouble(numbers[0]);
double second = Convert.ToDouble(numbers[1]);
if (context.operatorToken.Type == ExcelLexer.MAX)
{
return(Math.Max(first, second));
}
else
{
return(Math.Min(first, second));
}
}
/// <summary>
/// Visit a parse tree produced by the <c>MinMaxExpr</c>
/// labeled alternative in <see cref="ExcelParser.expression"/>.
/// <para>
/// The default implementation returns the result of calling <see cref="AbstractParseTreeVisitor{Result}.VisitChildren(IRuleNode)"/>
/// on <paramref name="context"/>.
/// </para>
/// </summary>
/// <param name="context">The parse tree.</param>
/// <return>The visitor result.</return>
public virtual Result VisitMinMaxExpr([NotNull] ExcelParser.MinMaxExprContext context)
{
return(VisitChildren(context));
}
/// <summary>
/// Exit a parse tree produced by the <c>MinMaxExpr</c>
/// labeled alternative in <see cref="ExcelParser.expression"/>.
/// <para>The default implementation does nothing.</para>
/// </summary>
/// <param name="context">The parse tree.</param>
public virtual void ExitMinMaxExpr([NotNull] ExcelParser.MinMaxExprContext context)
{
}
