Created attachment 102348 [details] Conflicting results in spite of Preference settings. I cannot change the date format to conform with the country I am living in. I work in English in Spain where they use the D/M/Y format. I have tried everything suggested by members of the forum and nothing results. There seems to be a general opinion that this is because the date format is based on the language indicated in Language settings in preference. In my case, I have set the language of the user interface as English (USA) and my locale setting as Spanish (Spain). In the date acceptance patterns I have changed it to D/M/Y;D/M but this seems to have no effect on the behavior of the program. When I am working on a document and use insert>date it continues to come up M/D/Y. When I right click on this date to edit fields, the option to change it to DD.MM.YY is not even available. However I did change it ot D.MMMM.YYYY and it works only for that specific date. Not what I want because when I go back into the document and insert another date, it continues to come up M/D/Y. This is very annoying for those of us English users living in European countries because we have to manually change every date reference individually. I have attached three screenshots showing 1. How I have my language settings configured. 2. the option box that comes up when I right click on a date. and 3. the result when I do an Insert>Field>date in spite of having changed it in Preferences.
Comment on attachment 102348 [details] Conflicting results in spite of Preference settings. Related forum thread: http://en.libreofficeforum.org/node/8514 The default date format (Insert > Fields > Date) appears to be set by the document language e.g., "English (USA)" produces MM/DD/YY while "English (Australia)" produces DD/MM/YY. Insert > Fields > Other… > Variables tab > Type of “User field” > Format of “Additional formats…” can be used to specify a required date format. This report suggests that for the MacOS version of LO indicated even this manual override is not working i.e., the same default format is used. I have not tested this under MacOS, but under GNU/Linux it works as expected.
Summary edited for clarity.
I don't see this in my master build of LO4.4.0 LO language settings: Interface : default English USA Locale setting : default French Date acceptance patterns : D/M/Y;D/M;D.M.Y;D-M-Y Default languages for documents : default Western French (France) Test default date field insert in Writer : 30/09/14
(In reply to comment #3) > I don't see this in my master build of LO4.4.0 > > LO language settings: > Interface : default English USA > Locale setting : default French > Date acceptance patterns : D/M/Y;D/M;D.M.Y;D-M-Y > Default languages for documents : default Western French (France) > > Test default date field insert in Writer : 30/09/14 OSX 10.9.5
@Richard : what are your OSX system locale settings ?
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.