arrow
Return

Error Trapping and Metamorphic Testing for Spreadsheet Failure Detection

delete2017-04-01
delete5
PRE
AI
P
Pak‐Lok Poon *
H
Huai Liu
T
Tsong Yueh Chen
DOI:10.4018/JOEUC.2017040102delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
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.
Keywords:
Failure Detection
Metamorphic Relation
Oracle Problem
Spreadsheet Testing
Test Oracle
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

Journal of Organizational and End User Computing cover
Journal of Organizational and End User Computing
IF:
3.4
Papers:
561
Citations:
1.2K

Organization

S
Swinburne University of Technology
Scholars:
9.3K
Papers: 1.2W
Citations: 2.0W