Then again, if you're a hardcore Word user, then the professional office suites still offer more functionality.
(Additionally, not everybody is lucky enough to "work in the cloud" due to various constraints or restrictions).
Then again, if you're a hardcore Word user, then the professional office suites still offer more functionality.
(Additionally, not everybody is lucky enough to "work in the cloud" due to various constraints or restrictions).
e.g. see this Python spreadsheet (which I only just discovered myself) here http://manns.github.com/pyspread/
Python expressions in your grid cells, integrated with numpy and matplotlib, and (if you want) a 3D data grid! In any case, Excel is in many ways crufty and busy when a much more minimalist data-grid-view with powerful scripting (e.g. from Python) would probably be much better for power users.
Any viable alternative to Excel has to overcome ingrained user familiarity, inertia, and be simple enough that your average Joe can use it. It would also need to be demonstrably better than Excel, which might look like crap but has quite a lot of power under the hood. It's the only Microsoft program I'd actually consider `good'.
I agree with what you're saying if you want one program to do all these things, but I'm not sure that's the way to go. Can you imagine any other industry where the same program serves both the "average Joe" and the power user?
One program can't be all things to all people. In the same way we both have iMovie and Final Cut, I think there's room for two types of spreadsheet program. Excel trying to cater to both types of people seems like a folly; it'll never make everyone happy. Why not replace Excel with a web-app on the low end, and make something more powerful that puts scripting front-and-center for people who need it?
As an example, even though I'm not a designer, I use Photoshop to create assets for my software. That would the same tool that my father, an ex-lithographer, uses for DTP and digital retouching.
A counter-example to my idiot-using-rocket-scientists'-tools is my girlfriend. She's an economist at a rather large central bank, and uses Excel to model what economists model when they're defining monetary policy. Those models are huge, and many run overnight. She comes home and Excel is the thing she uses for anything even vaguely resembling a list.
Another benefit is that one program being used by all levels makes it easier for advanced users to help less advanced users. Can you imagine trying to help a less advanced user in their paddling pool spreadsheet when you're used to something much more powerful that probably bears only superficial resemblance to it?
For the most part, even if you load 1 GB worth of numbers to do some processing with them, you'd probably only look at a summary of those numbers or some sort of aggregation. So your browser technically wouldn't have to load that information in JS, a server could do it and crunch those numbers presumably faster than a desktop would, and with a lot of these new client-app-like frameworks nowadays giving you near instant feedback, at this point we'd be arguing whether the "calculation engine" underlying the spreadsheet interface is on your local machine or on a remote machine.
My wife uses MS Excel and Word almost everyday.
I think the world is not yet moving away from desktop-based office software :)