[Libreoffice-bugs] [Bug 144377] Dates are not correctly auto-extrapolated if exclude days

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Sep 8 12:30:14 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=144377

--- Comment #4 from Mike Kaganski <mikekaganski at hotmail.com> ---
But if you want to *enter* dates using such a notation, you need to tweak *date
acceptance patterns* at Options->Language Settings->Languages [1]. There you
may specify a Y-M pattern, and then when you enter 2019-01, Calc will convert
it to 2019-01-01 (implicitly adding the minimal value of the missing element).
Then the resulting *proper date* in the cell may be displayed according to the
format that you choose.

[1]
https://help.libreoffice.org/7.2/en-US/text/shared/optionen/01140000.html?DbPAR=CALC#bm_id9471429

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210908/6efe87de/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list