Detecting code smells in spreadsheet formulas
- 1 September 2012
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 2 (10636773) , 409-418
Abstract
Spreadsheets are used extensively in business processes around the world and just like software, spreadsheets are changed throughout their lifetime causing maintainability issues. This paper adapts known code smells to spreadsheet formulas. To that end we present a list of metrics by which we can detect smelly formulas and a visualization technique to highlight these formulas in spreadsheets. We implemented the metrics and visualization technique in a prototype tool to evaluate our approach in two ways. Firstly, we analyze the EUSES spreadsheet corpus, to study the occurrence of the formula smells. Secondly, we analyze ten real life spreadsheets, and interview the spreadsheet owners about the identified smells. The results of these evaluations indicate that formula smells are common and that they can reveal real errors and weaknesses in spreadsheet formulas.Keywords
This publication has 14 references indexed in Scilit:
- Refactoring meets spreadsheet formulas2012
- Detecting and visualizing inter-worksheet smells in spreadsheets2012
- Automatically Extracting Class Diagrams from Spreadsheets2010
- Software Engineering for SpreadsheetsIEEE Software, 2009
- Automatic detection of dimension errors in spreadsheetsJournal of Visual Languages & Computing, 2009
- Quality control in spreadsheets: a software engineering-based approach to spreadsheet development2005
- The EUSES spreadsheet corpus2005
- How to communicate unit error messages in spreadsheets2005
- What We Know About Spreadsheet ErrorsJournal of Organizational and End User Computing, 1998
- Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet modelInternational Journal of Human-Computer Studies, 1994