Authors
Robin Abraham, Margaret Burnett, & Martin Erwig
Abstract
Spreadsheets are among the most widely used programming systems in the world. Individuals and businesses use spreadsheets for a wide variety of applications, ranging from performing simple calculations to building complex financial models.
In this article, we first discuss how spreadsheet programs are actually functional programs. We then describe concepts in spreadsheet programming, followed by a brief history of spreadsheet systems.
Widespread use of spreadsheets, coupled with their high error-proneness and the impact of spreadsheet errors, has motivated research into techniques aimed at the prevention, detection, and correction of errors in spreadsheets. We present an overview of research effort that seeks to rectify this problem.
Sample
GoalDebug generates change suggestions that are ranked using a set of heuristics. The change suggestions can be directly applied to the spreadsheet formula, thereby minimizing the need for any formula edits by the end user.
Publication
2009, Wiley Encyclopedia of Computer Science and Engineering, ISBN 9780470050118, pages 2804-2810
