this post was submitted on 14 Jul 2023
7 points (100.0% liked)

RPG

3925 readers
1 users here now

Discussion of table top roleplaying games.

founded 4 years ago
MODERATORS
 

Each time I try to find something (website, software, ...) to edit and automate character sheets, I go back to spreadsheets because nothing else seems good enough. Am I missing something?

you are viewing a single comment's thread
view the rest of the comments
[โ€“] Andonome@lemmy.world 2 points 1 year ago (1 children)

I tried to understand how merging several columns into one would work

It's this button.

Also there are no in cell checkboxes in Calc,

Checkboxes:

https://ask.libreoffice.org/uploads/short-url/biHcqD9rpmk0V92ShVFWZwDVIUD.ods

[โ€“] Nariom@lemmy.world 2 points 1 year ago

Sorry I meant getting the union of two ranges, concatenating two columns, putting the data of two different columns into one. Don't worry about it though, I found you can do some stuff with INDEX, but then you can't sort it, so I arranged my data in another way and color coded it... The whole process was quite annoying tbh but I got what I wanted. On your example with checkboxes they don't behave as part of the cell, idk how they work but that's weird compared to gdocs. I can use true/false instead. Also I didn't want to turn this thread into a Calc stackoverflow one ^^ Thanks for the help all the same.