The reason Google Spreadsheet hasn't taken off is lack of investment on Google's part, which is needed because from what I understand from some Google's devs comments, it is a right mess under the bonnet.
We can only guess why Google haven't invested in it, maybe they don't believe people are willing to share their private or corporate data with Google's, or they think the potential for disaster is too high.
But I believe the potential is there
I suspect the reason for Google's lack of investment is the degree of difficulty which it takes to develop a spreadsheet that can compete with Excel on something other than price. The world is littered with trivial attempts at spreadsheets, from Emacs org-mode tables and calc-mode to Common-Lisp's Cells project to Scheme-in-a-grid.
As I skim and wade and slog about Knuth's Semi-Numerical Algorithms, I get the feeling that any useful spreadsheet is probably going to have a bit of the "Electric components by Lucas" about it in order to bash a numerical implementation sufficiently to meet the reasonable expectations of real world non-programmer end-users. You won't get far with the CEO of a Fortune 500 corporation by saying, "Sometimes addition and multiplication are non-associative, so be sure to avoid cumulative rounding errors."
Pasting: See Office Clipboard. http://office.microsoft.com/en-us/word-help/copy-and-paste-m...
I'm not seeing this.
You can indeed paste from the clipboard multiple times in Excel. I just tried this, and it works fine in both Excel 2013 and the Excel web app.
>the rarity of similar observations regarding Excel calculations.
There is no rarity of these: https://en.wikipedia.org/wiki/Numeric_precision_in_Microsoft...
>Excel, not Windows, is the killer-app for Microsoft
Agreed:)
The thing about Excel is it's good enough to compete with free, e.g. Google Docs and OpenOffice/OfficeLibre. That's perhaps why Microsoft Excel buried less expensive competitors with approximately equivalent functionality for a typical user, not only Lotus123 but also Quattro Pro.
From the signups so far, it appears there are plenty of people looking for an alternative, so we'll focus on satisfying them.
Microsoft has changed lots of things in Excel. The pivot tables and graphs were rewritten in 2007. The statistics functions were rewritten in 2010. These are pretty fundamental features.
The key is that they made these changes by versioning. v1 Pivot Tables are not automatically converted to v2 Pivot Tables. The new statistics functions have new names -- the old statistics functions are still around. This ensures bug-for-bug compatibility with old spreadsheets.
After nearly 40 years of commercial spreadsheets, the empirical evidence is that spreadsheets are hard, otherwise there would be more of them. And the reason Excel dominates is because they get so many of the non-trivial details right.
Example: consider how often inaccuracy of JavaScript floating point operations makes a blog post appearance on the web [I recall several even on HN] versus the rarity of similar observations regarding Excel calculations. Then consider how many complicated floating point ops are done via Excel functions every minute of every day by non-computer scientists and non-programmers.
A couple of years ago I came to the conclusion that Excel, not Windows, is the killer-app for Microsoft, and that Microsoft knows it and invests in it accordingly. The person who decides on office suites is the manager who uses spreadsheets not the people using the word processor [in which case we would talk about WordPerfect not MS Word as the standard].