/**
* Standard equals method. This compares the contents of two
* format records, and not their indexCodes, which are ignored
*
* @param o the object to compare
* @return TRUE if the two objects are equal, FALSE otherwise
*/
public override bool Equals(object o)
{
if (o == this)
{
return(true);
}
if (!(o is FormatRecord))
{
return(false);
}
FormatRecord fr = (FormatRecord)o;
// Initialized format comparison
if (initialized && fr.initialized)
{
// Must be either a number or a date format
if (date != fr.date ||
number != fr.number)
{
return(false);
}
return(formatString.Equals(fr.formatString));
}
// Uninitialized format comparison
return(formatString.Equals(fr.formatString));
}
/**
* Copy constructor - can be invoked by public access
*
* @param fr the format to copy
*/
public FormatRecord(FormatRecord fr)
: base(Type.FORMAT)
{
initialized = false;
formatString = fr.formatString;
date = fr.date;
number = fr.number;
// format = (java.text.Format) fr.format.clone();
}
/**
* 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 NumberFormat 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.NumberFormat getNumberFormat(int pos)
{
XFRecord xfr = (XFRecord)xfRecords[pos];
if (xfr.isNumber())
{
return(xfr.getNumberFormat());
}
if (!formats.ContainsKey(xfr.getFormatRecord()))
{
return(null);
}
FormatRecord fr = formats[xfr.getFormatRecord()] as FormatRecord;
if (fr == null)
{
return(null);
}
return(fr.isNumber() ? fr.getNumberFormat() : null);
}