Researchers in the Forms/3 group have previously developed the WYSIWYT
methodology, exploring a way of systematically testing spreadsheet languages. The previous
work presented the WYSIWYT methodology for individual spreadsheet cells, and later
partially extended it to large grids in which some cells share the same formula. The Forms/3
spreadsheet language supports not only operations of individual cells but also some advanced
programming features such as homogeneous grids, recursive programs, and user-defined
abstract data types. Therefore, it is important for the testing methodology to support even
these more powerful features of the language, not just the "easy parts". In this document, we
present extensions to the WYSIWYT methodology for these advanced features. We optimized
the visual aspects of testing spreadsheet grids and collected experimental information about
scalability. We also developed two possible ways the WYSIWYT methodology could be
extended to accommodate recursion in terms of their testing theoretic aspects, implementation
strategies, algorithms and time complexities. Since the ultimate goal is to help the people
using these languages, we also conducted an empirical study and used its results to inform our
choice as to which of these two approaches to adopt. Finally, we developed an approach of
testing user-defined abstract data types; here we present design, implementation issues,
algorithms and time complexities. / Graduation date: 2002
| Identifer | oai:union.ndltd.org:ORGSU/oai:ir.library.oregonstate.edu:1957/29932 |
| Date | 11 June 2001 |
| Creators | Ren, Bing |
| Contributors | Burnett, Margaret M. |
| Source Sets | Oregon State University |
| Language | en_US |
| Detected Language | English |
| Type | Thesis/Dissertation |
Page generated in 0.002 seconds