2011/1/5 Cédric Beust ♔ <[email protected]>: > The main problem is that Excel spreadsheets are basically similar to > programs littered with GOTO's everywhere except that these statements only > appear when you click on them, so it's pretty much impossible to understand > a spreadsheet without visiting all its cells. > Admittedly, I hardly use Excel so my knowledge might be outdated, but I > don't think there is any tool which, given a spreadsheet, gives you a full > overview of all the cells, their formulas and their dependencies in a way > that makes its structure easy to understand.
My understanding is that people like Excel when they care much much much more about the data than they do about the code. So, don't think of it as seeing a bunch of GOTOs all over the place, think of it as seeing the resulting data in one shot, where you can see where data came from by clicking on it. Granted, this only goes back a step, if you will. I agree it would be neat to see a cell and the full line back of all cells it depends on back to just declared data. (Has that been done?) -- You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/javaposse?hl=en.
