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 Tue, 06 Nov 2007 12:35:09 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 nick@torchbox.com  2007-11-06 04:35 -------
(In reply to comment #18)
> POI should detect all formats that are dates,
> custom, localized, standard, everything.

Please feel free to suggest a patch to do this. Unfortunately, excel doesn't
actually store dates as such. Instead, it just stores a number, then uses the
formatting rules to decide if it's really a number or a date. It sucks, but
that's just what they did.

For the standard date formats, everything is easy. For custom date formats, we
have to try and spot if the formatting rules seem to be numeric, or date based,
and guess from that.

Patches to allow POI to detect other date formats are gladly received :)

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message