public void DecimalFormula_FormulaValueIsSetFromXmlNodeInConstructor()
{
// Arrange
LoadXmlTestData("A1", "decimal", "1.3");
// Act
var validation = new ExcelDataValidationDecimal(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Decimal, _dataValidationNode, _namespaceManager);
Assert.AreEqual(1.3D, validation.Formula.Value);
}
public void ListFormula_FormulasExcelFormulaIsSetFromXmlNodeInConstructor()
{
// Arrange
LoadXmlTestData("A1", "list", "A1");
// Act
var validation = new ExcelDataValidationList(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual("A1", validation.Formula.ExcelFormula);
}
public void DataValidations_ShouldSetShowInputMessageFromExistingXml()
{
// Arrange
LoadXmlTestData("A1", "whole", "1", false, true);
// Act
var validation = new ExcelDataValidationInt(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
// Assert
Assert.IsTrue(validation.ShowInputMessage ?? false);
}
public void DataValidations_ShouldSetErrorTitleFromExistingXml()
{
// Arrange
LoadXmlTestData("A1", "whole", "1", "Prompt", "PromptTitle", "Error", "ErrorTitle");
// Act
var validation = new ExcelDataValidationInt(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual("ErrorTitle", validation.ErrorTitle);
}
public void DataValidations_ShouldSetOperatorFromExistingXml()
{
// Arrange
LoadXmlTestData("A1", "whole", "greaterThanOrEqual", "1");
// Act
var validation = new ExcelDataValidationInt(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual(ExcelDataValidationOperator.greaterThanOrEqual, validation.Operator);
}
public void UidShouldBeSetOnValidations()
{
// Arrange
LoadXmlTestData("A1", "decimal", "1.3");
var id = ExcelDataValidation.NewId();
// Act
var validation = new ExcelDataValidationDecimal(_sheet, id, "A1", ExcelDataValidationType.Decimal, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual(id, validation.Uid);
}
public void CustomFormula_FormulasFormulaIsSetFromXmlNodeInConstructor()
{
// Arrange
LoadXmlTestData("A1", "decimal", "A1");
// Act
var validation = new ExcelDataValidationCustom(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Custom, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual("A1", validation.Formula.ExcelFormula);
}
public void ListFormula_FormulaValueIsSetFromXmlNodeInConstructorOrderIsCorrect()
{
// Arrange
LoadXmlTestData("A1", "list", "\"1,2\"");
// Act
var validation = new ExcelDataValidationList(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.List, _dataValidationNode, _namespaceManager);
// Assert
CollectionAssert.AreEquivalent(new List <string> {
"1", "2"
}, (ICollection)validation.Formula.Values);
}
public void TimeFormula_ValueIsSetFromConstructorValidateSecond()
{
// Arrange
var time = new ExcelTime(0.812M);
LoadXmlTestData("A1", "time", "0.812");
// Act
var formula = new ExcelDataValidationTime(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Time, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual(time.Second.Value, formula.Formula.Value.Second.Value);
}
public void DateTimeFormula_FormulasFormulaIsSetFromXmlNodeInConstructor()
{
// Arrange
var date = DateTime.Parse("2011-01-08");
LoadXmlTestData("A1", "decimal", "A1");
// Act
var validation = new ExcelDataValidationDateTime(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Decimal, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual("A1", validation.Formula.ExcelFormula);
}
public void DateTimeFormula_FormulaValueIsSetFromXmlNodeInConstructor()
{
// Arrange
var date = DateTime.Parse("2011-01-08");
var dateAsString = date.ToOADate().ToString(_cultureInfo);
LoadXmlTestData("A1", "decimal", dateAsString);
// Act
var validation = new ExcelDataValidationDateTime(_sheet, ExcelDataValidation.NewId(), "A1", ExcelDataValidationType.Decimal, _dataValidationNode, _namespaceManager);
// Assert
Assert.AreEqual(date, validation.Formula.Value);
}