One limitation of the spreadsheet approach to rapid application development is that, in typical use* your code and data tend to be tied together. This creates a testing problem where you tend to confirm results in just one scenerio. I prefer to think of spreadhseets as electronic squared paper.

*while you can structure things to pull data in from other sources, in my experience people evolve a spreadsheet around existing data.