RPG

926 readers

1 users here now

Discussion of table top roleplaying games.

founded 4 years ago

MODERATORS

[email protected]

Best tools for character sheets? (self.rpg)

submitted 1 year ago by Nariom to c/[email protected]

16 comments fedilink hide all child comments

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

[–] Nariom 1 points 1 year ago* (last edited 1 year ago) (1 children)

Some functions like QUERY, SORT, CHOOSECOLS, MAP* that makes it easier. I tried to understand how merging several columns into one would work in Calc and gave up. There are workarounds but no legit way to do it outside scripting, but I'd like to keep my sheets script free. Also there are no in cell checkboxes in Calc, but I guess you could just use a boolean. Overall I'm often frustrated by Calc and shamefully go back to G.

[–] Andonome 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 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.