public void LargeWithNumericStringInputReturnsPoundNum() { var function = new Large(); var result = function.Execute(FunctionsHelper.CreateArgs("3", "56"), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type); }
public void LargeWithDatesAsStringsInputsReturnsPoundNum() { var function = new Large(); var result = function.Execute(FunctionsHelper.CreateArgs("5/15/2017", 6), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type); }
public void LargeWithNoInputsReturnsPoundValue() { var function = new Large(); var result = function.Execute(FunctionsHelper.CreateArgs(), this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void LargeShouldReturnTheSecondLargestNumberIf2() { var func = new Large(); var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(4, 1, 2, 3), 2); var result = func.Execute(args, _parsingContext); Assert.AreEqual(3d, result.Result); }
public void LargeWithInvalidArgumentReturnsPoundValue() { var func = new Large(); var args = FunctionsHelper.CreateArgs(); var result = func.Execute(args, this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void LargeShouldReturnTheLargestNumberIf1() { var func = new Large(); var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(1, 2, 3), 1); var result = func.Execute(args, this.ParsingContext); Assert.AreEqual(3, result.Result); }
public void LargeShouldPoundNumIfIndexOutOfBounds() { var func = new Large(); var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(4, 1, 2, 3), 6); var result = func.Execute(args, this.ParsingContext); Assert.AreEqual(OfficeOpenXml.FormulaParsing.ExpressionGraph.DataType.ExcelError, result.DataType); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)(result.Result)).Type); }
public void LargeWithNullSecondParameterReturnsPoundNum() { var function = new Large(); var result = function.Execute(FunctionsHelper.CreateArgs(4, null), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type); using (var package = new ExcelPackage()) { var worksheet = package.Workbook.Worksheets.Add("Sheet1"); worksheet.Cells["B1"].Formula = "LARGE(4, )"; worksheet.Calculate(); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)worksheet.Cells["B1"].Value).Type); } }
public void LargeShouldThrowIfIndexOutOfBounds() { var func = new Large(); var args = FunctionsHelper.CreateArgs(FunctionsHelper.CreateArgs(4, 1, 2, 3), 6); var result = func.Execute(args, _parsingContext); }