Hi Jan, On Wednesday, 2007-07-04 02:03:29 +0200, Jan Sax wrote:
> But in my opinion, that reproach would implicate that OO would have to > behave better than OOXML as far as ISO 8601 is concerned. If that would be > true, I fail to understand why ISO 8601 complete extended date > representation isn't DEFAULT in all OOo general and local versions. You're mixing up two different things: ODF file format and UI representation. In ODF the date/time values _are_ stored in ISO 8601 format. How they are represented to the user depends on the locale she works in and the number (date) format assigned to display the value. > Of course, any user should be able to change CELL level format to localized > date format representation. But basically, the ONLY correct formula bar > representation should ALWAYS be according to ISO 8601 complete extended > format. Why? Most users expect to see and edit in the format they're used to, which still is their localized format. You might want to discuss this in-depth with the User Experience team though. > As should be the DEFAULT cell format in any localized OO version > BEFORE intentionally applying a localized format. For unambiguous data: the > latter only to be chosen if one is sure that ones data never would cross > national boundaries. The data is unambiguous, as stored in an unambiguous ISO 8601 format. For unambiguous display it usually is sufficient to not assign any locale specific date format, the default display format chosen then simply is that of the system the user works on or of the default locale chosen in the application under Tools -> Options -> Language Settings. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to this [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
