Spreadsheet languages, which include commercial spreadsheets and various research systems, have proven to be flexible tools in many domain specific settings. Research shows, however, that spreadsheets often contain faults. We would like to provide at least some of the benefits of formal testing and debugging methodologies to spreadsheet developers. This paper presents an integrated testing and debugging methodology for spreadsheets. To accommodate the modeless and incremental development, testing and debugging activities that occur during spreadsheet creation, our methodology is tightly integrated into the spreadsheet environment. To accommodate the users of spreadsheet languages, we provide an interface to our methodology that does not require an understanding of testing and debugging theory, and that takes advantage of the immediate visual feedback that is characteristic of the spreadsheet paradigm. 1
|
908
|
Program slicing
– Weiser
- 1984
|
|
519
|
Interprocedural slicing using dependence graphs
– Horwitz, Reps, et al.
- 1990
|
|
446
|
A survey of program slicing techniques
– Tip
- 1995
|
|
234
|
The Program Dependence Graph in a Software Development
– Ottenstein, Ottenstein
|
|
214
|
Dynamic program slicing
– Agrawal, Horgan
- 1990
|
|
211
|
Selecting software test data using data flow information
– Rapps, Weyuker
- 1985
|
|
104
|
Analyzing Regression Test Selection Techniques
– Rothermel, Harrold
- 1996
|
|
96
|
A data flow oriented program testing strategy
– Laski, Korel
- 1983
|
|
83
|
Automatic program bug location by program slicing
– Lyle, Weiser
- 1987
|
|
78
|
Speeding up slicing
– Horwitz, Reps, et al.
- 1994
|
|
65
|
Dynamic slicing of computer programs
– Korel, Laski
|
|
61
|
On Required Element Testing
– Ntafos
- 1984
|
|
60
|
Graphical techniques in a spreadsheet for specifying user interfaces
– Myers
- 1991
|
|
57
|
Experimental study of people creating spreadsheets
– Brown, Gould
- 1987
|
|
57
|
Twinkling Lights and Nested Loops: Distributed Problem Solving and Spreadsheet Development
– Nardi, Miller
- 1991
|
|
46
|
A spreadsheet approach to information visualization
– Chi, Barry, et al.
- 1997
|
|
46
|
What You See Is What You Test: A methodology for testing form-based visual programs
– Rothermel, Li, et al.
- 1998
|
|
40
|
System-dependence-graph-based slicing of programs with arbitrary interprocedural control flow
– SINHA, HARROLD, et al.
- 1999
|
|
33
|
Graphical definitions: Expanding spreadsheet languages through direct manipulation and gestures
– Burnett, Gottfried
- 1998
|
|
31
|
Rigorous data flow testing through output influences
– Duesterwald, Gupta, et al.
- 1992
|
|
30
|
Visualizing program slices
– Ball, Eick
- 1994
|
|
25
|
Toward visual programming languages for steering in scientific visualization: a taxonomy
– Burnett, Hossli, et al.
- 1994
|
|
24
|
Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet model
– Hendry, Green
- 1994
|
|
24
|
Spreadsheet analysis and design
– Ronen, Palley, et al.
- 1989
|
|
22
|
ZStep 95: A Reversible, Animated Source Code Stepper,” Soft. Visualization: Programming as a Multimedia Experience
– Lieberman, Fry
- 1998
|
|
19
|
Steering programs via time travel
– Atwood, Burnett, et al.
- 1996
|
|
19
|
Visual representation and manipulation of matrices
– Viehstaedt, Ambler
- 1992
|
|
16
|
Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks
– Panko, Halverson
- 1996
|
|
15
|
Tools for Spreadsheet Auditing
– Davis
- 1996
|
|
14
|
Dynamic program slicing methods
– Korel, Rilling
- 1998
|
|
10
|
A bug’s eye view of immediate visual feedback in direct-manipulation programming systems
– Cook, Burnett, et al.
- 1997
|
|
8
|
Implementing level 4 liveness in declarative visual programming languages
– Burnett, Atwood, et al.
- 1998
|
|
8
|
On program dicing
– Chen, Cheung
- 1997
|
|
6
|
Does immediate visual feedback about testing aid debugging in spreadsheet languages
– Cook, Rothermel, et al.
- 1999
|
