13th International Symposium on Software Reliability Engineering, 2002. Proceedings. (2002)
Nov. 12, 2002 to Nov. 15, 2002
Marc Fisher II , Oregon State University
Dalai Jin , Oregon State University
Gregg Rothermel , Oregon State Universtiy
Margaret Burnett , Oregon State University
Spreadsheet languages are widely used by a variety of end users to perform many important tasks. Despite their perceived simplicity, spreadsheets often contain faults. Furthermore, users modify their spreadsheets frequently, which can render previously correct spreadsheets faulty. To address this problem, we previously introduced a visual approach by which users can systematically test their spreadsheets, see where new tests are required after changes, and request automated generation of potentially useful test inputs. To date, however, this approach has not taken advantage of previously developed test cases, which means that users of the approach cannot benefit, when re-testing following changes, from prior testing efforts. We have therefore been investigating ways to add support for test reuse into our spreadsheet testing methodology. In this paper we present a test re-use strategy for spreadsheets, and the algorithms that implement it, and describe their integration into our spreadsheet testing methodology. We report results of a case study examining the application of this strategy.
M. Burnett, D. Jin, G. Rothermel and M. Fisher II, "Test Reuse in the Spreadsheet Paradigm," 13th International Symposium on Software Reliability Engineering, 2002. Proceedings.(ISSRE), Annapolis, Maryland, 2002, pp. 257.