public void VarPShouldReturnCorrectResult() { var func = new VarP(); var args = FunctionsHelper.CreateArgs(1, 2, 3, 4); var result = func.Execute(args, _parsingContext); Assert.AreEqual(1.25d, result.Result); }
public void VarPShouldIgnoreHiddenValuesIfIgnoreHiddenIsTrue() { var func = new VarP(); func.IgnoreHiddenValues = true; var args = FunctionsHelper.CreateArgs(1, 2, 3, 4, 9); args.Last().SetExcelStateFlag(ExcelCellState.HiddenCell); var result = func.Execute(args, _parsingContext); Assert.AreEqual(1.25d, result.Result); }