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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to buggymcbug from comment #0)
> 2019-10
> etc, and you set the date field to ISO 8601
> It's subjective if that's a date given technically ISO 8601 requires the day
> as well.

No it is not "subjective", it is objectively *not* a date. What you enter is
just a text with come numeric characters separated by a dash; this text can't
be converted to a date, and as such it is kept as text in any cell, no matter
how you *format* it. You may e.g. check that the cell in fact contains the
text, using View->Value Highlighting (Ctrl+F8).

For such a text, the only thing that Calc is able to do when drag-copying is to
notice that the string ends with some contiguous run of numeric characters; and
treat those characters the same way as it would e.g. for "value-01",
"value-02", ....

Closing NOTABUG. There's no "date without day" thing in Calc.

-- 
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/619f2eb4/attachment.htm>