Description: When you use data validation, you have the choice of having or not an error alert. When you want an error alert, eveything works as it is supposed to, but when you don't want this error alert, you can not change the data value if it is not on the validation list. You can overwrite, but when you press enter, the precious data will be written in the cell. Steps to Reproduce: 1.Create a validation list with "abcdef" as a validation data without wanting an error alert 2.Enter "abcdef" in the cell (everything should work fine for now) 3.Try to overwrite with "fedcba" in the same sell (everything is not working fine) Actual Results: "abcdef" Expected Results: "fedcba" Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: CL threaded
If the value is not in the definition list, it shouldn't be possible to use it then. It was the case before 24.2.1 but this "feature" was a bug. Duplicate of tdf#159595 *** This bug has been marked as a duplicate of bug 159595 ***
(In reply to Julien Nabet from comment #1) > If the value is not in the definition list, it shouldn't be possible to use > it then. > It was the case before 24.2.1 but this "feature" was a bug. > Duplicate of tdf#159595 > The qualification of the old behavior as a bug comes from some (specific) LO devs. Common users, especially experienced/older users of other spreadsheet tools, will still call it a feature. This and similar reports will show up repeatedly, as in tdf#160096. *** This bug has been marked as a duplicate of bug 160096 ***