Apache OpenOffice (AOO) Bugzilla – Issue 39007
field validation is not done when entered wrong datatype in the filed.
Last modified: 2013-02-07 22:37:25 UTC
Steps to Reproduce: 1. Open a calc application. 2. Select an Access database. 3. Select one of the table, it displays all the data present in that table at the right pane. 4.Insert one record into the table by just entering the data into the corresponding columns. 5.For the column whose datatype is created as "Number", enter alphabets in that. Eg: For the Salary column whose datatype is "Number" enter "three" instead of "3" and go to the next field or if it is the last field save the record. Expected Result: When the record is saved with wrong dataytype entered; it should validate the field and prompt the user with a message saying that "Only numerical characters are to be entered". Actual Result: It is seen that the field value where alphabet is entered , the value is directly converted to "0", that is "three" is being replaced with "0".
mine
clu->poornimadamaraju: this is rather an enhancement than a bug (changed issue type)
back to you again
Hi, I reassign this issue to User Experience for evaluating. Bye Marc