internal void ReadXml(XElement node)
{
foreach (XElement element in node.Elements())
{
if (element.Name.LocalName == "numRef")
{
string childElementValue = element.GetChildElementValue("f");
if (!string.IsNullOrWhiteSpace(childElementValue))
{
this.ReferenceFormula = childElementValue;
if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
{
this.ReferenceFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.ReferenceFormula, 0, 0);
}
}
foreach (XElement element2 in element.Elements())
{
if (element2.Name.LocalName == "numCache")
{
this.numberReferenceFormat = element2.GetChildElementValue("formatCode");
}
}
}
else if (element.Name.LocalName == "numLit")
{
NumericDataLiterals literals = new NumericDataLiterals();
literals.ReadXml(element);
this.NumericLiterals = literals;
}
}
}
internal void ReadXml(XElement element)
{
foreach (XElement element2 in element.Elements())
{
if (element2.Name.LocalName == "numRef")
{
this.NumberReferencesFormula = element2.GetChildElementValue("f");
if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
{
this.NumberReferencesFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.NumberReferencesFormula, 0, 0);
}
foreach (XElement element3 in element2.Elements())
{
if (element3.Name.LocalName == "numCache")
{
this.numberReferenceFormat = element3.GetChildElementValue("formatCode");
}
}
}
else if (element2.Name.LocalName == "numLit")
{
if (element2.HasElements)
{
NumericDataLiterals literals = new NumericDataLiterals();
literals.ReadXml(element2);
this.NumericLiterals = literals;
}
}
else if (element2.Name.LocalName == "strRef")
{
this.StringReferencedFormula = element2.GetChildElementValue("f");
if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
{
this.StringReferencedFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.StringReferencedFormula, 0, 0);
}
}
else if (element2.Name.LocalName == "strLit")
{
if (element2.HasElements)
{
StringLiteralData data = new StringLiteralData();
data.ReadXml(element2);
this.StringLiterals = data;
}
}
else if (element2.Name.LocalName == "multiLvlStrRef")
{
this.MultiLevelStringReferenceFormula = element2.GetChildElementValue("f");
if (ParsingContext.ReferenceStyle == ExcelReferenceStyle.R1C1)
{
this.MultiLevelStringReferenceFormula = ParsingContext.ConvertA1FormulaToR1C1Formula(this.MultiLevelStringReferenceFormula, 0, 0);
}
}
}
}