poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shuli Zhou/schedule <shuli.z...@Barra.COM>
Subject date cell as date type instead of custom type
Date Wed, 21 Sep 2005 23:50:07 GMT
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message