You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2006/08/24 15:45:47 UTC
DO NOT REPLY [Bug 40128] - HSSFDateUtil.isCellDateFormatted(cell) returns false when the cell is formatted as a date
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=40128>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40128
------- Additional Comments From indra@feeddex.nl 2006-08-24 13:45 -------
I believe also the value 164 (equals 0xA4 i think?) should be added to this list.
In my OpenOffice browser it shows up in the format
dd-MM-yyyy
while the double value is something like 38898.0
After adding this value to the accepted list, I could get the proper date
of this value as
30-6-2006 (In a dd-MM-yyyy format :).
What is the definitive word on this issue? Should the
// Internal Date Formats as described on page 427 in
// Microsoft Excel Dev's Kit...
comment be read as
// Some of the Internal Date Formats as described on page 427 in
// Microsoft Excel Dev's Kit...
If you come across a complete list (or the correct version of the
isInternalDateFormat function) please mail it to me at
indra@feeddex.nl
For now, I just add some additional constants when I encounter them...
Maybe we can ask the guys from OpenOffice since they apparently know how to do
it. (Version 2.0)
Isn't that program open source as well? I'll look it up there...(In reply to
comment #2)
> Created an attachment (id=18660)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=18660&action=view) [edit]
> The excel sheet with dates formatted to each excel date format.
>
> I have attached a spreadsheet with the 17 date formats that excel currently
> uses.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/