- Why are all ranges displayed in the “Name Box” window list, and not only those with the global scope and local to the active sheet? Why all? Can it be customized? In any case, in Excel, names from other sheets are not shown. Excessive information is harmful, but here it clearly interferes.
- Selecting an appropriate range name in the “Name Box” that belongs to the active sheet does not correctly highlight the range. Does not work. But it should (works correctly in Excel). All ranges are configured using mixed references, which must be calculated relative to the active cell. But when you open the “Manage Names” dialog, all references are calculated correctly. And why is it not selected when necessary? Try it yourself.
Select the ranges of the active sheet from the “Name Box”, for example: Players (selects the first row correctly), Points (selects the wrong range, not the current row but again the first row), Winners (selects the wrong range).