Skip to Main content Skip to Navigation
New interface
Conference papers

AI for Localizing Faults in Spreadsheets

Abstract : 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.
Complete list of metadata

Cited literature [19 references]  Display  Hide  Download
Contributor : Hal Ifip Connect in order to contact the contributor
Submitted on : Tuesday, January 9, 2018 - 3:39:27 PM
Last modification on : Tuesday, January 9, 2018 - 4:05:09 PM
Long-term archiving on: : Thursday, May 3, 2018 - 11:58:33 PM


Files produced by the author(s)


Distributed under a Creative Commons Attribution 4.0 International License



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⟩



Record views


Files downloads