Apache OpenOffice (AOO) Bugzilla – Issue 118756
Find and replace can change the cell value to invalid values
Last modified: 2013-01-23 01:40:00 UTC
Step: 1. New a speadsheet 2. Set the cell validity to allow Whole number that greater than 0, and check show error message when invalid values are entered also select Stop actions. 3. Input some valid value such as 1,2,3,4 into cells 4. press Ctrl+F to open find&Replace dialog 5. Input value 1 to search for and invalid value in Replace with, click find and replace. Result: The value replace with the invalid value successfully, no error messages.
I can see the same problem