Automated test case generation for spreadsheets

Fisher, Marc; Cao, Mingming; Rothermel, Gregg; Cook, Curtis R.; Burnett, Margaret

doi:10.1145/581356.581359

Cited by 37 publications

(26 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Fisher et al [10] suggest a systematic approach to building a spreadsheet, but their methods are used to create spreadsheet from scratch, and not to analyze existing ones.…”

Section: Related Workmentioning

confidence: 99%

“…This research mainly aims at two directions: 1) the localizations of errors within existing spreadsheets [1][2][3][4][5]18] and 2) the development of guidelines on how to create well-structured and maintainable spreadsheets [10,14,15,21,22]. Both directions share the goal of improving spreadsheet quality, which is necessary because the current state of spreadsheet use leads to numerous problems as described in several papers, most notably in the work of Panko [20].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Automatically Extracting Class Diagrams from Spreadsheets

Hermans¹,

Pinzger²,

Deursen³

2010

ECOOP 2010 – Object-Oriented Programming

View full text Add to dashboard Cite

Abstract. The use of spreadsheets to capture information is widespread in industry. Spreadsheets can thus be a wealthy source of domain information. We propose to automatically extract this information and transform it into class diagrams. The resulting class diagram can be used by software engineers to understand, refine, or re-implement the spreadsheet's functionality. To enable the transformation into class diagrams we create a library of common spreadsheet usage patterns. These patterns are localized in the spreadsheet using a two-dimensional parsing algorithm. The resulting parse tree is transformed and enriched with information from the library. We evaluate our approach on the spreadsheets from the Euses Spreadsheet Corpus by comparing a subset of the generated class diagrams with reference class diagrams created manually.

show abstract

“…Fisher et al [10] suggest a systematic approach to building a spreadsheet, but their methods are used to create spreadsheet from scratch, and not to analyze existing ones.…”

Section: Related Workmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Automatically Extracting Class Diagrams from Spreadsheets

Hermans¹,

Pinzger²,

Deursen³

2010

ECOOP 2010 – Object-Oriented Programming

View full text Add to dashboard Cite

show abstract

“…To minimize the effort involved in developing new test cases, researchers have also focused on algorithms for automatic test generation that would result in test suites that are close to being mutation adequate [64], [65]. Support for generating test cases automatically [24], [44] would also lower the cost of mutation testing in spreadsheets. .…”

Section: Related Workmentioning

confidence: 99%

“…5. Testing [23], [24], [25]. Traditional software engineering research has made considerable progress in the area of testing.…”

Section: Introductionmentioning

confidence: 99%

Mutation Operators for Spreadsheets

Abraham

Erwig

2009

IIEEE Trans. Software Eng.

View full text Add to dashboard Cite

Abstract-Based on 1) research into mutation testing for general-purpose programming languages and 2) spreadsheet errors that have been reported in the literature, we have developed a suite of mutation operators for spreadsheets. We present an evaluation of the mutation adequacy of definition-use adequate test suites generated by a constraint-based automatic test-case generation system we have developed in previous work. The results of the evaluation suggest additional constraints that can be incorporated into the system to target mutation adequacy. In addition to being useful in mutation testing of spreadsheets, the operators can be used in the evaluation of error-detection tools and also for seeding spreadsheets with errors for empirical studies. We describe two case studies where the suite of mutation operators helped us carry out such empirical evaluations. The main contribution of this paper is a suite of mutation operators for spreadsheets that can be used for performing empirical evaluations of spreadsheet tools to indicate ways in which the tools can be improved.

show abstract

“…This was rewarded by incrementing "testedness" indicators in the environment, such as changing the cell's border color toward blue along a red-blue continuum to indicate increased testedness. If they wanted help conjuring up more test inputs, participants could push a Help-Me-Test button to automatically generate more values [8]. Help-Me-Test's role in our experiment was in its use as a springboard by the Surprise-Explain-Reward strategy for introducing users to assertions.…”

Section: The Environment For Interruptionsmentioning

confidence: 99%

Impact of interruption style on end-user debugging

Robertson

Prabhakararao

Burnett

et al. 2004

Proceedings of the SIGCHI Conference on Human Factors in Computing Systems

View full text Add to dashboard Cite

Although researchers have begun to explicitly support enduser programmers' debugging by providing information to help them find bugs, there is little research addressing the proper mechanism to alert the user to this information. The choice of alerting mechanism can be important, because as previous research has shown, different interruption styles have different potential advantages and disadvantages. To explore impacts of interruptions in the end-user debugging domain, this paper describes an empirical comparison of two interruption styles that have been used to alert end-user programmers to debugging information. Our results show that negotiated-style interruptions were superior to immediate-style interruptions in several issues of importance to end-user debugging, and further suggest that a reason for this superiority may be that immediate-style interruptions encourage different debugging strategies.

show abstract

Automated test case generation for spreadsheets

Cited by 37 publications

References 0 publications

Automatically Extracting Class Diagrams from Spreadsheets

Automatically Extracting Class Diagrams from Spreadsheets

Mutation Operators for Spreadsheets

Impact of interruption style on end-user debugging

Contact Info

Product

Resources

About