- spreadsheet - Data > Validity - Select Allow List - Enter Entries Aap Noot Mies - OK > cell shows list dropdown control but is disabled also Alt+down does not work - again open Data > Validity > there are empty lines in the list Entries
works at least fine in 4.0.3
Created attachment 81876 [details] sample ods file Cell validity is not working for me also. I have attached a sample ods file. Yellow is a validity cell with drop down list. I have entered 4 items. If I go to menu Data--> Validity --> Criteria --> List Cursor moves will inside list in Criteria --> List , but no value shows in the list. Actually I have enter 10, 20, 30, 40 in downward order. It is not possible to get drop down list values in cell.
Libreoffice version used is 4.1 rc1
Created attachment 82269 [details] Screenshot to illustrate the bug with comparisons
Created attachment 82270 [details] Screenshot to illustrate the bug with comparisons Hello, I confirm this bug. I'm using the LibO 4.1.0.2 RC2 version. Yet, I tried to do the same thing using cell range. It seems that all datas in the dropdown menu are there. See attached file. Hope that this bug will be fixed before the final release of this version. Cheer Bunty
*** Bug 65582 has been marked as a duplicate of this bug. ***
*** Bug 67686 has been marked as a duplicate of this bug. ***
Confirm in LibreOffice 4.1.0.4. Validity for "Allow: cell range" is fine, only have problem for "List" entries.
Confirm the bug in LibreOffice 4.1.0.4. The "list" option in data validity does not show the selection list when clicking at the arrow. Other validation methods seem to work OK. OS: Windows XP
Can confirm all of the above running Ubuntu 13.04 using both the stock Repos and the PPA. Libreoffice is 4.1.0.4 Build ID: 410m0(Build:4)
*** Bug 68100 has been marked as a duplicate of this bug. ***
Confirm in LibreOffice 4.1.0.4
I raise the importance level of this issue. with this regression professional use of Calc is impossible.
I changed the version from 4.1.0.1.beta1 to 4.1.0.4 release, since a beta version might be expected to be buggy, however numerous people confirm this bug in the normal release, including me.
@vivAce When you want to _raise_ the version number, pls read the comment that the site gives to you before clicking save changes ;)
@Cor. Sorry. Newby to bugzilla. I'm not what I am supposed to read before saving changes. I checked but couldn't find anything. Could you please fill me in?
to db@tasit.net again, please guys do not change version field... it should indicate the first version the bug appeared (in this case 4.1.0.0 beta) and not the last one where it's still reproducibile (4.1.1.2 rc)
*** Bug 68693 has been marked as a duplicate of this bug. ***
I installed the Version: 4.2.0.0.alpha0+ Build ID: 5a684a041f10fe20512dd5aef6552531165dfa44. I unfortunately found the same bug. I hope that this information can help for finding a solution for this bug. Cheer
*** Bug 68873 has been marked as a duplicate of this bug. ***
Confirm this bug on LO 4.1.1.2
I can confirm that I'm having the same problem. Using LibreOffice Version: 4.1.1.2, Build ID: 410m0(Build:2)
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cb460bf3ca6beab2478d29398ddfb6276ac19b04 fix validity dialog with lists, fdo#65686 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 67480 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0b0cea7fd774d1fd9c66eab3026940dc4a8899cc&h=libreoffice-4-1 fix validity dialog with lists, fdo#65686 It will be available in LibreOffice 4.1.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 69077 has been marked as a duplicate of this bug. ***
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-1-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=61d74e6758cae039593de0d358860fd08227db80&h=libreoffice-4-1-2 fix validity dialog with lists, fdo#65686 It will be available already in LibreOffice 4.1.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 69706 has been marked as a duplicate of this bug. ***
*** Bug 69714 has been marked as a duplicate of this bug. ***
*** Bug 69904 has been marked as a duplicate of this bug. ***
*** Bug 69996 has been marked as a duplicate of this bug. ***
*** Bug 70004 has been marked as a duplicate of this bug. ***
*** Bug 70136 has been marked as a duplicate of this bug. ***
*** Bug 70274 has been marked as a duplicate of this bug. ***
*** Bug 72569 has been marked as a duplicate of this bug. ***
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4897a75b4703d658f94f88caae6a66375fd73b08 uitest for bug tdf#65686 It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The test exist, set status to Verified.