Bug 46184 - HSSFDateUtil.isADateFormat misses some formats
Summary: HSSFDateUtil.isADateFormat misses some formats
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2008-11-11 00:04 UTC by Antti Koskimäki
Modified: 2008-11-12 07:31 UTC (History)
0 users

patch fixing isADateFormat (561 bytes, patch)
2008-11-11 00:04 UTC, Antti Koskimäki
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
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