Issue 121459 - Data validity window should verify 'Value' field input against the 'Allow' selection
Summary: Data validity window should verify 'Value' field input against the 'Allow' se...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-10 23:35 UTC by ljdelight
Modified: 2012-12-10 23:35 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description ljdelight 2012-12-10 23:35:50 UTC 
Enhancement.
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.