2005 · 65 citations · 15 references
ComputingComputer ScienceCompilersProgramming LanguagesSoftware EngineeringError CorrectionSoftware DesignSoftware MaintenanceType CheckingType SystemsVersion ControlEnd UsersPrincipal StructureSpreadsheet Programming
Existing spreadsheet systems allow users to change cells arbitrarily, which is a major source of spreadsheet errors. We propose a system that prevents errors in spreadsheets by restricting spreadsheet updates to only those that are logically and technically correct. The system is based on the concept of templates that describe the principal structure of the initial spreadsheet and all of its future versions. We have developed a program generator that translates a template into an initial spreadsheet together with customized update operations for changing cells and inserting/deleting rows and columns for this particular template.We have designed a type system for templates that ensures the following form of "spreadsheet maintenance safety": Update operations that are generated from a type-correct template are proved to transform the spreadsheet only according to the template and to never produce any omission, reference, or type errors.Finally, we have developed a prototype as an extension to Excel, which has been shown by a preliminary usability study to be well accepted by end users.
15
A methodology for testing spreadsheets
Gregg Rothermel, Margaret Burnett, Lixin Li et al. · ACM Transactions on Software Engineering and Methodology · 2001 · 149 citations
Header and Unit Inference for Spreadsheets Through Spatial Analyses
Robin Abraham, M. Erwig · 2005 · 131 citations
End-user software engineering with assertions in the spreadsheet paradigm
Margaret Burnett, Curtis R. Cook, Omkar Pendse et al. · 2003 · 125 citations