Coda, a “next-generation spreadsheet” – from rows and columns to custom apps

Re:Coda, a “next-generation spreadsheet” – from rows and col... by lozenge on Tuesday October 24, 2017 @01:48PM (#15543549)

Excel 2007 solved the naming problem with tables. You can refer to cells in the same row, or an entire column or range of columns. https://support.office.com/en-gb/article/Using-structured-re...

Edit: and of course individual cells can be renamed since forever.

[ Parent | on HN ]

Re:Coda, a “next-generation spreadsheet” – from rows and col... by mschaef on Tuesday October 24, 2017 @02:16PM (#15543851)

Data tables can also make things considerably faster. A colleague of mine once made a spreadsheet something like an order of magnitude faster by switching to data tables. (Maybe more speedup than that, even.)

[ Parent | on HN ]

Re:Coda, a “next-generation spreadsheet” – from rows and col... by cm2187 on Tuesday October 24, 2017 @04:43PM (#15545083)

Assuming all you ever care about is tabular data.

If you are building a business plan in Excel, or trying to explain how the financial accounts consolidates in a large organisation with multiple subsidiaries, tables are not particular useful.

That's the catch with Excel. One application, thousands of very different use cases.

[ Parent | on HN ]

Re:Coda, a “next-generation spreadsheet” – from rows and col... by addicted on Tuesday October 24, 2017 @05:30PM (#15545420)

So how do named columns help with non-tabular data?

[ Parent | on HN ]

Re:Coda, a “next-generation spreadsheet” – from rows and col... by cm2187 on Tuesday October 24, 2017 @05:38PM (#15545460)

That's my point, they don't. If your table is a complex calculation, not data, named columns don't help you.

[ Parent | on HN ]