Execute() public method

public Execute ( IEnumerable arguments, ParsingContext context ) : CompileResult
arguments IEnumerable
context ParsingContext
return ExcelFormulaParser.Engine.ExpressionGraph.CompileResult
Subtotal Class Documentation
Ejemplo n.º 1
0
 public void ShouldCalculateCountWhenCalcTypeIs2()
 {
     var func = new Subtotal();
     var args = FunctionsHelper.CreateArgs(2, 10, 20, 30, 40, 50);
     var result = func.Execute(args, _context);
     Assert.AreEqual(5d, result.Result);
 }
Ejemplo n.º 2
0
 public void ShouldThrowIfInvalidFuncNumber()
 {
     var func = new Subtotal();
     var args = FunctionsHelper.CreateArgs(139, 1);
     func.Execute(args, _context);
 }
Ejemplo n.º 3
0
 public void ShouldCalculateStdevWhenCalcTypeIs7()
 {
     var func = new Subtotal();
     var args = FunctionsHelper.CreateArgs(7, 10, 20, 30, 40, 50);
     var result = func.Execute(args, _context);
     var resultRounded = Math.Round((double)result.Result, 5);
     Assert.AreEqual(15.81139d, resultRounded);
 }
Ejemplo n.º 4
0
 public void ShouldCalculateVarWhenCalcTypeIs110()
 {
     var func = new Subtotal();
     var args = FunctionsHelper.CreateArgs(110, 10, 20, 30, 40, 50, 51);
     args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell);
     var result = func.Execute(args, _context);
     Assert.AreEqual(250d, result.Result);
 }
Ejemplo n.º 5
0
 public void ShouldCalculateStdevPWhenCalcTypeIs108()
 {
     var func = new Subtotal();
     var args = FunctionsHelper.CreateArgs(108, 10, 20, 30, 40, 50);
     var result = func.Execute(args, _context);
     var resultRounded = Math.Round((double)result.Result, 8);
     Assert.AreEqual(14.14213562, resultRounded);
 }