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