Bug 80993 - Default date format under MacOS does not respect document language
Summary: Default date format under MacOS does not respect document language
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Libreoffice (show other bugs)
Version: 4.2.5.2 release
Hardware: Other Mac OS X (All)
: medium major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-07 07:09 UTC by richard
Modified: 2014-10-06 16:31 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Conflicting results in spite of Preference settings. (256.72 KB, application/pdf)
2014-07-07 07:09 UTC, richard
Details

Description richard 2014-07-07 07:09:04 UTC
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 1 Owen Genat 2014-07-08 01:57:51 UTC
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.
Comment 2 Owen Genat 2014-07-13 08:01:27 UTC
Summary edited for clarity.
Comment 3 Alex Thurgood 2014-09-30 15:48:21 UTC
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
Comment 4 Alex Thurgood 2014-09-30 15:48:53 UTC
(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
Comment 5 Alex Thurgood 2014-10-06 16:30:51 UTC
@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.