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 2007/08/16 21:48:46 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 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