Hacker News new | ask | show | jobs
by narcraft 16 days ago
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!

1 comments

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