alphaman

I love Numbers. I've used Excel since it first came out on the Mac back in the '80s, through a couple decades on Windows for Intel and Alpha, and have learned to loathe the ribbon and user-hostile interface it has. However, I do have one gripe, and one hidden power feature not touched on above, regarding Numbers.

First, the gripe. Numbers has never had pivot tables. In the iWork 9 version of Numbers, it had Table Categories, and that was a brilliant way of viewing the same detail. Sadly, that was stripped out during the iCloud-enabling rewrite and no longer exists. I'd love for Table Categories to come back!

Not mentioned above: when laying out your sheet full of tables and charts and pictures and text boxes, you can easily arrange things that don't print out well. Turn on your rulers and drag guide lines to match your print space so that you can be sure to place elements where they'll not be ignominiously chopped up in little bits when transferred to paper or PDF. Just calculate your print space as your paper size minus your margins (top + bottom, or left + right) and divide by your print scale factor. I've not found an automated way to do that -- perhaps Apple could add such a feature?