https://bugs.documentfoundation.org/show_bug.cgi?id=160096
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|[email protected] | --- Comment #10 from Julien Nabet <[email protected]> --- (In reply to ornanovitch from comment #9) > (In reply to Julien Nabet from comment #8) > > > Why defining a validity list if a value not on the list is accepted without > > indication? > > There is no evidence that the “validity list” should be interpreted solely > as a “permitted list”, there are only habits on this matter. What's not > valid in a context is not necessarily forbidden, nor necessarily invalid in > another context. > ... In this case, it would be a "suggestion list". Let's quote again Ms doc since it's been used as a ref to revert the patch: "When is data validation useful? Data validation is invaluable when you want to share a workbook with others, and you want the data entered to be accurate and consistent. Among other things, you can use data validation for the following: Restrict entries to predefined items in a list— For example, you can limit a user’s department selections to Accounting, Payroll, HR, to name a few. Restrict numbers outside a specified range— For example, you can specify a maximum percentage input for an employee’s annual merit increase, let’s say 3%, or only allow a whole number between 1 and 100. Restrict dates outside a certain time frame— For example, in an employee time off request, you can prevent someone from selecting a date before today’s date. Restrict times outside a certain time frame— For example, you can specify meeting scheduling between 8:00 AM and 5:00 PM. Limit the number of text characters— For example, you can limit the allowed text in a cell to 10 or fewer characters. Validate data based on formulas or values in other cells— For example, you can use data validation to set a maximum limit for commissions and bonuses based on the overall projected payroll value. If users enter more than the limit amount, they see an error message." So it's just about restriction, not suggestion. I know that there's a lot things in life that can be interpreted differently but sometimes but I don't think it's the case here. Anyway, I'll stop here since it seems I won't convince you as you'll won't convince me. Feel free to revert the patch. uncc myself. -- You are receiving this mail because: You are the assignee for the bug.
