C# (CSharp) ExcelDataValidationInt示例

示例#1

文件： IntegerFormulaTests.cs 项目： dokkillo/EPPlusLigth

 public void IntegerFormula_FormulaValueIsSetFromXmlNodeInConstructor()
 {
     // Arrange
     LoadXmlTestData("A1", "decimal", "1");
     // Act
     var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
     Assert.AreEqual(1, validation.Formula.Value);
 }

示例#2

文件： DataValidationTests.cs 项目： acinep/epplus

 public void DataValidations_ShouldSetPromptTitleFromExistingXml()
 {
     // Arrange
     LoadXmlTestData("A1", "whole", "1", "Prompt", "PromptTitle", "Error", "ErrorTitle");
     // Act
     var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
     // Assert
     Assert.AreEqual("PromptTitle", validation.PromptTitle);
 }

示例#3

文件： DataValidationTests.cs 项目： acinep/epplus

 public void DataValidations_ShouldSetShowInputMessageFromExistingXml()
 {
     // Arrange
     LoadXmlTestData("A1", "whole", "1", false, true);
     // Act
     var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
     // Assert
     Assert.IsTrue(validation.ShowInputMessage ?? false);
 }

示例#4

文件： DataValidationTests.cs 项目： acinep/epplus

  public void DataValidations_ShouldSetOperatorFromExistingXml()
  {
      // Arrange
      LoadXmlTestData("A1", "whole", "greaterThanOrEqual", "1");
      // Act
      var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);
      // Assert
      Assert.AreEqual(ExcelDataValidationOperator.greaterThanOrEqual, validation.Operator);
 }

示例#5

        public void IntegerFormula_FormulaValueIsSetFromXmlNodeInConstructor()
        {
            // Arrange
            LoadXmlTestData("A1", "decimal", "1");
            // Act
            var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);

            Assert.AreEqual(1, validation.Formula.Value);
        }

示例#6

文件： DataValidationTests.cs 项目： zw2430/EPPlus

        public void DataValidations_ShouldSetErrorTitleFromExistingXml()
        {
            // Arrange
            LoadXmlTestData("A1", "whole", "1", "Prompt", "PromptTitle", "Error", "ErrorTitle");
            // Act
            var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);

            // Assert
            Assert.AreEqual("ErrorTitle", validation.ErrorTitle);
        }

示例#7

文件： DataValidationTests.cs 项目： zw2430/EPPlus

        public void DataValidations_ShouldSetShowInputMessageFromExistingXml()
        {
            // Arrange
            LoadXmlTestData("A1", "whole", "1", false, true);
            // Act
            var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);

            // Assert
            Assert.IsTrue(validation.ShowInputMessage ?? false);
        }

示例#8

文件： DataValidationTests.cs 项目： nxoxn/EPPlus

        public void DataValidations_ShouldSetOperatorFromExistingXml()
        {
            // Arrange
            LoadXmlTestData("A1", "whole", "greaterThanOrEqual", "1");
            // Act
            var validation = new ExcelDataValidationInt(_sheet, "A1", ExcelDataValidationType.Whole, _dataValidationNode, _namespaceManager);

            // Assert
            Assert.AreEqual(ExcelDataValidationOperator.greaterThanOrEqual, validation.Operator);
        }