https://bugs.documentfoundation.org/show_bug.cgi?id=170355
Bug ID: 170355
Summary: Any date format other than MM/DD/YYYY won't allow
auto-filliing based on the first few dates
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If I explicitly formt a column as date, and enter DD/MM/YYYY (Australian) date
format, no amount of manually adding extra rows of incremented dates will make
it xtrapolate past the first date entereted, just like it was text.
If I just type in 2 sequential MM/DD/YYYY or YYYY/MM/DD date rows, apply no
fortmatting, select both rows, and autofil using the lower right handle, it
just works.. Un predictable and kind of unuseable.
The only problem with YYYY/MM/DD is that the day just keeps incrementing past
the end of month!
Autofill YYYY/MM/DD.. No upper range on day)
2025/11/19
2025/11/20
2025/11/21
2025/11/22
2025/11/23
2025/11/24
2025/11/25
2025/11/26
2025/11/27
2025/11/28
2025/11/29
2025/11/30
2025/11/31
2025/11/32
2025/11/33
2025/11/34
2025/11/35
2025/11/36
2025/11/37
...
Steps to Reproduce:
1. Enter two or more rows of DD/MM/YYYY data, with second date later htan the
first
2. Format column/area as Date (or not.. it makes no difference)
3. Use right bottom handle that you normally use to auto-fill series of data,
and only the first row will be propagated.. Whereas MM/DD/YYYY and YYYY/MM/DD
work fine
Actual Results:
Manually typed to start series Try to auto file Autofill numeric
Autofill MM/DD/YYYY Autofill YYYY.. No upper range on day)
19/11/2025 19/11/2025 1 01/01/26 2025/11/19
20/11/2025 19/11/2025 2 02/01/26 2025/11/20
21/11/2025 19/11/2025 3 03/01/26 2025/11/21
19/11/2025 4 04/01/26 2025/11/22
19/11/2025 5 05/01/26 2025/11/23
19/11/2025 6 06/01/26 2025/11/24
19/11/2025 7 07/01/26 2025/11/25
19/11/2025 8 08/01/26 2025/11/26
9 09/01/26 2025/11/27
10 10/01/26 2025/11/28
11 11/01/26 2025/11/29
12 12/01/26 2025/11/30
13 01/01/27 2025/11/31
14 02/01/27 2025/11/32
15 03/01/27 2025/11/33
16 04/01/27 2025/11/34
17 05/01/27 2025/11/35
Expected Results:
Sequential numbers based on initial rows
Reproducible: Always
User Profile Reset: No
Additional Info:
The same as it has done for 20 years
--
You are receiving this mail because:
You are the assignee for the bug.
