2009/12/22 Andreas Saeger <[email protected]>: > NoOp wrote: > >> I did find that if I set the Default style (in OOo Calc) to Swedish >> (Sweden) and then the Date format to YYYY-MM-DD, the numbers displayed >> in the cell and in the formula bar are 2009-12-13. So that may be worth >> experimenting with also. > > Hi, > Allow me to abstract the discussion beteen Dotan and me. > Dotan would like to see dotted decimals with ISO-dates because he always > sees US dates by default. As far as I know, there is no such locale > availlable. Swedes use comma decimals.
Correct up to here. > With application locale "Hebrew" he should never see US-style dates except > explicitly formatted ones. Application locale "Default" defaults to the OOo > locale that comes as close as possible to evironment variable $LANG (Linux), > disregarding all the other environment settings. If $LANG is unset or > invalid when OOo starts up, then (and only then) everything falls back to US > English Therefore the logical conclusion is that my $LANG is unset or invalid. karm...@kubuntu:~$ cat .bin/ooc #!/bin/bash # Shortcut to OOo Calc, to save keystrokes in KDE's Alt-F2 dialog. #openoffice.org3 -calc soffice -calc karm...@kubuntu:~$ locale LANG=he_IL.utf8 LANGUAGE= LC_CTYPE="he_IL.utf8" LC_NUMERIC="he_IL.utf8" LC_TIME=en_DK.utf8 LC_COLLATE="he_IL.utf8" LC_MONETARY="he_IL.utf8" LC_MESSAGES="he_IL.utf8" LC_PAPER="he_IL.utf8" LC_NAME="he_IL.utf8" LC_ADDRESS="he_IL.utf8" LC_TELEPHONE="he_IL.utf8" LC_MEASUREMENT="he_IL.utf8" LC_IDENTIFICATION="he_IL.utf8" LC_ALL= karm...@kubuntu:~$ date +'%x - %X' 2010-01-01 - 15:05:54 karm...@kubuntu:~$ > (but app locale "Hebrew" should fix that anyway as far as OOo is > concerned). Setting the app locale as Hebrew gives dd/mm/yy dates, which nobody I know uses. I have never seen a two-digit date used ever in Hebrew or in an Israeli context. > Then he claims that Excel automagically formats yyyy-mm-dd input. I doubt > that, but I can not test with a recent version of it. > As per the installs at my university. They may be configured to do that. This is on both MSO 2003 and MSO 2007 in different computer labs and libraries at the university. > A common background of the that claim is that Excel allows to work with > literal strings as if they were numbers. Many (most?) Excel users do not > even know the difference between a numeric value and the equally looking > string. They format everything with centered orientation, sometimes worrying > about the strange sort order. Only in very rare cases a co-worker notices > wrong caclulations in the same file, using the same Excel version due to a > different locale. > I know the difference. > OOo 3.2 will be shipped with a better implementation of that text-number > magic. It will return #VALUE in most cases unless the numeric text is > unambiguous, which is only the case with ISO dates and integers. > http://development.openoffice.org/releases/3.2.0rc1.html ("Calculate with > strings"). > I will have to look at this to determine if different really is better here. As Torvalds says, old bugs are preferable to new bugs. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
