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?

When my cursor is right below a pasted image and I press enter, the image moves down with the cursor. How do I permanently stop this?

Hello!

I am very new to LibreOffice and I am trying to adjust and explore it. I have searched this question online but I can’t seem to find an answer to how I can sync LibreOffice works with iCloud? I have installed Collabora office, but I have no idea how to sync that with LibreOffice either… anybody up for teaching a newcomer?

Cheers!

This is the first version of LibreOffice to use Calendar Versioning, and it also comes with numerous updates and changes. See the blog post for details.

I have a document, and I like the way Wikipedia formats references: with numbers in square brackets (ex: [4]). I have found how to enable them to show up as such in the document, but the bibliography panel in the document doesn't show the numbers. How do I make the square bracket tags show up in the bibliography section in a document?

Thanks to Juan José Gonzales!

SOLVED, with a huge thank you to [email protected]
https://lemmy.world/comment/6271130

Hiyo Librecalc pros. Hoping someone has an idea how to automate or minimize the steps for this. Or where should I start? I'm trying to automate transcribing a list from:
Closet_01
Cartridge123
Cartridge234
Garagenook_01
Cartridge456
Toolbox567
Toolbox789
Garagenook_02
Cartridge890

Into an array/table like:
Cartridge123, Closet_01
Cartridge234, Closet_01
Cartridge456, Garagenook_01
Toolbox567, Garagenook_01
Toolbox789, Garagenook_01
Cartridge890, Garagenook_02

I get it; I should just carry around a barcode list of all my shelf names and take turns between scanning the list, tabbing over on my phone, scanning a box, then tabbing back again. But... what if I want to be lazier and just scan things in an order and automate the rest later?

Is there a faster way than copy-pasting my way down?

I got as far as making an adjacent column with a formula to check for "_", then copying the location if "_" was found.