public void StdevShouldIgnoreHiddenValuesWhenIgnoreHiddenValuesIsSet() { var func = new Stdev(); func.IgnoreHiddenValues = true; var args = FunctionsHelper.CreateArgs(1, 3, 5, 6); args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell); var result = func.Execute(args, _parsingContext); Assert.AreEqual(2d, result.Result); }
public void StdevShouldCalculateCorrectResult() { var func = new Stdev(); var args = FunctionsHelper.CreateArgs(1, 3, 5); var result = func.Execute(args, _parsingContext); Assert.AreEqual(2d, result.Result); }