On 12/22/2009 12:49 AM, Andreas Saeger wrote: > 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.
<quote Dotan> Please, please, this is killing me. $ date +%x 2009-12-08 However, Calc insists on using the mm/dd/yy year format in new documents. The settings under Language are all Default. What must I do to have OOo respect the locale settings? </quote Dotan> <quote Dotan> To do this, I must set the entire spreadsheet as Date format, which many (most) columns are unlikely to be when I create a document. That is the reason that I discard this workaround. If there is a way to set all _date_ cells as yyyy-mm-dd without setting any cells as date, then I would appreciate very much instructions on how to do this. </quote Dotan> <quote NoOp> So, set up Tools|Options|Lang...|Languages|Locale Setting|Swedish (Sweden) and adjust the *Decimal*, Currency, Language, etc for your liking. </quote NoOp> Emphasis added to "adjust the *Decimal*". Does this not work for you? Works for me. Here, let me explain how to "adjust the Decimal": Tools|Options|Language Settings|Languages|Decimal separtor key|unchceck: Same as locale setting (,). When you do that, you get dotted separator. <snip> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
