2 ms·
There are entire organisations and conferences about the dangers of spreadsheets[1] and there are now programming standards for develop spreadsheets[2]. Basica
by jacques_chester 13y ago
There are entire organisations and conferences about the dangers of spreadsheets[1] and there are now programming standards for develop spreadsheets[2].
Basically, the normal rules apply. If you want safe spreadsheets, you have to plan and verify.
The reason this doesn't happen is because firstly, spreadsheets are very accessible. Every working large system evolves from a working small system, as John Gall observed. Excel et al make that evolution relatively easy.
The second is that spreadsheets enable non-programmers to work with concrete concepts instead of the abstract ones that programming languages encourage. It's easy to visualise locations on a sheet when you are looking at the sheet.
Finally, spreadsheets support calculation by propagation. They are an excellent declarative environment. Most programming languages do not support this model of programming (though we're groping towards it with concepts of binding).
[1] http://www.eusprig.org/ http://www.eusprig.org/
[2] http://www.fast-standard.org/document/FastStandard_01b.pdf http://www.fast-standard.org/document/FastStandard_01b.pdf