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
|