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.
