Excel and OpenOffice both support named ranges, but Numbers has not. So, I have been using LibreOffice for complex spreadsheets and Numbers for simple ones. I updated to Mavericks and installed the new version of Numbers.
Unless I'm missing something, there remains no support for named ranges and no way to control the values for cell popup menus via a formula or reference to a named range. You can use a range of values in a formula, such as to place the sum of a range in a distant cell, if the range uses the standard header row; but this is not quite the same as a named range. And there is no way to reference a range as a popup value, such as using the Indirect and Index functions; you have to type in values for the menu.
...unless I'm missing something. Anybody see a new way to handle named ranges in Numbers 3?
I get where you are coming from. I don't expect that Numbers is going to go in that direction. If you read the torrent of recent complaints about Version 3.0, you will realize that quite the opposite is true.