Bug 70004 - EDITING: List entered under DATA > Validity > Allow List, disappears after Validity window is closed.
Summary: EDITING: List entered under DATA > Validity > Allow List, disappears after Va...
Status: RESOLVED DUPLICATE of bug 65686
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.1.2 release
Hardware: x86-64 (AMD64) All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-01 14:53 UTC by Brian
Modified: 2013-10-01 21:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Brian 2013-10-01 14:53:53 UTC 
This has been tested on Linux and Windows 7 (both 64bit), LibreOffice versions 4.1.1.2 on both and 4.2.0.0.alpha0 on Linux.

To reproduce:

1. Open a new spreadsheet and select a cell.
2. Navigate to Data > Validity
3. Select Allow: List
4. Uncheck "Allow blank cells", check "Sort entries ascending". (may not be necessary).
5. Enter a few list items and click "OK".

The drop down arrow will appear next to the cell but no list appears when clicking on it. Entering any data (even items you entered in the list) will result in an invalid data error. Selecting the cell and going back to Data > Validity will reveal that the list is blank but, in my testing, contains a couple return characters.
Comment 1 GerardF 2013-10-01 21:03:10 UTC 
Already reported. Should be fixed in 4.1.3

*** This bug has been marked as a duplicate of bug 65686 ***