On Tue, Jan 4, 2011 at 10:15 PM, Alexey Zinger <[email protected]>wrote:

> I see your point, but I don't really agree that spreadsheets are inherently
> any harder to understand or verify than any other type of programming
> language.  It's possible to make a mess in any language, just as it is
> possibly to write well laid out and designed systems in most any language.
>

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.

-- 
Cédric

-- 
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.

Reply via email to