https://bugs.documentfoundation.org/show_bug.cgi?id=99310

            Bug ID: 99310
           Summary: Data validity cell range dropdown list not working
           Product: LibreOffice
           Version: 5.2.0.0.alpha0+ Master
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

In LO Calc 5.2.0 aplha0 the Data validity cell range feature doesn’t work, once
the validity is set, it doesn’t display the options in the drop down selection
list.

In version 5.1.2.2 works fine.

Steps to reproduce.
Create a new Calc file
create a new list of 10 text options in A2 thru A11 in sheet1
select or add sheet2
select a range of 10 rows, like A2:A11
from the menu select Data-Validity 
in the Allow field select “cell range”
in the Source field add $sheet1.$A$2:$A$11
click OK

Go to A2 in sheet2 and open the drop down list and is empty

Save file and open it with LO Calc 5.1.2.2 and the validity works ok.

See attached test file.

Tested in Windows XP SP3 and Windows 10.

Version: 5.2.0.0.alpha0+
Build ID: 157469896ef56720f33676222b95e81c04ab5c72
CPU Threads: 2; OS Version: Windows 5.1; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-04-06_20:10:15
Locale: es-MX (es_MX)

and 

Version: 5.1.2.2
Build ID: d3bf12ecb743fc0d20e0be0c58ca359301eb705f
CPU Threads: 2; OS Version: Windows 5.1; UI Render: default; 
Locale: es-MX (es_MX)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to