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
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.
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]