[ohgr]

I tried using Numbers across my Mac and iPad. It has some show stopping sync bugs there which result in it completely destroying documents. Then when you try and recover previous versions you get a lesson in Apple's commitment to things other than the facade on the front of their stuff: not a lot. The document versions thing sometimes doesn't even work and if it does it's so slow it's unusable. Probably backed with some low tier S3 stuff. Also the formula editor is painful at best.

TeXshop on the Mac is however rather nice.

[x0x0]

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.

[lauritz]

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.

[seec]

Another common problem with Numbers is the low performance as row count grow and calculations complexity rise.

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...