Hacker News new | ask | show | jobs
by narcraft 17 days ago
Are you able to create formatted tables and use structured references? I see Tables listed as a feature on your webpage, but can't find any further information. If it's in the app already, I'm having trouble finding it.
1 comments

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.

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.