Toward an Integrated Framework for Declarative and Interactive Spreadsheet Debugging

Dietmar Jannach, Arash Baharloo, David Williamson

2013

Abstract

Spreadsheet applications can nowadays be found nearly everywhere in companies and are used for a variety of purposes. Because of the high risk that arises when business decisions are based on faulty spreadsheets, in recent years new approaches for spreadsheet quality assurance have been proposed. Among them are techniques that allow for more intelligent tool support during the spreadsheet test and debugging process. The design and evaluation of such new methods and tools, which are for example based on model-based techniques is however challenging. On the one hand, real-world spreadsheets can be large and complex, thus requiring highly efficient and scalable error-location algorithms. On the other hand, as spreadsheets are usually developed by non-programmers, special care has to be taken when designing the debugging user interface. In this paper, we discuss these challenges and present the design and architecture of an integrated framework for spreadsheet debugging called Exquisite. Furthermore, we report details and first experimental results of a constraint-based debugging approach implemented in the framework, which supports the automated identification of possible spreadsheet errors based on user-provided test cases and model-based diagnosis techniques.

Paper Citation

in Harvard Style

Jannach D., Baharloo A. and Williamson D. (2013). Toward an Integrated Framework for Declarative and Interactive Spreadsheet Debugging . In Proceedings of the 8th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-8565-62-4, pages 117-124. DOI: 10.5220/0004410601170124

in Bibtex Style

@conference{enase13,
author={Dietmar Jannach and Arash Baharloo and David Williamson},
title={Toward an Integrated Framework for Declarative and Interactive Spreadsheet Debugging},
booktitle={Proceedings of the 8th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,},
year={2013},
pages={117-124},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004410601170124},
isbn={978-989-8565-62-4},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 8th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,
TI - Toward an Integrated Framework for Declarative and Interactive Spreadsheet Debugging
SN - 978-989-8565-62-4
AU - Jannach D.
AU - Baharloo A.
AU - Williamson D.
PY - 2013
SP - 117
EP - 124
DO - 10.5220/0004410601170124