Scaling a Dataflow Testing Methodology to the MultiparadigmWorld of Commercial Spreadsheets

Authors

Marc Fisher II, University of Nebraska-LincolnFollow
Gregg Rothermel, University of Nebraska-LincolnFollow
Tyler Creelan, Oregon State UniversityFollow
Margaret Burnett, Oregon State UniversityFollow

Date of this Version

2006

Comments

Published in 17th International Symposium on Software Reliability Engineering, 2006. ISSRE '06. Copyright 2006 IEEE. Used by permission.

Abstract

Spreadsheets are widely used but often contain faults. Thus, in prior work we presented a data-flow testing methodology for use with spreadsheets, which studies have shown can be used cost-effectively by end-user 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 data-flow testing approaches. We show how to handle these two issues with a new data-flow adequacy criterion and automated detection of areas of replicated formulas, and report results of a controlled experiment investigating the feasibility of our approach.