Show names of referenced cells
Matthew Fallshaw
This would be excellent and I humbly presume it's not crazy difficult to implement. If we had your suggestion we'd be much happier.
One
difficulty
your proposal is that sometimes cell names are long enough to be fully descriptive, and unwieldy to use because of this.Another idea
is to make the automatically assigned cell references editable (perhaps with restrictions like /^[A-Za-z0-9_#!&]{2,20}$/ (2 to 20 characters long, alphanumeric + some special characters)). These cell references could be used directly in functions, like the attached mockup (making the functions fluently self-documenting without having to look away from the functions to a table of definitions).Your suggestion could optionally be added to this idea for even more clarity.
Ozzie Gooen
We've definitely thought about this, but two worries with it:
1) Changing the names manually would be additional work on behalf the user. This makes sense for organizational metrics (library), not sure about each metric here. I imagine the option wouldn't hurt, but I'm afraid not many others would go through the effort. I imagine the way this would work if we implemented is to have a 'change variable name' option in the dropdown menu.
2) The cells on the top do go over the names, when shown (on the left column)
I'll discuss it with a few others, but am hesitant. Even if we do add it though, I imagine we could add one of the ideas in my screenshots.
Many thanks for making that mockup though! Maybe we could have some hacky way to add it via a non-standard interface.
Ozzie Gooen
Possible ideas.