Exemplo n.º 1
0
        /**
         * Constructor which Initializes the cell range on which this object will be
         * applied
         * @param constraint 
         */
        public HSSFDataValidation(CellRangeAddressList regions, IDataValidationConstraint constraint)
        {
            _regions = regions;

            //FIXME: This cast can be avoided.
            _constraint = (DVConstraint)constraint;
        }
Exemplo n.º 2
0
        /**
         * Constructor which Initializes the cell range on which this object will be
         * applied
         * @param constraint
         */
        public HSSFDataValidation(CellRangeAddressList regions, IDataValidationConstraint constraint)
        {
            _regions = regions;

            //FIXME: This cast can be avoided.
            _constraint = (DVConstraint)constraint;
        }
Exemplo n.º 3
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateNumericConstraint
  * (int, java.lang.String, java.lang.String)
  */
 public IDataValidationConstraint CreateDecimalConstraint(int operatorType, String formula1, String formula2)
 {
     return(DVConstraint.CreateNumericConstraint(ValidationType.DECIMAL, operatorType, formula1, formula2));
 }
Exemplo n.º 4
0
 public IDataValidationConstraint CreateintConstraint(int operatorType, String formula1, String formula2)
 {
     return(DVConstraint.CreateNumericConstraint(ValidationType.INTEGER, operatorType, formula1, formula2));
 }
Exemplo n.º 5
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateFormulaListConstraint
  * (java.lang.String)
  */
 public IDataValidationConstraint CreateFormulaListConstraint(String listFormula)
 {
     return(DVConstraint.CreateFormulaListConstraint(listFormula));
 }
Exemplo n.º 6
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateExplicitListConstraint
  * (java.lang.String[])
  */
 public IDataValidationConstraint CreateExplicitListConstraint(String[] listOfValues)
 {
     return(DVConstraint.CreateExplicitListConstraint(listOfValues));
 }
Exemplo n.º 7
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateDateConstraint
  * (int, java.lang.String, java.lang.String, java.lang.String)
  */
 public IDataValidationConstraint CreateDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)
 {
     return(DVConstraint.CreateDateConstraint(operatorType, formula1, formula2, dateFormat));
 }
Exemplo n.º 8
0
 public IDataValidationConstraint CreateCustomConstraint(String formula)
 {
     return(DVConstraint.CreateCustomFormulaConstraint(formula));
 }
Exemplo n.º 9
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateTimeConstraint
  * (int, java.lang.String, java.lang.String, java.lang.String)
  */
 public IDataValidationConstraint CreateTimeConstraint(int operatorType, String formula1, String formula2)
 {
     return(DVConstraint.CreateTimeConstraint(operatorType, formula1, formula2));
 }
Exemplo n.º 10
0
 /*
  * (non-Javadoc)
  *
  * @see
  * NPOI.SS.UserModel.DataValidationHelper#CreateTextLengthConstraint
  * (int, java.lang.String, java.lang.String)
  */
 public IDataValidationConstraint CreateTextLengthConstraint(int operatorType, String formula1, String formula2)
 {
     return(DVConstraint.CreateNumericConstraint(ValidationType.TEXT_LENGTH, operatorType, formula1, formula2));
 }
Exemplo n.º 11
0
 /**
  * Constructor which initializes the cell range on which this object will be
  * applied
  * @param constraint
  */
 public HSSFDataValidation(CellRangeAddressList regions, DVConstraint constraint)
 {
     _regions    = regions;
     _constraint = constraint;
 }
Exemplo n.º 12
0
 /**
  * Constructor which initializes the cell range on which this object will be
  * applied
  * @param constraint
  */
 public HSSFDataValidation(CellRangeAddressList regions, DVConstraint constraint)
 {
     _regions = regions;
     _constraint = constraint;
 }
Exemplo n.º 13
0
 private static HSSFDataValidation DisplayMsg(CellRangeAddressList region,
     DVConstraint constraint, string errorMsg)
 {
     HSSFDataValidation dataValidate = new HSSFDataValidation(region, constraint);
     dataValidate.CreateErrorBox("error", errorMsg);
     return dataValidate;
 }