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; } } }
internal DataValidationInt(string address, DataValidationType validationType) : base(address, validationType) { Formula = new DataValidationFormulaInt(); Formula2 = new DataValidationFormulaInt(); }
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; } }