Issue 121459

Summary: Data validity window should verify 'Value' field input against the 'Allow' selection
Product: Calc Reporter: ljdelight
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues
Version: 3.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description ljdelight 2012-12-10 23:35:50 UTC
The Spreadsheet data validity window does not validate the 'Value' input field against the 'Allow' drop-down selection. The user can mismatch types accidentally (like using a string in the 'Value' field when an integer is only allowed). 

1. Create a spreadsheet.
2. Select some group of cells (or a single cell, doesn't matter)
3. On the main toolbar, select 'Data' -> 'Validity...'. The validity
window opens.
4. For the Allow dropdown, select 'Whole Numbers'. Set Data to Equal.
5. In the Value field, enter some non-whole number (like 'foo', or '2.718').
6. The value is accepted but should be rejected since it does not match the allowed type.