Bug 147243 - 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.
Summary: LibreOffice spreadsheet. Entering a date of "1/2" (to represent the first o...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All macOS (All)
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-07 10:01 UTC by Gary Williams
Modified: 2022-02-07 22:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gary Williams 2022-02-07 10:01:42 UTC 
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
Comment 1 Gary Williams 2022-02-07 10:03:32 UTC 
The Mac OS is Monterey 12.1
It is 64 bit
Comment 2 m_a_riosv 2022-02-07 22:10:31 UTC 
You have the options.

1. To disable the substitution on Menu/Tools/Autocorrection - Replace.

2- Enter as 01/2 instead of 1/2.