Bug 68100 - FORMATTING: data validity list cleared
Summary: FORMATTING: data validity list cleared
Status: RESOLVED DUPLICATE of bug 65686
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2013-08-14 09:58 UTC by oscar.0
Modified: 2013-08-15 04:51 UTC (History)
0 users

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 oscar.0 2013-08-14 09:58:19 UTC
Problem description: 

Steps to reproduce:
1. Open new spreadsheet file
2. Click on some cell, e.g. A1
3. Open dialog "Data > Validity"
4. In "Criteria" tab, "Allow: List"
5. Entries: (Enter some strings separated by newline characters, e.g. "a[newline]b[newline]c[newline]")
6. In selected cell (e.g. A1), enter string from above list, e.g. "a"

Current behavior: Error message "Invalid value"

Expected behavior: Entry accepted if from list

1. Re-opening dialog (Data > Validity) shows empty list in "entries" (Strings are cleared, but newline characters are retained.)
2. Error appears to be limited to Windows version; Linux version works fine.
Operating System: Windows XP
Version: release
Comment 1 vivAce 2013-08-15 04:51:14 UTC

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