figshare
Browse
art%3A10.1007%2Fs10664-013-9296-2.pdf (1.2 MB)

Detecting and refactoring code smells in spreadsheet formulas

Download (0 kB)
journal contribution
posted on 2014-04-02, 07:40 authored by Felienne HermansFelienne Hermans, Martin Pinzger, Arie van Deursen

Spreadsheets are used extensively in business processes around the world and just like software, spreadsheets are changed throughout their lifetime causing understandability and maintainability issues. This paper adapts knowncode smellsto spreadsheet formulas. To that end we present a list of metrics by which we can detectsmellyformulas; a visualization
technique to highlight these formulas in spreadsheets and a method to automatically suggest refactorings to resolve smells. We implemented the metrics, visualization and refactoring suggestions techniques in a prototype tool and evaluated our approach in three studies.
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 own-ers about the identified smells. Finally, we generate refactoring suggestions for those ten spreadsheets and study the implications. The results of these evaluations indicate that for-mula smells are common, that they can reveal real errors and weaknesses in spreadsheet formulas and that in simple cases they can be refactored.

 

History

Usage metrics

    Licence

    Exports

    RefWorks
    BibTeX
    Ref. manager
    Endnote
    DataCite
    NLM
    DC