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: libreoffice-bugs@lists.freedesktop.org Reporter: obhip...@cox.net 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.