Bug 160638 - Validation lists and free entries
Summary: Validation lists and free entries
Status: RESOLVED DUPLICATE of bug 160096
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-12 08:36 UTC by nathan.rivenez@outlook.fr
Modified: 2024-07-23 21:05 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nathan.rivenez@outlook.fr 2024-04-12 08:36:15 UTC
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
Comment 1 Julien Nabet 2024-04-12 10:17:18 UTC
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 ***
Comment 2 ady 2024-04-12 18:02:30 UTC
(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 ***