News for hackers. Stuff that matters.
Re:WordPerfect for UNIX (1992) by tomjen3 on Tuesday July 19, 2022 @03:16AM (#32148445)
In excel select the location of your table, select format as table and now you have a table that you can setup auto sum on, setup computed columns and automatically have everything extended when you add a new line.

You can also use it as basis for a pivot table so excel can make you a much better overview of your data.

Re:WordPerfect for UNIX (1992) by Someone on Tuesday July 19, 2022 @07:53PM (#32159519)
Problem: once you have multiple such tables on a sheet, adding and removing rows or columns to such tables becomes hit and miss.

Numbers will happily shift down tables to make room, but Excel won’t.

Array formulas are another sort-of alternative for Numbers’ tables, but there, too, the implementation could be better. You can’t insert a row ‘inside’ a range of rows covered by an array formula, for example.

Re:WordPerfect for UNIX (1992) by qubex on Tuesday July 19, 2022 @03:26AM (#32148510)
Thanks (no sarcasm) but I know how it works.

My point was that in Excel this is an afterthought, whereas in Numbers it’s a consequence of how the application is devised from first principles.