2009/1/9 Erling Larsen <[email protected]> > Uwe Fischer skrev: > >> Hi, >> >> On 01/09/09 11:44, Dotan Cohen wrote: >> >>> In OOo 2.4 I managed to disable automatic number to date conversion. I >>> cannot for the life of me find out how in OOo 3.0, and from searching >>> the web it seems that this cannot be done?!? >>> >>> I do _not_ want to create a default template. I want to configure Calc >>> so that I can open a document, enter "8.5" into a cell, and not have >>> it turned into a date or anything else. I repeat that for this use >>> case a new default template is _not_ the answer, and neither is >>> defining each cell as text. >>> >>> Thanks. >>> >>> >> please have a look at the OpenOffice.org Tips 'n' Tricks blog. There are >> some tips titled "Fighting Automatic Replacements in Calc". >> http://blogs.sun.com/oootnt/entry/fighting_automatic_replacements_in_calc >> >> Uwe >> ------------------------------------------------------------------------ > > <snip>
I'm using OOo 3.0 on Vista and get the same result. The solution (for me) is > to use , (comma) instead of . (dot) as it is standard in swedish. > > You can change this under language in under Tool - Alternative by ticking / > unticking decimalpoint. > > Erling Larsen Erling, running the Swedish version of OOo 3.0.0 on 64-bit Ubuntu Intrepid, I find that no matter whether the alternative to represent the decimal symbol as is done in the standard language (in Swedish, as you mention, a comma) is ticked or not, «8.5» entered into a given cell in Calc is automatically transformed to «09-08-05» when I click in another cell. Aside from the fact that we use different OS, another difference may be that I have enabled Asian languages in OOo.... Henri
