https://bugs.documentfoundation.org/show_bug.cgi?id=160096
--- Comment #7 from ady <[email protected]> --- (In reply to Heiko Tietze from comment #6) > Confirming that Excel does this, if the error message is off "wrong" values > are silently accepted. It's a bug IMO and at max we max add a compatibility > option. Excel has means to highlight ("circle") the wrong data, ie. > validation is supposed to be applied after input. > > I wonder if you are looking for the selection list (alt+down) > https://help.libreoffice.org/latest/en-US/text/scalc/01/06130000.html @Heiko, Selection list is not the same thing as the behavior described in comment 0. 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. As for the difference between being consider a bug or not, it would be resolved by adding the (prior, old) "real" behavior to the official Help content and guides, closing any possible assumption regarding how it is supposed to work/behave. Just add a patch for the Help content immediately after the proposed reverse. -- You are receiving this mail because: You are the assignee for the bug.
