Apple Numbers has the most potential of any spreadsheet software in my opinion. It is so much easier to use than any of it's competitors, however the features are slow to come.
I really adored the old versions that had the sidebar with sheet and table lists.
But yeah, it definitely has enormous potential. They just keep adding features that are pretty useless, such as the ability to annotate with a Pencil or various realtime collaboration features. That’s all pretty pointless. They have a potential winner on their hands and they don’t even bother implementing the stuff power users need. Keynote clearly benefitted from Steve’s intensive use of it. Somebody in the C-suite really needs to settle into using Numbers as their main spreadsheet and then growl at developers to implement the features they find themselves wanting.