Bug 46184

Summary: HSSFDateUtil.isADateFormat misses some formats
Product: POI Reporter: Antti Koskimäki <antti.koskimaki>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Attachments: patch fixing isADateFormat

Description Antti Koskimäki 2008-11-11 00:04:41 UTC 
Created attachment 22853 [details]
patch fixing isADateFormat

I have POI-generated excel with dateformat "dd.mm.yyyy". 

When I open it with my my Excel 2003 and save it back to disk, the dateformat is somehow changed to be "dd\.mm\.yyyy".

HSSFDateUtils.isADateFormat does not recognize that as a date. Patch included fixes this, "\." is translated to "." just like currently "\," is translated to ",".

Patch is for HSSFDateUtils.java in r707953, but I checked that DateUtils.java in current release has the same issue.
Comment 1 Nick Burch 2008-11-12 07:31:39 UTC 
Fixed in svn