Bug 46184 - HSSFDateUtil.isADateFormat misses some formats
Summary: HSSFDateUtil.isADateFormat misses some formats
Status: RESOLVED FIXED
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
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-11 00:04 UTC by Antti Koskimäki
Modified: 2008-11-12 07:31 UTC (History)
0 users


Attachments
patch fixing isADateFormat (561 bytes, patch)
2008-11-11 00:04 UTC, Antti Koskimäki 		Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

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