public void CeilingWithBooleanFirstInputsReturnsCorrectValue() { var function = new Ceiling(); var booleanTrue = function.Execute(FunctionsHelper.CreateArgs(true, 3), this.ParsingContext); var booleanFalse = function.Execute(FunctionsHelper.CreateArgs(false, 2), this.ParsingContext); Assert.AreEqual(3d, booleanTrue.Result); Assert.AreEqual(0d, booleanFalse.Result); }
public void CeilingWithBooleanSecondInputReturnsCorrectValue() { var function = new Ceiling(); var booleanTrue = function.Execute(FunctionsHelper.CreateArgs(56.672, true), this.ParsingContext); var booleanFalse = function.Execute(FunctionsHelper.CreateArgs(45.6, false), this.ParsingContext); Assert.AreEqual(57d, booleanTrue.Result); Assert.AreEqual(0d, booleanFalse.Result); }
public void CeilingWithPositiveFirstInputAndNegativeSecondInputReturnsPoundNum() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(52.3, -9), this.ParsingContext); Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type); }
public void CeilingWithNegativeInputsReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(-2.5, -2), this.ParsingContext); Assert.AreEqual(-4d, result.Result); }
public void CeilingWithGeneralStringFirstInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs("string", 3), this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void CeilingWithDateAsStringSecondInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(12.3, "5/5/2017"), this.ParsingContext); Assert.AreEqual(42860d, result.Result); }
public void CeilingWithNumericStringSecondInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(5, "2"), this.ParsingContext); Assert.AreEqual(6d, result.Result); }
public void CeilingWithDoubleSecondInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(45, 6.7), this.ParsingContext); Assert.AreEqual(46.9d, (double)result.Result, 0.000001); }
public void CeilingWithSecondInputAsIntegerReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(6, 5), this.ParsingContext); Assert.AreEqual(10d, result.Result); }
public void CeilingWithNumbericStringFirstInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs("45.6", 4), this.ParsingContext); Assert.AreEqual(48d, result.Result); }
public void CeilingWithFirstInputNegativeSecondInputPositiveReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(-15, 4), this.ParsingContext); Assert.AreEqual(-12d, result.Result); }
public void CeilingWithNoInputsReturnsPoundValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(), this.ParsingContext); Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type); }
public void CeilingWithDoubleFirstInputReturnsCorrectValue() { var function = new Ceiling(); var result = function.Execute(FunctionsHelper.CreateArgs(12.63, 3), this.ParsingContext); Assert.AreEqual(15d, result.Result); }
public void CeilingBugTest2() { var expectedValue = 12000d; var func = new Ceiling(); var args = FunctionsHelper.CreateArgs(12000d, 1000d); var result = func.Execute(args, _parsingContext); Assert.AreEqual(expectedValue, result.Result); }
public void CeilingShouldRoundUpAccordingToParamsSignificanceLowerThan0() { var expectedValue = 22.36d; var func = new Ceiling(); var args = FunctionsHelper.CreateArgs(22.35d, 0.01); var result = func.Execute(args, _parsingContext); Assert.AreEqual(expectedValue, result.Result); }
public void CeilingShouldRoundTowardsZeroIfSignificanceAndNumberIsNegative() { var expectedValue = -30d; var func = new Ceiling(); var args = FunctionsHelper.CreateArgs(-22.35d, -10); var result = func.Execute(args, _parsingContext); Assert.AreEqual(expectedValue, result.Result); }
public void CeilingShouldThrowExceptionIfNumberIsPositiveAndSignificanceIsNegative() { var expectedValue = 30d; var func = new Ceiling(); var args = FunctionsHelper.CreateArgs(22.35d, -1); var result = func.Execute(args, _parsingContext); Assert.AreEqual(expectedValue, result.Result); }
public void CeilingShouldRoundTowardsZeroIfSignificanceAndNumberIsMinus0point1() { var expectedValue = -22.4d; var func = new Ceiling(); var args = FunctionsHelper.CreateArgs(-22.35d, -0.1); var result = func.Execute(args, _parsingContext); Assert.AreEqual(expectedValue, System.Math.Round((double)result.Result, 2)); }