Test Reuse in the Spreadsheet Paradigm

  • Authors:
  • Marc Fisher II;Dalai Jin;Gregg Rothermel;Margaret Burnett

  • Affiliations:
  • -;-;-;-

  • Venue:
  • ISSRE '02 Proceedings of the 13th International Symposium on Software Reliability Engineering
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

Spreadsheet languages are widely used by a variety ofend users to perform many important tasks. Despite theirperceived simplicity, spreadsheets often contain faults. Furthermore,users modify their spreadsheets frequently, whichcan render previously correct spreadsheets faulty. To addressthis problem, we previously introduced a visual approachby which users can systematically test their spreadsheets,see where new tests are required after changes, andrequest automated generation of potentially useful test inputs.To date, however, this approach has not taken advantageof previously developed test cases, which means thatusers of the approach cannot benefit, when re-testing followingchanges, from prior testing efforts. We have thereforebeen investigating ways to add support for test reuseinto our spreadsheet testing methodology. In this paper wepresent a test re-use strategy for spreadsheets, and the algorithmsthat implement it, and describe their integration intoour spreadsheet testing methodology. We report results of acase study examining the application of this strategy.