Welcome to the InfoSci Platform
Reference Hub4
Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection

Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection

Pak-Lok Poon, Huai Liu, Tsong Yueh Chen
Copyright: © 2017 |Volume: 29 |Issue: 2 |Pages: 18
ISSN: 1546-2234|EISSN: 1546-5012|EISBN13: 9781522510857|DOI: 10.4018/JOEUC.2017040102
Cite Article Cite Article

MLA

Poon, Pak-Lok, et al. "Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection." JOEUC vol.29, no.2 2017: pp.25-42. http://doi.org/10.4018/JOEUC.2017040102

APA

Poon, P., Liu, H., & Chen, T. Y. (2017). Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection. Journal of Organizational and End User Computing (JOEUC), 29(2), 25-42. http://doi.org/10.4018/JOEUC.2017040102

Chicago

Poon, Pak-Lok, Huai Liu, and Tsong Yueh Chen. "Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection," Journal of Organizational and End User Computing (JOEUC) 29, no.2: 25-42. http://doi.org/10.4018/JOEUC.2017040102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This study deepens the research on error trapping (ET) and metamorphic testing (MT) for detecting spreadsheet failures. It is observed that some spreadsheet developers and testers are confused between ET and MT, because the two techniques are similar to each other in some aspects. Inspired by the observation, this paper first outlines the main concepts of ET and MT using several examples for illustration. This is followed by discussing an experiment with a view to investigating and comparing the failure detection capabilities of the two techniques. The results of the experiment indicate that neither technique is sufficient in spreadsheet testing. Rather, ET and MT are complementary and they should be used together in spreadsheet testing whenever possible.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.