date cell as date type instead of custom type

[Shuli Zhou/schedule]

Hi,

We use the package to generate Excel files. When loading the generated files
in Excel, all date cells have custom format not date format. Even if they
look exactly the same in Excel, we have problems later using another
software to read those date cells. That software expects them to be of date
type not custom type. Is there a way to make date cell as date type using
POI?

Here is the how the cell style is set:
        short formatIx = this.dataFormat.getFormat(desc.format);
      s.setDataFormat(formatIx);

this.dataFormat is of HSSFDataFormat
s is of HSSFCellStyle.

Thanks.
Shirley

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/