public void SqrtPiWithNegativeDoubleReturnsPoundNum()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs(-1.5);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type);
}
public void SqrtPiWithPositiveIntegerInStringReturnsCorrectResult()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs("4");
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(3.54490770181103, (double)result.Result, 0.00000000000001);
}
public void SqrtPiWithZeroReturnsCorrectResult()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs(0);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(0d, result.Result);
}
public void SqrtPiWithPositiveDoubleReturnsCorrectResult()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs(6.25);
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(4.43113462726379, (double)result.Result, 0.00000000000001);
}
public void SqrtPiWithTooFewArgumentsReturnsPoundValue()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs();
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type);
}
public void SqrtPiWithDateInStringReturnsCorrectResult()
{
var function = new SqrtPi();
var arguments = FunctionsHelper.CreateArgs("3/4/1900");
var result = function.Execute(arguments, this.ParsingContext);
Assert.AreEqual(14.1796308072441, (double)result.Result, 0.0000000000001);
}
public void SqrtPiShouldReturnCorrectResult()
{
var func = new SqrtPi();
var args = FunctionsHelper.CreateArgs(2);
var result = func.Execute(args, _parsingContext);
var roundedResult = Math.Round((double)result.Result, 9);
Assert.AreEqual(2.506628275d, roundedResult);
}
public void SqrtPiWithInvalidArgumentReturnsPoundValue()
{
var func = new SqrtPi();
var parsingContext = ParsingContext.Create();
var args = FunctionsHelper.CreateArgs();
var result = func.Execute(args, parsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type);
}
public void SqrtPiFunctionWithErrorValuesAsInputReturnsTheInputErrorValue()
{
var function = new SqrtPi();
var argumentNA = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.NA));
var argumentNAME = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Name));
var argumentVALUE = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Value));
var argumentNUM = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Num));
var argumentDIV0 = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Div0));
var argumentREF = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Ref));
var resultNA = function.Execute(argumentNA, this.ParsingContext);
var resultNAME = function.Execute(argumentNAME, this.ParsingContext);
var resultVALUE = function.Execute(argumentVALUE, this.ParsingContext);
var resultNUM = function.Execute(argumentNUM, this.ParsingContext);
var resultDIV0 = function.Execute(argumentDIV0, this.ParsingContext);
var resultREF = function.Execute(argumentREF, this.ParsingContext);
Assert.AreEqual(eErrorType.NA, ((ExcelErrorValue)resultNA.Result).Type);
Assert.AreEqual(eErrorType.Name, ((ExcelErrorValue)resultNAME.Result).Type);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)resultVALUE.Result).Type);
Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)resultNUM.Result).Type);
Assert.AreEqual(eErrorType.Div0, ((ExcelErrorValue)resultDIV0.Result).Type);
Assert.AreEqual(eErrorType.Ref, ((ExcelErrorValue)resultREF.Result).Type);
}
