I do however need some serious functionality enhancements in Numbers (e.g. named functions and something like Microsoft's VBA coding capabilities) if I am ever going to be able to move my most complex spreadsheets across to Numbers. (I don't even need VBA compatibility, just some equivalent functionality in Numbers and I'd be willing to re-implement my VBA code using whatever capabilities Apple provided.) I'd be willing to pay subscription fees if it meant that Apple used some of the revenue to expand its Numbers development team...
This is kind of the crux of the "it does 90% of what most users need" idea espoused from people who advocate for Numbers or Libre or any of the other dozen or so spreadsheet applications out there. Yes, it is true that for most users, 90% of the functionality that they need in a spreadsheet exists in pretty much every GUI spreadsheet application that has ever existed. The problem is that last 10% of functionality is vastly different for different users. For you it may be the ability to program custom functions and macros. For others it may be the ability to securely query external data sources. Or the ability to combine tables from multiple sheets using a query language. Or the ability to add visual filters and slicers to a pivottable.
And this is the reason why people who love Excel love Excel - it is incredibly feature-rich to the point where most people are hard-pressed to even think about what additional functionality could possibly be crammed into a future version. And yet Microsoft still adds arguably useful new functionality with every new version. It is a virtual guarantee that whatever you need a spreadsheet to do at any given time, Excel will do it.
It is also the reason why people who hate Excel hate Excel - it is the most bloated spreadsheet you'll ever encounter. And Microsoft is still adding bloat to it with every new version.
This, unfortunately (or fortunately - for some users), is also why Numbers may never get the functionality enhancements that you want, regardless of whether Apple expands the Numbers development team at all. Numbers is not Excel and was never meant to be Excel. People (possibly even you) prefer to use it
because it is not Excel. It is faster and lighter and more responsive and more secure and cheaper than Excel, precisely because it does not try to do that extra 10%. It is an entirely different tool and has a different target audience.
...but with Numbers currently just one of 10 apps in the Creator Studio bundle I would really resent paying a full Creator Studio subscription for literally only 1 app that I care about.
I would too. I think Apple's messaging is a bit muddled with the Creator Studio bundle when it comes to the iWork apps. My take (as a total layperson on the sidelines with no insight whatsoever) is that the Creator Studio bundle was built specifically for creatives, with the small amount of extra iWork stuff added as a small extra bone to throw for those users. It was never meant as a subscription for people who just want to use iWork and have a few extra AI perks and some clipart. If Apple were a bit more clear on that goal, I think it would be less annoying to the other 80% of Apple users who never touch a media editing application.
I accept that not everyone has the same focus as me but if Apple had split the subscriptions out into separate iWorks (Numbers, Pages and Keynote) and Creator Studio (the current stuff minus the apps that had been put into the iWorks subscription) I would feel a lot more comfortable that of the subscription revenue that I was paying (an iWorks subscription) was actually going to fund development that I cared about.
That's absolutely valid, and I think we will probably eventually see one of two things come from Apple:
- A separate iWork-only bundle for subscribing to extra/new functionality without the inclusion of Final Cut Pro, Logic, etc. If this is the path that Apple takes, I'm guessing it will be when they've already enhanced iWork and the other functionality enough for such a bundle to be worthwhile (because right now, IMHO it really isn't).
- The AI/ClipArt and other iWork enhancements that the bundle does pay for will become bundled in with Apple's other cloud services and iWork itself will remain free.
Personally, I think I'm in the same boat as you in that I would definitely hope that #1 becomes the case. Unfortunately, I think there are a lot of users here who would much rather see #2.
I can imagine that creatives might also feel the same way sort of in reverse. If they mostly spent their time in those other apps and didn't want any of their subscription fees to go to the iWorks apps because the free versions were 100% good enough for their occasional needs or never used at all.
Maybe. I can't imagine that the subscription price for the bundle would be lower without the extra iWork stuff in it, though. Apple generally starts with a target price and then designs their offerings around it. I think the iWork stuff was just meant to be a free added benefit for creatives.