https://bugs.documentfoundation.org/show_bug.cgi?id=160096
--- Comment #6 from Heiko Tietze <[email protected]> --- 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 -- You are receiving this mail because: You are the assignee for the bug.
