Hacker News new | ask | show | jobs
by matthewgapp 16 days ago
it's a bit hidden and not fully featured. But we do support table references.

You can run cmd + T (or search for create table in the cmd +k menu) on a range to display the create table dialog.

1 comments

Ok, I see it now, thanks! I was able to reference columns after adding the table as a defined name manually. You've already mentioned that it's not yet fully featured, but just to catalog a few things:

- In Excel, when you format a range as a table, usually they become a defined/named range by default (Table_1). If that's happening in the background, it's not apparent to me as a user

- Named ranges should get suggested in autocomplete when typing formulas

- The cell name box in the top left corner should reflect range selections (e.g. A1:B4) and likewise table references when selected

- The cursor should transform to a down arrow and allow the selection of entire table columns when hovering over header cells

- Should likewise be able to select table data range when hovering over the top left corner

Sorry if you're already aware of all that!

we've fixed a bunch of this which will be out in the next release.