Towards a catalog of spreadsheet smells

Jácome Cunha, João P. Fernandes, Hugo Ribeiro, João Saraiva

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog.

Original languageEnglish (US)
Title of host publicationComputational Science and Its Applications - 12th International Conference, ICCSA 2012, Proceedings
Pages202-216
Number of pages15
EditionPART 4
DOIs
StatePublished - 2012
Event12th International Conference on Computational Science and Its Applications, ICCSA 2012 - Salvador de Bahia, Brazil
Duration: Jun 18 2012Jun 21 2012

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
NumberPART 4
Volume7336 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Conference

Conference12th International Conference on Computational Science and Its Applications, ICCSA 2012
Country/TerritoryBrazil
CitySalvador de Bahia
Period6/18/126/21/12

Keywords

  • Code Smells
  • EUSES Corpus
  • Spreadsheets

ASJC Scopus subject areas

  • Theoretical Computer Science
  • General Computer Science

Fingerprint

Dive into the research topics of 'Towards a catalog of spreadsheet smells'. Together they form a unique fingerprint.

Cite this