TeXshop on the Mac is however rather nice.
I needed "true" or "false" in certain cells. When typing in a cell, sometimes it would capitalize it to TRUE and you would need to type "'true" to avoid that; and sometimes it randomly would accept typing "true". I simply couldn't figure out which would happen at any time.
The whole program is riddled with things like that.
A good solution I have found to your particular problem is to use checkboxes in the cells. You can select them as a cell type and it converts from Boolean value text to checkbox. I also prefer that, as a user, to typing True/False.
It can make some very pretty sheets but don't count on it if you have needs for something like pivot tables (which it doesn't have natively).
I think Apple is fucking everyone with those apps. They are not good enough for serious work but decent enough that people will use them; all to get a built-in lock in because of course it only runs on Macs...
Pages and Keynote are fine but I can't for the life of me figure out how to do anything with Numbers. It looks beautiful and I want to like it but as you say it's (too) different from Excel, at least for me.
I would argue it is not just good enough but better than Office for normal consumers. For 99% of my usage and SMEs, Page is insanely better at layout. Numbers are much better for simple chat, formulas and comparison. Keynote.... well i haven't touched powerpoint for 20+ years so I dont know.
The only thing Office is better is when you need slightly complex formulas in Excel or some enterprise that has been using Excel for so long you need to use it to guarantee absolute 100% compatibility. For business Excel usage is still king. And will continue to be for at least another 10 - 15 years if not more.
I especially enjoy Numbers and the way you can arrange multiple tables on a page. It's a different paradigm coming from Google Sheets or Excel and takes some getting used to, but to me it now makes more sense.
Of course, if I need something "done right", I'll drop down to Affinity, LaTeX, or InDesign. But I rarely have these needs nowadays.
A similar argument could be made for going all in on Google Docs/Sheets/Slides, but I feel queasy knowing that all of my data is in a free Google account, after reading some of the stories here about reaching Google support if something goes sideways.