poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 40128] - HSSFDateUtil.isCellDateFormatted(cell) returns false when the cell is formatted as a date
Date Thu, 24 Aug 2006 13:45:47 GMT
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/


Mime
View raw message