Hello all, Thanks for following up.
A quick recap: I was looking for the YYYY.MM.DD format. The user inputs it as it looks, e.g. 2015.01.01. (LibreOffice Calc should recognise it as a date.) Here: Tools -> Options -> Language Settings -> Languages -> Date acceptance patterns I don't know how this should be set. I tried YYYY.MM.DD. This did not work. (with the semicolon) I tried Y.M.D. This worked. (with the semicolon) Here: Format -> Cells -> Numbers -> Format code I must use YYYY.MM.DD, not Y.M.D. What led to this inconsistent format? I am interested in the technical reasons behind. I think that it will be consistent if a user is allowed to type the same YYYY.MM.DD format code in both places to get what she or he wants. Best wishes, C. H. D. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
