https://bugs.documentfoundation.org/show_bug.cgi?id=148279
Bug ID: 148279
Summary: Calc, Autofill not working with Date = YY/MM/DD
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a column with dates formatted as YY/MM/DD. This is an already-included
date-format in the Format Cells dialog window. When i try and autofill in the
UP-direction to newer/later dates, it fails at the new month.
Example:
22/03/32 - autofill error (should be 22/04/01)
22/03/31 - existing entry
22/03/30 - existing entry
22/03/29 - existing entry
It also fails when autofilling-down, when the existing dates are
reverse-ordered.
Steps to Reproduce:
1. Enter in 3 cells of a column:
22/03/31
22/03/30
22/03/29
2. Select all 3 cells.
3. In the bottom-right corner of the selected area, drag the 'handle' up to a
new 4th cell.
Actual Results:
22/03/32
Expected Results:
22/04/01
Reproducible: Always
User Profile Reset: No
Additional Info:
The file can be a .ods, or a .xlsx.
Sorry, i could not find an appropriate keyword for the summary. Can you
suggest one?
Sorry, i could not copy the 'About LibreOffice' dialog. In OSX, it's under the
Apple menu, and cannot be copied.
Sorry, i could not reset my UserProfile; there is no Tools>Options menu for me
to find it.
Sorry, i could not find if OpenGL was enabled: there is no Tools>Options menu
for me to find it. I also checked in Preferences and couldn't find it. There
are SO many Preferences, how about adding a searcher there.
--
You are receiving this mail because:
You are the assignee for the bug.
