poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55063] New: Can not use "/" as delimiter for date in german excel
Date Wed, 05 Jun 2013 11:28:23 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=55063

            Bug ID: 55063
           Summary: Can not use "/" as delimiter for date in german excel
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: michael.kornatzki@parcit.de

Hi,

i tried to set a '/' as a delimiter for a date field in a german excel (2003)
without success.

I can set any other char (also some nonsense like '+') but i didn't get it to
work with '/';

this works: 
- cellStyle.setDataFormat(dataFormat.getFormat("MM-DD-YYYY"));
- cellStyle.setDataFormat(dataFormat.getFormat("DD-MM-YYYY"));
- cellStyle.setDataFormat(dataFormat.getFormat("MM+DD+YYYY"));

and this didn't work:
- cellStyle.setDataFormat(dataFormat.getFormat("MM/DD/YYYY"));

cheers, michael

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message