You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/06/05 13:28:23 UTC
[Bug 55063] New: Can not use "/" as delimiter for date in german
excel
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
[Bug 55063] Can not use "/" as delimiter for date in german excel
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55063
--- Comment #2 from Michael <mi...@parcit.de> ---
Oh sorry,
if i have a look at the custom format for the cell in Excel the '/' is replaced
by a '.'.
If i set cellStyle.setDataFormat(dataFormat.getFormat("MM//DD//YYYY")) then i
get MM..TT..JJJJ.
In Excel i can set the format MM/TT/JJJJ.
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
[Bug 55063] Can not use "/" as delimiter for date in german excel
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55063
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Can you clarify what "didn't work" means? Did you get an error? Something else?
--
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