public void ExecuteComplexNumberTest()
{
var complex = new Complex(3, 2);
var exp = new Tan(new ComplexNumber(complex));
var result = (Complex)exp.Execute();
Assert.Equal(Complex.Tan(complex), exp.Execute());
Assert.Equal(-0.0098843750383224935, result.Real, 14);
Assert.Equal(0.96538587902213313, result.Imaginary, 14);
}
public void TanHandlesTrueOrFalse()
{
var function = new Tan();
var input1 = true;
var input2 = false;
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
Assert.AreEqual(1.557407725, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(0, System.Math.Round(result2.ResultNumeric, 8));
}
public void TanHandlesMilitaryTimesPast2400()
{
var function = new Tan();
var input1 = "01:00";
var input2 = "02:00";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
Assert.AreEqual(0.041690796, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(0.083526772, System.Math.Round(result2.ResultNumeric, 9));
}
public void TanHandlesInputDatesAreSeperatedByDashes()
{
var function = new Tan();
var input1 = "1-17-2017 2:00";
var input2 = "1-17-2017 2:00 am";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
Assert.AreEqual(3.473770621, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(3.473770621, System.Math.Round(result2.ResultNumeric, 9));
}
public void TanTestInputsWithDatesThatHaveSlashesInThem()
{
var function = new Tan();
var input1 = "1/17/2011 2:00 am";
var input2 = "17/01/2011 2:00 AM";
var input3 = "17/Jan/2011 2:00 AM";
var input4 = "17/January/2011 2:00 am";
var input5 = "1/17/2011 2:00:00 am";
var input6 = "17/01/2011 2:00:00 AM";
var input7 = "17/Jan/2011 2:00:00 AM";
var input8 = "17/January/2011 2:00:00 am";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext);
var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext);
var result7 = function.Execute(FunctionsHelper.CreateArgs(input7), this.ParsingContext);
var result8 = function.Execute(FunctionsHelper.CreateArgs(input8), this.ParsingContext);
Assert.AreEqual(-1.626004608, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result2.Result).Type);
Assert.AreEqual(-1.626004608, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(-1.626004608, System.Math.Round(result4.ResultNumeric, 9));
Assert.AreEqual(-1.626004608, System.Math.Round(result5.ResultNumeric, 9));
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result6.Result).Type);
Assert.AreEqual(-1.626004608, System.Math.Round(result7.ResultNumeric, 9));
Assert.AreEqual(-1.626004608, System.Math.Round(result8.ResultNumeric, 9));
}
public void TanHandlesMilitaryTime()
{
var function = new Tan();
var input1 = "00:00";
var input2 = "00:01";
var input3 = "23:59:59";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
Assert.AreEqual(0, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(0.000694445, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(1.557368078, System.Math.Round(result3.ResultNumeric, 9));
}
public void TanHandlesNormal12HourClockInputs()
{
var function = new Tan();
var input1 = "00:00:00 AM";
var input2 = "00:01:32 AM";
var input3 = "12:00 PM";
var input4 = "12:00 AM";
var input5 = "1:00 PM";
var input6 = "1:10:32 am";
var input7 = "3:42:32 pm";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext);
var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext);
var result7 = function.Execute(FunctionsHelper.CreateArgs(input7), this.ParsingContext);
Assert.AreEqual(0, System.Math.Round(result1.ResultNumeric, 8));
Assert.AreEqual(0.001064815, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(0.54630249, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(0, System.Math.Round(result4.ResultNumeric, 8));
Assert.AreEqual(0.601697417, System.Math.Round(result5.ResultNumeric, 9));
Assert.AreEqual(0.049020691, System.Math.Round(result6.ResultNumeric, 9));
Assert.AreEqual(0.767388266, System.Math.Round(result7.ResultNumeric, 9));
}
public void DoubleFunctionTan()
{
var sut = new Tan();
var result = sut.Execute(new List <Accumulator> {
new Accumulator(Math.PI / 3)
});
Assert.AreEqual(Math.Tan(Math.PI / 3), result.ValueAsDouble());
}
public void TanWithInvalidArgumentReturnsPoundValue()
{
var func = new Tan();
var parsingContext = ParsingContext.Create();
var args = FunctionsHelper.CreateArgs();
var result = func.Execute(args, parsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result.Result).Type);
}
public void TanShouldReturnCorrectResult()
{
var func = new Tan();
var args = FunctionsHelper.CreateArgs(2);
var result = func.Execute(args, _parsingContext);
var roundedResult = Math.Round((double)result.Result, 9);
Assert.AreEqual(-2.185039863d, roundedResult);
}
public void TanIsGivenAStringAsInput()
{
var function = new Tan();
var input1 = "string";
var input2 = "0";
var input3 = "1";
var input4 = "1.5";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result1.Result).Type);
Assert.AreEqual(0, result2.ResultNumeric, .00001);
Assert.AreEqual(1.557407725, result3.ResultNumeric, .00001);
Assert.AreEqual(14.10141995, result4.ResultNumeric, .00001);
}
public void TanHandlesDateTimeInputs()
{
var function = new Tan();
var input1 = "1/17/2011 2:00";
var input2 = "1/17/2011 2:00 AM";
var input3 = "17/1/2011 2:00 AM";
var input4 = "17/Jan/2011 2:00 AM";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
Assert.AreEqual(-1.626004608, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(-1.626004608, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(eErrorType.Value, ((ExcelErrorValue)result3.Result).Type);
Assert.AreEqual(-1.626004608, System.Math.Round(result1.ResultNumeric, 9));
}
public void TanTestMilitaryTimeAndNormalTimeComparisions()
{
var function = new Tan();
var input1 = "16:30";
var input2 = "04:30 pm";
var input3 = "02:30";
var input4 = "2:30 am";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
Assert.AreEqual(0.821141802, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(0.821141802, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(0.104545069, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(0.104545069, System.Math.Round(result4.ResultNumeric, 9));
}
public void TanHandlesInputsWithDatesInTheFormMonthDateCommaYearTime()
{
var function = new Tan();
var input1 = "Jan 17, 2011 2:00 am";
var input2 = "June 5, 2017 11:00 pm";
var input3 = "Jan 17, 2011 2:00:00 am";
var input4 = "June 5, 2017 11:00:00 pm";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
Assert.AreEqual(-1.626004608, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(-0.209137654, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(-1.626004608, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(-0.209137654, System.Math.Round(result4.ResultNumeric, 9));
}
public void TanHandlesPi()
{
var function = new Tan();
var Pi = System.Math.PI;
var input1 = Pi;
var input2 = Pi / 2;
var input3 = 2 * Pi;
var input4 = 60 * Pi / 180;
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
//Note: Neither Excel or EPPlus handle Pi perfectly. Both seem to have a small rounding issue that is not a problem if you are aware of it.
Assert.AreEqual(-1.22515E-16, System.Math.Round(result1.ResultNumeric, 9), .00001);
Assert.AreEqual(1.63317787283838E+16, System.Math.Round(result2.ResultNumeric, 9), 1.0E+16);
Assert.AreEqual(-2.4503E-16, System.Math.Round(result3.ResultNumeric, 9), .00001);
Assert.AreEqual(1.732050808, System.Math.Round(result4.ResultNumeric, 9));
}
public void TanIntAndDoublesAsInputs()
{
var function = new Tan();
var input1 = 20;
var input2 = 100;
var input3 = 1;
var input4 = 1.0;
var input5 = 1.5;
var input6 = 1000;
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext);
var result6 = function.Execute(FunctionsHelper.CreateArgs(input6), this.ParsingContext);
Assert.AreEqual(2.237160944, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(-0.587213915, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(1.557407725, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(1.557407725, System.Math.Round(result4.ResultNumeric, 9));
Assert.AreEqual(14.10141995, System.Math.Round(result5.ResultNumeric, 8));
Assert.AreEqual(1.470324156, System.Math.Round(result6.ResultNumeric, 9));
}
public void TanHandlesDoublesCorrectly()
{
var function = new Tan();
var input1 = 0.5;
var input2 = 0.25;
var input3 = 0.9;
var input4 = -0.9;
var input5 = ".5";
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext);
Assert.AreEqual(0.54630249, System.Math.Round(result1.ResultNumeric, 9));
Assert.AreEqual(0.255341921, System.Math.Round(result2.ResultNumeric, 9));
Assert.AreEqual(1.260158218, System.Math.Round(result3.ResultNumeric, 9));
Assert.AreEqual(-1.260158218, System.Math.Round(result4.ResultNumeric, 9));
Assert.AreEqual(0.54630249, System.Math.Round(result5.ResultNumeric, 9));
}
public void TanIsGivenValuesRanginFromNegative10to10()
{
var function = new Tan();
var input1 = -10;
var input2 = -1;
var input3 = 0;
var input4 = 1;
var input5 = 10;
var result1 = function.Execute(FunctionsHelper.CreateArgs(input1), this.ParsingContext);
var result2 = function.Execute(FunctionsHelper.CreateArgs(input2), this.ParsingContext);
var result3 = function.Execute(FunctionsHelper.CreateArgs(input3), this.ParsingContext);
var result4 = function.Execute(FunctionsHelper.CreateArgs(input4), this.ParsingContext);
var result5 = function.Execute(FunctionsHelper.CreateArgs(input5), this.ParsingContext);
Assert.AreEqual(-0.648360827, result1.ResultNumeric, .00001);
Assert.AreEqual(-1.557407725, result2.ResultNumeric, .00001);
Assert.AreEqual(0, result3.ResultNumeric, .00001);
Assert.AreEqual(1.557407725, result4.ResultNumeric, .00001);
Assert.AreEqual(0.648360827, result5.ResultNumeric, .00001);
}
public void ExecuteTestException()
{
var exp = new Tan(new Bool(false));
Assert.Throws <ResultIsNotSupportedException>(() => exp.Execute());
}
public void ExecuteGradianTest()
{
var exp = new Tan(new Number(1));
Assert.Equal(Math.Tan(1 * Math.PI / 200), exp.Execute(AngleMeasurement.Gradian));
}
public void ExecuteDegreeTest()
{
var exp = new Tan(new Number(1));
Assert.Equal(Math.Tan(1 * Math.PI / 180), exp.Execute(AngleMeasurement.Degree));
}
