Bug 162162 - 24.2.5.2 Data Validation Error Alert Resetting Field in Calc issue not present in 7.3.7.2
Summary: 24.2.5.2 Data Validation Error Alert Resetting Field in Calc issue not presen...
Status: RESOLVED DUPLICATE of bug 160096
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.5.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-07-23 17:43 UTC by James Warmuth
Modified: 2024-07-23 21:05 UTC (History)
1 user (show)

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 James Warmuth 2024-07-23 17:43:14 UTC
Description:
I have tested this in Windows and Debian with the same result.  Tested on multiple computers with same result.  Windows is running the x64 installation.  Debian is running 7.3.7.2 from repository and 24.2.5.2 from Flathub.  I have a sheet with drop down data validation fields.  Those fields have a area after the drop down to customize.  Something like "The reference number is XX.  " That part is select-able from the drop down list and the the XX is replaced with custom content such as "1723819379".  I have data validation set to Information but with the "Show error message when invalid values are entered" turned off.  In version 7 this lets me select the item from the list and customize it at the end of the string.  However in version 24 it removes anything that I change and sets it back to just what is available in the drop down.  The basic idea is I want drop down options but I do not what the system to validate them and accept whatever changes I make after the selection is complete.  

Steps to Reproduce:
1.Create new sheet and add a validated cell with list as the criteria
2.Set error alert to information and turn off show error message
3.Select the item from the drop down and then try to modify it in any way.  

Actual Results:
The changes you made manually are dropped 

Expected Results:
The changes you made are kept


Reproducible: Always


User Profile Reset: Yes

Additional Info:
I am not opposed to finding a different way to accomplish my objective.  All I want is a way to select from a drop down list in a specific cell and then let me modify it.  Think of it like shortcuts.  I am submitting a bug because I have used this method and it has worked for years but now it does not.
Comment 1 ady 2024-07-23 20:38:49 UTC
This is another dupe of tdf#160096, basically requesting to revert tdf#159595.

@Heiko, these requests will continue, and rightly so. Please revert tdf#159595, which unnecessarily breaks prior behavior and compatibility (with older spreadsheets and with other spreadsheet tools).

To adequate solution for tdf#159595 is to improve documentation/labels, not to break the feature.

*** This bug has been marked as a duplicate of bug 160096 ***