News for hackers. Stuff that matters.
Re:The Importance of Excel by michaelfeathers on Monday February 11, 2013 @03:07AM (#5199875)
Imagine Excel with a complete audit trail of all keystrokes and spreadsheet interactions. Quite a few problems would be solved.
Re:The Importance of Excel by intended on Monday February 11, 2013 @03:18AM (#5199898)
Many firms have absolutely gargantuan spreadsheets and workbooks.

I suspect that individual files would become humongous with those features added.

Re:The Importance of Excel by michaelfeathers on Monday February 11, 2013 @03:48AM (#5199961)
If you store the commands from the beginning, you can recreate the state at any point in time.

Space gets cheaper every day.

Re:The Importance of Excel by intended on Monday February 11, 2013 @04:10AM (#5200007)
The idea does have merit. On the average case it should be able to work.

A few things may be an issue with implementation, one of which would be excel macros. As it stands excel undo cannot regress past the last use of a macro. I suspect a state list may encounter a similar roadblock.

As it stands excel can be very very slow on large sets of data. On a sufficiently complex and clean model, I've seen load times and computer slow downs which begin to make Tokyo traffic seem mild, if it doesn't just hang.

Re:The Importance of Excel by konstruktor on Monday February 11, 2013 @03:57AM (#5199984)
This would make it easier to blame the person who "made the mistake" of mistyping something in a spreadsheet that is error-prone by nature and used in a process without QA. Exactly what problem would that solve?
Re:The Importance of Excel by michaelfeathers on Monday February 11, 2013 @04:58AM (#5200108)
It's a foot in the door toward QA and detection of common mistakes.
Re:The Importance of Excel by codeulike on Monday February 11, 2013 @04:26AM (#5200047)
Google docs spreadsheets _almost_ have that - it keeps a history but its hard to do a diff with previous versions
Re:The Importance of Excel by binxbolling on Monday February 11, 2013 @09:35AM (#5200948)
It doesn't keep nearly enough history for even basic usage.
Re:The Importance of Excel by lallysingh on Tuesday February 12, 2013 @05:25PM (#5210020)
You have to click the "Show more detailed revisions" button.
Re:The Importance of Excel by binxbolling on Wednesday February 13, 2013 @04:59PM (#5215959)
Still does not prevent revision pruning. For personal use, this is very rarely a problem. For anybody with Google Apps for Education or Business, it's a pretty frequent issue with (AFAIK) no real or good solution:

https://docs.google.com/support/bin/answer.py?answer=95902

Re:The Importance of Excel by Leynos on Monday February 11, 2013 @03:37AM (#5199939)
As I understand it, Hypernumbers (the cloud spreadsheet) offers this.