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)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium critical
Assignee: Not Assigned
Depends on:
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:


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 on both and 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 ***