123elf icon indicating copy to clipboard operation
123elf copied to clipboard

Function status missing range name

Open rruhle opened this issue 1 year ago • 5 comments

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?

rruhle avatar Apr 26 '23 00:04 rruhle