autofill date increase by a day seems broken in 6.4.3

[agrayray]

Hello,

I just upgraded to LibreOffice Calc 6.4.3.2 and can not seem to be able to figure out a way to increase date columns by a one day at a time anymore using autofill. Autofill used to automatic increase by a one day for a given a date value, now default seems to increase by month…if I select more than one column seems to autofill repeating the series of columns selected increasing the series by month or by year, but no increases by one day anymore at all…all in all no way to simply increase by a day using autofill …which means I am stuck manually entering a years worth of dates just to get the dates I need now…

is this a bug or a new way of doing this that I can not seem to figure out?

Thanks in advance!

PS - Seems all LibreOffice versions
Version: 5.1.6.2 thru Version: 6.4.2.2 increase by one day using autofill for dates, so this change seems to have happened since 6.4.2.2

PS2 - Running Libre Office default version on Ubuntu 20 (which is 6.4.3.2) so this bug seems to possibly effect all Calc users running Ubuntu 20.

PS3 - An autofill of dates:

05/10/20
05/11/20
05/12/20

produces:

05/01/21
05/02/21
05/03/21
05/04/21
05/05/21
05/06/21
05/07/21
05/08/21
05/09/21
05/10/21
05/11/21
05/12/21
05/01/22
05/02/22
05/03/22
05/04/22
05/05/22
05/06/22
05/07/22
05/08/22
05/09/22
05/10/22
05/11/22
05/12/22
…

(very weird) ???

[robleyd]

What a wonderful example of why a standard date format should be used globally! Those numbers could mean anything depending on your point of view. My initial thought is that they represent dd/mm/yy so the autofill result is what I would expect for a locale that uses dd/mm/yy.

On the other hand, they could be mm/dd/yy, or on the gripping hand they might be yy/mm/dd.

[erAck]

Your date seems to be displayed as DD/MM/YY and incrementing a sequence of 05/11/20 05/12/20 (i.e. one month difference) correctly produces 05/01/21 05/02/21 …

[agrayray]

Thanks for the help. It seems the error occurred because my default date format was switched to
D/M/Y;D/M

Instead of :
M/D/Y;M/D

The dates I was trying to use were in USA format of mm/dd/yy.

Somehow my whole Ubuntu and correspondingly Libre Office had been set to use English (Australian) instead of English (USA)…

If I had to make an educated guess, it is because I created this virtual machine while traveling abroad and somehow the install for Ubuntu (which did not prompt for anything), auto defaulted to my location.

Changing the date format from Libre Office:
(> ‘Tools’ > ‘Options’ > ‘Language Settings’ > ‘Languages’)

or from Ubuntu

(Settings > Region & Languange > Language)

seemed to restore date format and autofill increase by day functionality I needed.

Thanks for the tip on date formatting!!!