https://bugs.documentfoundation.org/show_bug.cgi?id=169193
--- Comment #4 from Rob Mahn <[email protected]> --- By golly you're right! I did not see the tool tip change between entering the last character and pressing ENTER. My eyes are not as fast as my fingers. I figured out that I could create the name I wanted using the Manage Names dialog. However, I was initially left with trying to figure out how to create the desired name when you can't do it in the Name Box. I'll stand on this is not intuitive behavior. After all, it is a Name Box, not a Sheet Navigation Box. There are multiple methods to navigate to a sheet without having to double up on the purpose of the Name Box. I lookup the the help for the Name Box. It reads: "Name Box Displays the reference for the current cell, the range of the selected cells, or the name of the area. You can also select a range of cells, and then type a name for that range into the Name Box. To jump to a particular cell, or to select a cell range, type the cell reference, or cell range reference in this box, for example, F1, or A1:C4. You can also enter full name of a sheet; the tooltip then changes to "Go To Sheet", and pressing Enter switches to that sheet." So, I agree the behavior is correctly documented, but you have to read beyond the first paragraph to see that typing a sheet name will supersede creating a name and doesn't point out an alternate way to create the name. Surely not many people have tripped over this and become frustrated trying to figure out the problem. I was just trying to help others from suffering the same fate as me. I wonder how many depend on typing a sheet name for navigation? Obviously, this is not a bid deal, I just think it could be done better. -- You are receiving this mail because: You are the assignee for the bug.
