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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144377
           Summary: Dates are not correctly auto-extrapolated if exclude
                    days
           Product: LibreOffice
           Version: 7.1.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: buggymcbug at bobmail.info

Created attachment 174887
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174887&action=edit
File with date set rows demonstrating the issue.

The auto-extrapolation of months doesn't work if days are excluded.


If you have a row of fields with dates that exclude:

2019-10
2019-11
2019-12

etc, and you set the date field to ISO 8601, when you ask Calc to guess the
next field, it brings up:

2019-13
2019-14
etc

It's subjective if that's a date given technically ISO 8601 requires the day as
well.

However, if I then do the same thing but specify the field type as user
customised: YYYY-MM - you get the exact same behaviour:
2019-13
2019-14
etc


Expected in both cases is:
2020-01
2020-02
etc

-- 
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/9d8ce7bd/attachment-0001.htm>