https://bugs.documentfoundation.org/show_bug.cgi?id=147243
Bug ID: 147243 Summary: LibreOffice spreadsheet. Entering a date of "1/2" (to represent the first of february) into a cell results in display of the fraction 1/2. Product: LibreOffice Version: 7.2.5.2 release Hardware: All OS: macOS (All) Status: UNCONFIRMED Severity: trivial Priority: medium Component: LibreOffice Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: g4ga...@gmail.com Description: When "1/2" is entered into a cell which has been formatted as date it results in the display of the fraction 1/2. Further tests showed that when "1/4" is entered the result is the fraction 1/4. You can get around this by typing the date in full, ie for the first of February, type "1/2/22" which correctly outputs "01/02/22". Steps to Reproduce: 1.Format a cell as Date, with "31/12/99" as the date format 2.enter the data 1/2 3. Actual Results: the fraction "1/2" is displayed Expected Results: a date "01/02/22" Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no -- You are receiving this mail because: You are the assignee for the bug.