#checked = 1; unchecked = 0. not fucking 'true' and 'false' that i have to add additional formulas to convert into usable numbers

[technoxenoholic]

trying to move away from google sheets, but excel and libre office both lack the extremely basic "checkbox in/as a cell with a configurable data format" function that i NEED for like 90% of my spreadsheets. they both require dragging the checkboxes into place ON TOP of the spreadsheet (not IN the cell, you have to drag them over and resize/align them by hand!!!!) and setting up complex formulas and references so they actually DO ANYTHING, either one cell at a time or by using fucking MACROS to do it. AND YOU CAN'T SET WHAT THE CHECKED AND UNCHECKED VALUES EVEN ARE. i am full of hatred and loathing.