public static object GetFormatValue(CellFormatType type, string value)
{
if (type.Equals(CellFormatType.None))
{
int iVal;
double dVal;
if (int.TryParse(value, out iVal))
{
return(iVal);
}
else if (double.TryParse(value, out dVal))
{
return(dVal);
}
}
else if (type.Equals(CellFormatType.IntPercent) || type.Equals(CellFormatType.FloatPercent))
{
double d = 0;
if (double.TryParse(value.TrimEnd('%'), out d))
{
return(d / 100);
}
}
return(value);
}
public RTCell(XmlNode parent)
{
XmlElement ele = (XmlElement)parent;
if (ele.HasAttribute("value"))
{
this.value = parent.Attributes["value"].Value;
}
if (parent.HasChildNodes && this.value == null)
{
value = parent.FirstChild.Value;
}
if (ele.HasAttribute("format"))
{
this.cellFormatType = (CellFormatType)int.Parse(parent.Attributes["format"].Value);
this.cellFormatString = CellFormat.GetFormatString(this.cellFormatType);
}
if (ele.HasAttribute("bgcolor"))
{
try
{
this.backgroundColorString = parent.Attributes["bgcolor"].Value.TrimStart('#');
this.backgroundColor = ColorTranslator.FromHtml("#" + this.backgroundColorString);
}
catch {
this.backgroundColorString = null;
}
}
}
public static string GetFormatString(CellFormatType type)
{
switch (type)
{
case CellFormatType.IntPercent:
return("##0%");
case CellFormatType.FloatPercent:
return("##0.0##%");
}
return(null);
}
public CellFormat(CellFormatType type, string fmt)
{
formatType = type;
formatString = fmt;
}
public CellFormat(CellFormatType type, string fmt)
{
this.formatType = type;
this.formatString = fmt;
}
public CellFormat(CellFormatType type, string fmt)
{
formatType = type;
formatString = fmt;
}
