public void Log10WithDateAsStringInputReturnsCorrectValue()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs("6/5/2017"), this.ParsingContext);
Assert.AreEqual(4.632366172d, (double)result.Result, 0.000001);
}
public void Log10WithNegativeIntegerReturnsPoundNum()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs(-1000), this.ParsingContext);
Assert.AreEqual(eErrorType.Num, ((ExcelErrorValue)result.Result).Type);
}
public void Log10WithDoubleInputReturnsCorrectValue()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs(150.26), this.ParsingContext);
Assert.AreEqual(2.176843385d, (double)result.Result, 0.000001);
}
public void Log10WithPositiveIntegerReturnsCorrectValue()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs(100), this.ParsingContext);
Assert.AreEqual(2d, result.Result);
}
public void Log10WithNoArgumentsReturnsPoundValue()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs(), this.ParsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type);
}
public void Log10WithNumericStringInputReturnsCorrectValue()
{
var function = new Log10();
var result = function.Execute(FunctionsHelper.CreateArgs("100"), this.ParsingContext);
Assert.AreEqual(2d, result.Result);
}
public void Log10ShouldReturnCorrectResult()
{
var func = new Log10();
var args = FunctionsHelper.CreateArgs(2);
var result = func.Execute(args, this.ParsingContext);
Assert.AreEqual(0.301029996d, (double)result.Result, 0.000001);
}
public void Log10ShouldReturnCorrectResult()
{
var func = new Log10();
var args = FunctionsHelper.CreateArgs(2);
var result = func.Execute(args, _parsingContext);
var roundedResult = Math.Round((double)result.Result, 9);
Assert.AreEqual(0.301029996d, roundedResult);
}
public void Log10FunctionWithErrorValuesAsInputReturnsTheInputErrorValue()
{
var func = new Log10();
var argNA = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.NA));
var argNAME = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Name));
var argVALUE = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Value));
var argNUM = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Num));
var argDIV0 = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Div0));
var argREF = FunctionsHelper.CreateArgs(ExcelErrorValue.Create(eErrorType.Ref));
var resultNA = func.Execute(argNA, this.ParsingContext);
var resultNAME = func.Execute(argNAME, this.ParsingContext);
var resultVALUE = func.Execute(argVALUE, this.ParsingContext);
var resultNUM = func.Execute(argNUM, this.ParsingContext);
var resultDIV0 = func.Execute(argDIV0, this.ParsingContext);
var resultREF = func.Execute(argREF, 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);
}
