Description: Calc used to allow inserting rows and manually filling in a date overriding the drop-down menu. I tried going back from version 24.8 to 24.2.6.2, 24.2.5 without success. I am not sure what version I had before I downloaded 24.8, sure it was two or three version older that worked. I save file as Excel file for over two years. Steps to Reproduce: 1.insert new row 2.type in a date older than drop-menu option (eight is list in menu. 3.select enter or tab input goes away leaving blank cell. Actual Results: na Expected Results: date entered Reproducible: Always User Profile Reset: No Additional Info: na
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. Please test in safe mode, Menu/Help/Restart in Safe Mode
Created attachment 196546 [details] Calc file showing blank date cells when typing manual input with inserting row..
Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d500848976b6244048684a9972322b582559910a CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Latest version that works on the ones I have installed. Version: 24.2.0.0.alpha1 (X86_64) / LibreOffice Community Build ID: 06946980c858649160c634007e5fac9a5aa81f38 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
This seems to have begun at the below commit in bibisect repository/OS linux-64-24.8. 94ff5b2099f80560871f4e12d3d52671fcd4f7e4 is the first bad commit commit 94ff5b2099f80560871f4e12d3d52671fcd4f7e4 Author: Jenkins Build User <tdf@maggie.tdf> Date: Wed Feb 7 09:10:41 2024 +0100 source c869fb5ea2fa1dbbfa7c17754aeac48ed7f77cc4 163064: tdf#159595: Data validation without error check allows to enter wrong data | https://gerrit.libreoffice.org/c/core/+/163064 It's not a bug - data validity allow dates from range date_list. Allowed values are: 9.21.2024 9.20.2024 9.19.2024 9.18.2024 9.17.2024 9.16.2024 9.15.2024 9.14.2024
The user is unable to type a date different from the drop down menu. Try typing 9/6. It does not stay as entered. It worked in the past.
(In reply to Scott from comment #5) > The user is unable to type a date different from the drop down menu. Try > typing 9/6. It does not stay as entered. If user want type any value disable Data validity https://help.libreoffice.org/latest/mk/text/scalc/guide/validity.html. Please read the help about this feature. > It worked in the past. It worked before, but it was a mistake, now fixed with mentioned commit.
(In reply to raal from comment #6) > It worked before, but it was a mistake, now fixed with mentioned commit. It worked before, because that was by design, exactly as it still works in every other spreadsheet tool that uses the same Data Validation / Validity (except LO Calc). Unfortunately, the commit is just developers' ego interfering with 3+ decades of worksheets that are no longer working as expected, and breaking compatibility with every other spreadsheet tool, past and present. *** This bug has been marked as a duplicate of bug 160096 ***