public DateRecord(NumberCell num,
    int xfi,
    FormattingRecords fr,
    boolean nf,
    SheetImpl si) 
{
  
    row = num.getRow();
    column = num.getColumn();
    xfIndex = xfi;
    formattingRecords = fr;
    sheet = si;
    initialized = false;
    format = formattingRecords.getDateFormat(xfIndex);
    // This value represents the number of days since 01 Jan 1900
    double numValue = num.getValue();
    if (Math.abs(numValue) <  1)
    {
      if (format == null)
      {
        format = timeFormat;
      }
      time = true;
    }
    else
    {
      if (format == null)
      {
        format = dateFormat;
      }
      time = false;
    }
    // Work round a bug in excel.  Excel seems to think there is a date
    // called the 29th Feb, 1900 - but in actual fact this was not a leap year.
    // Therefore for values less than 61 in the 1900 date system,
    // add one to the numeric value
    if (!nf && !time && numValue <  nonLeapDay)
    {
      numValue += 1;
    }
    // Get rid of any timezone adjustments - we are not interested
    // in automatic adjustments
    format.setTimeZone(gmtZone);
    // Convert this to the number of days since 01 Jan 1970
    int offsetDays = nf ? utcOffsetDays1904 : utcOffsetDays;
    double utcDays = numValue - offsetDays;
    // Convert this into utc by multiplying by the number of milliseconds
    // in a day.  Use the round function prior to ms conversion due
    // to a rounding feature of Excel (contributed by Jurgen
    long utcValue = Math.round(utcDays * secondsInADay) * msInASecond;
    date = new Date(utcValue);
}

Constructs this object from the raw data

Parameters:

num - the numerical representation of this

xfi - the java equivalent of the excel date format

fr - the formatting records

nf - flag indicating whether we are using the 1904 date system

si - the sheet

 public CellFeatures getCellFeatures() 
{
    return features;
}

Accessor for the cell features

 public CellFormat getCellFormat() 
{
    if (!initialized)
    {
      cellFormat = formattingRecords.getXFRecord(xfIndex);
      initialized = true;
    }
    return cellFormat;
}

Gets the CellFormat object for this cell. Used by the WritableWorkbook API

 public final int getColumn() 
{
    return column;
}

Interface method which returns the column number of this cell

 public String getContents() 
{
    return format.format(date);
}

Gets the cell contents as a string. This method will use the java equivalent of the excel formatting string

 public Date getDate() 
{
    return date;
}

Gets the date

 public DateFormat getDateFormat() 
{
    Assert.verify(format != null);
    return format;
}

Gets the DateFormat used to format the cell. This will normally be the format specified in the excel spreadsheet, but in the event of any difficulty parsing this, it will revert to the default date/time format.

 public final int getRow() 
{
    return row;
}

Interface method which returns the row number of this cell

 protected final SheetImpl getSheet() 
{
    return sheet;
}

Accessor for the sheet

 public CellType getType() 
{
    return CellType.DATE;
}

Accessor for the cell type

 public boolean isHidden() 
{
    ColumnInfoRecord cir = sheet.getColumnInfo(column);
    if (cir != null && cir.getWidth() == 0)
    {
      return true;
    }
    RowRecord rr = sheet.getRowInfo(row);
    if (rr != null && (rr.getRowHeight() == 0 || rr.isCollapsed()))
    {
      return true;
    }
    return false;
}

Determines whether or not this cell has been hidden

 public boolean isTime() 
{
    return time;
}

Indicates whether the date value contained in this cell refers to a date, or merely a time

 public  void setCellFeatures(CellFeatures cf) 
{
    features = cf;
}

Sets the cell features