2006 17th International Symposium on Software Reliability Engineering (2006)
Raleigh, North Carolina
Nov. 7, 2006 to Nov. 10, 2006
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/ISSRE.2006.40
Marc II Fisher , University of Nebraska-Lincoln
Gregg Rothermel , University of Nebraska-Lincoln
Tyler Creelan , Oregon State University
Margaret Burnett , Oregon State University
Spreadsheets are widely used but often contain faults. Thus, in prior work we presented a dataflow testing methodology for use with spreadsheets, which studies have shown can be used cost-effectively by enduser programmers. To date, however, the methodology has been investigated across a limited set of spreadsheet language features. Commercial spreadsheet environments are multiparadigm languages, utilizing features not accommodated by our prior approaches. In addition, most spreadsheets contain large numbers of replicated formulas that severely limit the efficiency of dataflow testing approaches. We show how to handle these two issues with a new dataflow adequacy criterion and automated detection of areas of replicated formulas, and report results of a controlled experiment investigating the feasibility of our approach.
T. Creelan, M. I. Fisher, M. Burnett and G. Rothermel, "Scaling a Dataflow Testing Methodology to the MultiparadigmWorld of Commercial Spreadsheets," 2006 17th International Symposium on Software Reliability Engineering(ISSRE), Raleigh, North Carolina, 2006, pp. 13-22.