123elf
123elf copied to clipboard
Function status missing range name
rruhle commented 1 hour ago • Managing range names, or checking names for a range becomes harder when not shown in status bar.
Since @cell(attributes) won't reveal range names, the legacy DOS 123 spreadsheet function @@() showed any names created for a cell address in top left status bar.
While Linux shows the same referenced value at cell location containing @@() function, only cell address appears in top left status bar, no range name(s).
The more range names created, the harder it becomes to find or check a named range with the alternative key sequence F5, F3, F3, and scrolling thru all range names to locate the intended cell address.
taviso commented 1 hour ago Hmm, I wasn't familiar with that!
I know that in POINT mode if you choose a range that has a name, and press F3, 123 will enter the name, does that help?
We could add a new attribute like @CELL("name", D6) in the next release if that would be useful? I guess the question is what to do if that cell/range doesn't have a name, or has multiple names!
Maybe we could just return ERR unless there is exactly one match?