コード例 #1
0
 private void ReadWorkSheet_dataValidations_ItemInt_formula(string value, ref DataValidationFormulaInt formulaValue)
 {
     if (!string.IsNullOrEmpty(value))
     {
         int intValue = default(int);
         if (int.TryParse(value, out intValue))
         {
             formulaValue.Value = intValue;
         }
         else
         {
             formulaValue.Formula = value;
         }
     }
 }
コード例 #2
0
 internal DataValidationInt(string address, DataValidationType validationType)
     : base(address, validationType)
 {
     Formula  = new DataValidationFormulaInt();
     Formula2 = new DataValidationFormulaInt();
 }
コード例 #3
0
        private void ReadWorkSheet_dataValidations_ItemInt(DataValidationInt dvint, XElement node)
        {
            XElement formulaNode = node.Element(XName.Get("formula1", ExcelCommon.Schema_WorkBook_Main.NamespaceName));
            if (formulaNode != null)
            {
                DataValidationFormulaInt formulaValue = new DataValidationFormulaInt();
                ReadWorkSheet_dataValidations_ItemInt_formula(formulaNode.Value, ref formulaValue);
                dvint.Formula = formulaValue;
            }

            formulaNode = node.Element(XName.Get("formula2", ExcelCommon.Schema_WorkBook_Main.NamespaceName));
            if (formulaNode != null)
            {
                DataValidationFormulaInt formulaValue = new DataValidationFormulaInt();
                ReadWorkSheet_dataValidations_ItemInt_formula(formulaNode.Value, ref formulaValue);
                dvint.Formula2 = formulaValue;
            }
        }