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: [email protected]
Reporter: [email protected]
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.
