private void ReadWorkSheet_dataValidations_ItemDecima(DataValidationDecimal dvDecima, XElement node)
{
XElement formulaNode = node.Element(XName.Get("formula1", ExcelCommon.Schema_WorkBook_Main.NamespaceName));
if (formulaNode != null)
{
DataValidationFormulaDecimal formulaValue = new DataValidationFormulaDecimal();
ReadWorkSheet_dataValidations_ItemDecima_formula(formulaNode.Value, ref formulaValue);
dvDecima.Formula = formulaValue;
}
formulaNode = node.Element(XName.Get("formula2", ExcelCommon.Schema_WorkBook_Main.NamespaceName));
if (formulaNode != null)
{
DataValidationFormulaDecimal formulaValue = new DataValidationFormulaDecimal();
ReadWorkSheet_dataValidations_ItemDecima_formula(formulaNode.Value, ref formulaValue);
dvDecima.Formula2 = formulaValue;
}
}
private void ReadWorkSheet_dataValidations_ItemDecima_formula(string value, ref DataValidationFormulaDecimal formulaValue)
{
if (!string.IsNullOrEmpty(value))
{
double dValue = default(double);
if (double.TryParse(value, NumberStyles.Any, CultureInfo.InvariantCulture, out dValue))
{
formulaValue.Value = dValue;
}
else
{
formulaValue.Formula = value;
}
}
}
internal DataValidationDecimal(string address, DataValidationType validationType)
: base(address, validationType)
{
Formula = new DataValidationFormulaDecimal();
Formula2 = new DataValidationFormulaDecimal();
}
