Issue 121459

Summary:	Data validity window should verify 'Value' field input against the 'Allow' selection
Product:	Calc	Reporter:	ljdelight
Component:	code	Assignee:	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

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.