Bug 44373

Summary:	Patch for HSSFDateUtil.isADateFormat() to recognize other date(time) formats
Product:	POI	Reporter:	Miroslav <fordfrog>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	normal	Keywords:	PatchAvailable
Priority:	P2
Version:	3.0-FINAL
Target Milestone:	---
Hardware:	Other
OS:	All
Attachments:	patch for HSSFDateUtil.isADateFormat()

Description Miroslav 2008-02-07 03:50:15 UTC

Current implementation (as of 3.0.2) does not recognize correctly date formats
containing format specifiers in upper case, nor it recognizes dot as a date
separator and time format specifiers as a valid datetime format.

Attached patch adds these format specifiers to the regex.
Change: "^[ymd\\-/, ]+$" => "^[yYmMdDhHsS\\-/,. :]+$"

Comment 1 Miroslav 2008-02-07 03:51:24 UTC

Created attachment 21491 [details]
patch for HSSFDateUtil.isADateFormat()

Comment 2 Nick Burch 2008-02-07 06:02:58 UTC

Thanks for this patch, applied to trunk (along with a test)