Spreadsheets are Code: An Overview of Software Engineering Approaches Applied to Spreadsheets
2016
Spreadsheets can be considered to be the world's most successful end-user programming language. In fact, one could say spreadsheets are programs. This paper starts with a comparison of spreadsheets to software: spreadsheets are similar in terms of applications domains, expressive power and maintainability problems. We then reflect upon what makes spreadsheets successful: liveness, directness and an easy deployment environment seem contribute largely to their success. Being a programming language, several techniques from software engineering can be applied to spreadsheets. We present an overview of such research directions, including spreadsheet testing, reverse engineering, smell detection, clone detection and refactoring. Finally, open challenges and future plans for the domain of spreadsheet software engineering are presented.
Keywords:
- Software construction
- Social software engineering
- Software reliability testing
- Software engineering
- Software Engineering Process Group
- Resource-oriented architecture
- Systems engineering
- Search-based software engineering
- Software framework
- Computer science
- Software development
- Software requirements
- Programming language
- Component-based software engineering
- Software maintenance
- Correction
- Source
- Cite
- Save
- Machine Reading By IdeaReader
47
References
19
Citations
NaN
KQI