Bug 15482 - HSSFDateUtil.isCellDateFormatted fails with German date pattern
Summary: HSSFDateUtil.isCellDateFormatted fails with German date pattern
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: Other other
: P3 minor (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-12-18 14:04 UTC by Holger Schulz
Modified: 2004-11-16 19:05 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Holger Schulz 2002-12-18 14:04:06 UTC

I tried this function on a standard Excel German date style ("14.4.1998").
This style has got the style id 164 wich will not be recognized as a date.

I don't know how to solve this general problem but the javadoc of this function 
should explain that "false" can mean "unknown date style" too.

Greetings from Germany


P.S. Source: jakarta-poi-1.8.0-dev-src.tar.gz
Comment 1 Avik Sengupta 2002-12-25 17:48:51 UTC
Strange .. 164 (0xA4) is indeed in the list of valid date formats. (see
isInternalDateFormat(int) in HSSFDateUtil. So a cell formatted as such SHOULD
return true to isCellDateFormatted. Maybe some of the other checks in
isCellDateFormatted is failing. Could you please investigate further? Maybe try
out one by one all the checks in the code on your cell?
Comment 2 Andy Oliver 2003-07-24 14:06:45 UTC
requested information not given