public void ExcelDateValueTest()
{
DateTime value1 = Convert.ToDateTime(this.TestContext.DataRow["DATE"]);
decimal expectedValue = Convert.ToDecimal(this.TestContext.DataRow["DATEVALUE"]);
decimal actualValue = ExcelFormulae.ToExcelDateValue(value1);
decimal difference = expectedValue - actualValue;
CustomAssert.AreEqual(expectedValue, actualValue, TestDirector.ExcelDecimalDelta);
}
public void ExcelModuloComparisons()
{
decimal value1 = Convert.ToDecimal(this.TestContext.DataRow["VALUE1"]);
decimal value2 = Convert.ToDecimal(this.TestContext.DataRow["VALUE2"]);
decimal expectedValue = Convert.ToDecimal(this.TestContext.DataRow["MOD"]);
decimal actualValue = ExcelFormulae.Mod(value1, value2);
decimal difference = expectedValue - actualValue;
CustomAssert.AreEqual(expectedValue, actualValue, TestDirector.ExcelDecimalDelta);
}
public void ExcelModuloComparisons(CsharpExcelTestData item)
{
decimal actualValue = ExcelFormulae.Mod(item.Value1, item.Value2);
CustomAssert.AreEqual(item.Mod, actualValue, TestDirector.ExcelDecimalDelta);
}
public void ExcelDateValueTest(DateValueTestData item)
{
decimal actualValue = ExcelFormulae.ToExcelDateValue(item.Date);
CustomAssert.AreEqual(item.DateValue, actualValue, TestDirector.ExcelDecimalDelta);
}
