Hi :) Sounds like a good fail-safe, so that users are not bound by rigid restrictions but the displayed figures are always consistently correct.
I suspect that you can even enter much shorter numbers for dates within the year, such as; 12.31 getting corrected to; 2014.12.31 I'm not sure if you can also drop the month, if it's within the same month, and just type 31 to get the same result but even a little less typing can make a difference. Regards from Tom :) On 28 December 2014 at 04:43, Brian Barker <b.m.bar...@btinternet.com> wrote: > At 02:29 28/12/2014 +0000, Conly Honly Donly wrote: > >> 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. >> > > I'm guessing here, but surely there are different requirements in the two > places? In the cell formatting, you are indicating exactly the format you > require - so you are choosing the year to appear as YYYY, not YY, for > example. But the acceptance pattern is more general: you are merely showing > that you want year-dot-month-dot-day to be a format automatically > interpreted as a date. With Y.M.D as an acceptance pattern, can you not > enter the forthcoming New Year's Day (for example) as 2015.01.01, 2015.1.1, > 15.01.01, and many other forms - but have all interpreted correctly and > displayed in the cell itself in the cell's format - as 2015.01.01 in your > case? > > I trust this helps. > > Brian Barker > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > 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 > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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
