Yeah. I was using numbers and it's not serious software.
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.
I have run into similar issues and I agree, it’s not without flaws. The formula editor is another example, as others have pointed out.
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.