this post was submitted on 25 Jun 2024
8 points (100.0% liked)

LibreOffice

557 readers
7 users here now

Community to discuss LibreOffice, new features, etc. You can also discuss Apache OpenOffice here.

founded 3 years ago
MODERATORS
TheImpressiveX@lemmy.ml
8
Calc: How do I use discrete (text) values? (slrpnk.net)
submitted 2 months ago* (last edited 3 weeks ago) by boredsquirrel@slrpnk.net to c/libreoffice@lemmy.ml
4 comments fedilink hide all child comments
 

There are many cases when people might want to have a dropdown list of the other entered values in a column.

And the ability to prohibit entering others.

Classic one: entering yes, no, maybe.

These are not boolean, but discrete, and others should not be allowed.

Do you know how to do that?

Answer

source

select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

Here is an example.

Thanks @Aufgehtsabgehts@feddit.org

Ende Gelände!

you are viewing a single comment's thread
view the rest of the comments
[–] Aufgehtsabgehts@feddit.org 2 points 3 weeks ago

I hope you found what you were looking for. A quick search delivered:

select your range D25:D99, then menu Data->Validity In dialogue Validity select from drop-down list variant “Cell range”, and bottom set “Source” (your H3:H25) Push OK

Here is an example.