https://issues.apache.org/bugzilla/show_bug.cgi?id=46184

           Summary: HSSFDateUtil.isADateFormat misses some formats
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: [email protected]
        ReportedBy: [EMAIL PROTECTED]


Created an attachment (id=22853)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=22853)
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 ( 
https://svn.apache.org/viewcvs.cgi?view=rev&rev=707953 ), but I checked that 
DateUtils.java
in current release has the same issue.


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to