AI for Localizing Faults in Spreadsheets - Testing Software and Systems (ICTSS 2017) Access content directly
Conference Papers Year : 2017

AI for Localizing Faults in Spreadsheets

Birgit Hofer
  • Function : Author
  • PersonId : 1001784
Iulia Nica
  • Function : Author
  • PersonId : 1026231
Franz Wotawa
  • Function : Author
  • PersonId : 994796


Localizing faults in programs is considered a demanding task. A lot of effort is usually spent in finding the root cause of a misbehavior and correcting the program such that it fulfills its intended behavior. The situation is even worse in case of end user programming like spreadsheet development where more or less complex spreadsheets are developed only with little knowledge in programming and also testing. In order to increase quality of spreadsheets and also efficiency of spreadsheet development, tools for testing and debugging support are highly required. In this paper, we focus on the latter and show that approaches originating from Artificial Intelligence can be adapted for (semi-) automated fault localization in spreadsheets in an interactive manner. In particular, we introduce abstract models that can be automatically obtained from spreadsheets enabling the computation of diagnoses within a fraction of a second. Besides the basic foundations, we discuss empirical results using artificial and real-world spreadsheet examples. Furthermore, we show that the abstract models have a similar accuracy to models of spreadsheets capturing their semantics.
Fichier principal
Vignette du fichier
449632_1_En_5_Chapter.pdf (943.02 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-01678961 , version 1 (09-01-2018)





Birgit Hofer, Iulia Nica, Franz Wotawa. AI for Localizing Faults in Spreadsheets. 29th IFIP International Conference on Testing Software and Systems (ICTSS), Oct 2017, St. Petersburg, Russia. pp.71-87, ⟨10.1007/978-3-319-67549-7_5⟩. ⟨hal-01678961⟩
481 View
74 Download



Gmail Facebook X LinkedIn More