Using Spreadsheet, created data > validity > criteria. Choosing 'list' option, typed in values. They show up. After clicking OK, seeing the drop down list button (down arrow), click on button, none of the values appear on screen as if totally blank.
I just reproduced this.
in fact, the values do disappear - something is deleting them.
go back into data > validity and you will see that the values you typed are gone - replaced by emptiness.
so if I had in the list
then I hit ok, and go back into the list - I then see
(without the quotes, they are just used to show empty lines - although the return's are present as you can arrow up and down).
*** Bug 67650 has been marked as a duplicate of this bug. ***
See https://bugs.freedesktop.org/attachment.cgi?id=83642 for a sample document.
Created attachment 83671 [details]
Most probably caused by http://cgit.freedesktop.org/libreoffice/core/commit/?id=b0cf3aba085373d84a55ef144b273a8a89d017af
This may be a duplicate of Bug 65686?
Many people on cc list of 65686, so may this be closed and track 65686?
*** Bug 69019 has been marked as a duplicate of this bug. ***
I can confirm that I'm having the same problem.
Using LibreOffice Version: 22.214.171.124, Build ID: 410m0(Build:2)
*** This bug has been marked as a duplicate of bug 65686 ***
Migrating Whiteboard tags to Keywords: (bibisected)