Execute() public method

public Execute ( IEnumerable arguments, ParsingContext context ) : CompileResult
arguments IEnumerable
context ParsingContext
return ExcelFormulaParser.Engine.ExpressionGraph.CompileResult
SumIf Class Documentation
Example #1
0
 public void SumIfShouldThrowIfCriteriaIsLargerThan255chars()
 {
     var longString = "a";
     for (var x = 0; x < 256; x++) { longString = string.Concat(longString, "a"); }
     var func = new SumIf();
     var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(3, 4, 5), longString, (FunctionsHelper.CreateArgs(3, 2, 1)));
     var result = func.Execute(args, _parsingContext);
 }
Example #2
0
 public void SumIfShouldCalculateWithExpression()
 {
     var func = new SumIf();
     var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(3, 4, 5), ">3");
     var result = func.Execute(args, _parsingContext);
     Assert.AreEqual(9d, result.Result);
 }
Example #3
0
 public void SumIfShouldCalculateWithExpressionFromSumRangeWithNumericCriteria()
 {
     var func = new SumIf();
     var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(3, 4, 5), 3, (FunctionsHelper.CreateArgs(4, 2, 1)));
     var result = func.Execute(args, _parsingContext);
     Assert.AreEqual(4d, result.Result);
 }
Example #4
0
 public void SumIfShouldCalculateMatchingValuesOnly()
 {
     var func = new SumIf();
     var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(3, 4, 5), "4");
     var result = func.Execute(args, _parsingContext);
     Assert.AreEqual(4d, result.Result);
 }