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, 16 Aug 2007 19:48:46 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 dannynip@gmail.com  2007-08-16 12:48 -------
I was trying out the proposed code below,
 
Proposed patch of HSSFUtil.Java patch 2006-10-13 10:14 10.19 KB Edit
 
And it failed when I used the default format of:
12/31/06 (English US)
31/12/06 (English Canada)
 
I fixed this by adding
 
case 0xa5:
 
Note, I did save my .xls (97/2000/XP) Spreadsheet in OpenOffice in Vista.
Also I have not read the Microsoft SDK, I just did a
HSSFCellStyle.getDataFormat() to find the hex value.

PS. vote for this bug!!!

-- 
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