https://issues.apache.org/bugzilla/show_bug.cgi?id=50271
Wu, Fan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #4 from Wu, Fan <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
