public void SimpleFormula1Arg()
{
var expected = Statement.NewFormula(
Expression.NewFunctionExpression(
"F", SyntaxList <Expression> .NewSingle(
CreateExpression(1))));
var result = Parse("F(1)");
Assert.Equal(expected, result);
}
public void CellReferenceRange()
{
var expected = Statement.NewFormula(
Expression.NewFunctionExpression("SUM",
SyntaxList <Expression> .NewSingle(
Expression.NewCellReferenceRangeExpression(
CellReference.NewRelative("C", 3),
CellReference.NewRelative("C", 5)))));
var result = Parse("SUM(C3:C5)");
Assert.Equal(expected, result);
}
public void CellReferenceInArgumentWithAnchor()
{
var expected = Statement.NewFormula(
Expression.NewBinaryExpression(
Expression.NewCellReferenceExpression(
CellReference.NewRelative("A", 1)),
Operation.Multiply,
Expression.NewFunctionExpression("A2",
SyntaxList <Expression> .NewSingle(
Expression.NewCellReferenceExpression(
CellReference.NewRelative("A", 3))))));
var result = Parse("A1*A2(A3)");
Assert.Equal(expected, result);
}
