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));
}
