TeXshop on the Mac is however rather nice.
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...