Bug 159030

Summary: Fractions are created in Date Fields
Product: LibreOffice Reporter: IDMooseMan <IDMooseMan>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 7.4.7.2 release   
Hardware: All   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description IDMooseMan@yahoo.com 2024-01-04 22:03:34 UTC 
Description:
Today, when I entered "1/4" in a cell with "Date Format" specified, instead of seeing "1/4/2024" as expected, the "Date Format" was ignored and my entry was converted to a fraction. This FORMATTING issue is a long-term issue.

Steps to Reproduce:
1. Create a cell with "Date Format".
2. Enter "1/4".
3. Press Enter.

Actual Results:
A fraction, 1/4, is returned instead of today's date.

Expected Results:
Today's date, 1/4/2024, is the expected result in a cell with "Date Format" specified, not a mathematical fraction.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 24; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Comment 1 ady 2024-01-05 01:52:31 UTC 
Please take a look at:

Calc > menu Tools > Options > Language settings > Languages > "Date acceptance patterns".

Please modify the field according to your needs and try again.

Hint: the use of "/" as date separator for "Date acceptance patterns" frequently generates a conflict. You can have the resulting cell displaying the date with one format, but the acceptance pattern with another format.

Please post your results, so we would know what to do with this report.
Comment 2 m_a_riosv 2024-01-05 02:10:12 UTC 
You need to disable the Autocorrect recognition for those inputs.

If I remember fine, the only format in a cell that the input take care is 'Text'.

Maybe this thread https://ask.libreoffice.org/t/calc-is-converting-date-to-fractions/60198/3 con help.

If you don't want to modify Autocorrect (Menu/Tools/Autocorrect options/Replace), enter at least the date with only one number for month/day with a '0' before, so the date is recognized.
e.g. instead 1/4 enter 01/4 or 1/04.

Also, you can use [Ctrl+Z] just after [enter]