Print Email Facebook Twitter Detecting Code Smells in Spreadsheet Formulas Title Detecting Code Smells in Spreadsheet Formulas Author Hermans, F. Pinzger, M. Van Deursen, A. Faculty Electrical Engineering, Mathematics and Computer Science Department Software Technology Date 2011-12-31 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. Subject spreadsheetscode smellsrefactoring To reference this document use: http://resolver.tudelft.nl/uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51 Publisher Delft University of Technology, Software Engineering Research Group ISSN 1872-5392 Source Technical Report Series TUD-SERG-2011-030 Part of collection Institutional Repository Document type report Rights (c) 2011 The authors. Software Engineering Research Group, Department of Software Technology, Faculty of Electrical Engineering, Mathematics and Computer Science, Delft University of Technology. Files PDF TUD-SERG-2011-030.pdf 253.66 KB Close viewer /islandora/object/uuid:a6bd3669-55a9-45e0-9a1e-b7f64365bb51/datastream/OBJ/view