Spreadsheet testing in practice

Conference Paper (2017)
Authors

Sohon Roy (TU Delft - Software Engineering)

F. Hermans (TU Delft - Software Engineering)

A. Van van Deursen (TU Delft - Software Technology)

Research Group
Software Engineering
Copyright
© 2017 S. Roy, F.F.J. Hermans, A. van Deursen
To reference this document use:
https://doi.org/10.1109/SANER.2017.7884634
More Info
expand_more
Publication Year
2017
Language
English
Copyright
© 2017 S. Roy, F.F.J. Hermans, A. van Deursen
Related content
Research Group
Software Engineering
Pages (from-to)
338-348
ISBN (print)
978-1-5090-5502-9
ISBN (electronic)
978-1-5090-5501-2
DOI:
https://doi.org/10.1109/SANER.2017.7884634
Reuse Rights

Other than for strictly personal use, it is not permitted to download, forward or distribute the text or part of it, without the consent of the author(s) and/or copyright holder(s), unless the work is under an open content license such as Creative Commons.

Abstract

Despite being popular end-user tools, spreadsheets suffer from the vulnerability of error-proneness. In software engineering, testing has been proposed as a way to address errors. It is important therefore to know whether spreadsheet users also test, or how do they test and to what extent, especially since most spreadsheet users do not have the training, or experience, of software engineering principles. Towards this end, we conduct a two-phase mixed methods study. First, a qualitative phase, in which we interview 12 spreadsheet users, and second, a quantitative phase, in which we conduct an online survey completed by 72 users. The outcome of the interviews, organized into four different categories, consists of an overview of test practices, perceptions of spreadsheet users about testing, a set of preventive measures for avoiding errors, and an overview of maintenance practices for ensuring correctness of spreadsheets over time. The survey adds to the findings by providing quantitative estimates indicating that ensuring correctness is an important concern, and a major fraction of users do test their spreadsheets. However, their techniques are largely manual and lack formalism. Tools and automated supports are rarely used.

Files

TUD_SERG_2017_002.pdf
(pdf | 0.783 Mb)
License info not available