To my surprise, what used to be called iWork has been my main "Office" replacement for years now. It's good enough, and it's free. I have switched over most of the non-technical people in my life to it, and they have no issues using it (except if they email a .pages document to a Windows user).
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.
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.
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.
I sometimes wish Claris Works 5 was still around. It was small and fast, did everything I actually needed when writing documents or letters and nothing I didn't need, and had a clean, uncluttered UI that made sense.
I wonder what it could have been like if we got the 1990s vision of the future where one could have ClarisWorks 5 anywhere they want as an OpenDoc Part: https://macintoshgarden.org/apps/clarisworks-5-opendoc
I also like the Pages/Numbers/Keynote suite. Of course, I'm not a heavy user of office apps at home, so large or complex documents aren't something I'm encountering day-to-day. If I needed to build such a beast, I would probably lean on the 'old standbys' like LaTeX and the like. LibreOffice is still a great platform and one I reach for if an oddly formatted document comes to me, but it's not something I'm using for crafting from scratch.
> iWork... It's good enough
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.
Does it still has this fatal flaw of ignoring the format of the currently-opened file when you press ⌘S (which should be a common occurrence)? I work with OpenDocument formats and I hated iWork products for that behavior.
Would you not say it’s sort of a stretch calling Apple software free, which only works on (anything but free) Apple hardware?
Have used Pages/Numbers/Keynote for years, alongside MS Word/Excel/Powerpoint, and always found the former to have better or nicer workflows for most tasks, and especially for page layouts. (Excel is however superior for very large or complex spreadsheets.) Highly underrated software.
I also use the iWork suite because that's what I have, and I despise Numbers
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.