https://bugs.documentfoundation.org/show_bug.cgi?id=160096
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #8 from Julien Nabet <[email protected]> --- (In reply to ady from comment #7) > ... > Since users have been using Calc with this behavior for 3+ decades and Excel > does the same, please consider the simpler solution (which happens to result > in better compatibility too): reverting the patch from tdf#159595, which was > implemented very recently only. > ... Quote from link provided https://support.microsoft.com/en-us/office/more-on-data-validation-f38dee73-9900-4ca6-9301-8a5f6e1f0c4c) " 1) Stop: Prevent users from entering invalid data in a cell. A Stop alert message has two options: Retry or Cancel. 2) Warning: Warn users that the data they entered is invalid, without preventing them from entering it. When a Warning alert message appears, users can click Yes to accept the invalid entry, No to edit the invalid entry, or Cancel to remove the invalid entry. 3) Information: Inform users that the data they entered is invalid, without preventing them from entering it. This type of error alert is the most flexible. When an Information alert message appears, users can click OK to accept the invalid value or Cancel to reject it. " So there's no case when invalid entry is silently accepted. The most resembling case is 3 but it informs user. Why defining a validity list if a value not on the list is accepted without indication? So no pb for adding the feature but strongly disagree for reverting the patch. Now I know I'm nobody to decide here so I can only say that if it must be reverted, I won't be the guy who'll do this. -- You are receiving this mail because: You are the assignee for the bug.
