public void VarShouldReturnCorrectResult() { var func = new Var(); var args = FunctionsHelper.CreateArgs(1, 2, 3, 4); var result = func.Execute(args, _parsingContext); Assert.AreEqual(1.6667d, System.Math.Round((double)result.Result, 4)); }
public void VarShouldIgnoreHiddenValuesIfIgnoreHiddenIsTrue() { var func = new Var(); 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.6667d, System.Math.Round((double)result.Result, 4)); }