Issue 39007 - field validation is not done when entered wrong datatype in the filed.
Summary: field validation is not done when entered wrong datatype in the filed.
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All Windows 98
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2004-12-15 04:18 UTC by poornimadamaraju
Modified: 2013-02-07 22:37 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description poornimadamaraju 2004-12-15 04:18:49 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".
Comment 1 christoph.lukasiak 2004-12-20 12:44:31 UTC
Comment 2 christoph.lukasiak 2004-12-20 12:46:26 UTC
clu->poornimadamaraju: this is rather an enhancement than a bug (changed issue type)
Comment 3 christoph.lukasiak 2004-12-20 12:47:15 UTC
back to you again
Comment 4 marc.neumann 2005-01-05 10:10:44 UTC

I reassign this issue to User Experience for evaluating.

Bye Marc