poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 50271] POI will always use "M/d/yy" to format a cell when user try to format a cell to date but without specifying format exactly even my locale is set to Germany.
Date Mon, 15 Nov 2010 12:11:51 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=50271

Wu, Fan <zjuwufan@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #4 from Wu, Fan <zjuwufan@gmail.com> 2010-11-15 07:11:47 EST ---
(In reply to comment #3)
> If you want a date format that's always going to look the same no matter where
> you open it, then you need to set an explicit date format on that cell.
> Otherwise, it'll open in the default date format for the copy of excel.
> 
> If you always want d.m.yy, then explicitly set that as your cell format!
> 
> If someone was willing to figure out for each locale what excel uses as it's
> default format rules, we could possibly put in optional logic to use that, but
> that would need quite a bit of work that no-one has so far volunteered to do.


On MS excel, if no format explictly provided then it will use default format
rules. I think this feature is useful for those softwares support multilple
locales. And actually to get the default format is not complicated. We only
need one line of code to do this.

java.text.DateFormat.getDateInstance(
                         java.text.DateFormat.SHORT, aLocale);


Thank you for your patience.

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message