GNOME Bugzilla – Bug 123270
GUI probs with named ranges
Last modified: 2004-12-22 21:47:04 UTC
Two minor probs with named ranges: (1) In the name field that occurs at the left of the formula toolbar, if you change the name from e.g. "C7" to "my_value", it defines the name my_value for C7. But there's no way of undefining it without bringing up the Names dialog. (I tried setting it to blank to get back the C7, and it actually gave C7 a name of "", which has to be bad..) (2) selecting C7, then going to the Names dialog, then changing the range for my_value to C8, then accepting the changes and closing the dialog, does not refresh the name field on the toolbar, so if you're in C7 or C8, it still reflects the old value. (As an aside, wouldn't the Edit menu or even the Format menu be a better place for the menu option "Name->Define" than the Insert menu, aside from Excel compatibility? I always thought it was in a strange place. And there's only one option in the Name submenu too, eliminating the need for the submenu altogether, right?... It might also be nice to have "Define Name" in the right-click context menu too, although it's nice that the context menu is so small currently...)
defining a name of "" is bad - fixed renaming via the goto box - an interesting enhancement, but not a bug. reloading goto box after dialog - fixed position of menu entry - for 1.3.x there is a huge menu reorg debate brewing.