public void StdevPShouldIgnoreHiddenValuesWhenIgnoreHiddenValuesIsSet()
{
var func = new StdevP();
func.IgnoreHiddenValues = true;
var args = FunctionsHelper.CreateArgs(2, 3, 4, 165);
args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell);
var result = func.Execute(args, _parsingContext);
Assert.AreEqual(0.8165d, Math.Round((double)result.Result, 5));
}
public void StdevPShouldCalculateCorrectResult()
{
var func = new StdevP();
var args = FunctionsHelper.CreateArgs(2, 3, 4);
var result = func.Execute(args, _parsingContext);
Assert.AreEqual(0.8165d, Math.Round((double)result.Result, 5));
}