https://issues.apache.org/ooo/show_bug.cgi?id=121459
Bug ID: 121459
Issue Type: ENHANCEMENT
Summary: Data validity window should verify 'Value' field input
against the 'Allow' selection
Classification: Application
Product: spreadsheet
Version: AOO 3.4.1
Hardware: All
OS: All
Status: CONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
