/**
* Sees if the extended formatting record at the specified position
* represents a date. First checks against the built in formats, and
* then checks against the hash map of FormatRecords
*
* @param pos the xf format index
* @return TRUE if this format index is formatted as a Date
*/
public bool isDate(int pos)
{
XFRecord xfr = (XFRecord)xfRecords[pos];
if (xfr.isDate())
{
return(true);
}
if (!formats.ContainsKey(xfr.getFormatRecord()))
{
return(false);
}
FormatRecord fmt = formats[xfr.getFormatRecord()] as FormatRecord;
if (fmt == null)
{
return(false);
}
return(fmt.isDate());
}
/**
* Gets the DateFormat used to format the cell.
*
* @param pos the xf format index
* @return the DateFormat object used to format the date in the original
* excel cell
*/
public CSharpJExcel.Interop.DateFormat getDateFormat(int pos)
{
XFRecord xfr = (XFRecord)xfRecords[pos];
if (xfr.isDate())
{
return(xfr.getDateFormat());
}
if (!formats.ContainsKey(xfr.getFormatRecord()))
{
return(null);
}
FormatRecord fr = formats[xfr.getFormatRecord()] as FormatRecord;
if (fr == null)
{
return(null);
}
return(fr.isDate() ? fr.getDateFormat() : null);
}