End-user software engineering with assertions in the spreadsheet paradigm

Burnett, Margaret; Cook, Curtis R.; Pendse, O.; Rothermel, Gregg; Summet, Jay; Wallace, Chris

doi:10.1109/icse.2003.1201191

Cited by 93 publications

(98 citation statements)

References 23 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Since spreadsheet developers are typically end-users without significant background in computer science, there has been considerable effort to adapt software engineering principles to form a spreadsheet engineering discipline (e.g., [7][8][9][10][11]). …”

Section: Related Workmentioning

confidence: 99%

On the Empirical Evaluation of Fault Localization Techniques for Spreadsheets

Hofer

Riboira

Wotawa

et al. 2013

Fundamental Approaches to Software Engineering

View full text Add to dashboard Cite

Abstract. Spreadsheets are by far the most prominent example of enduser programs of ample size and substantial structural complexity. In addition, spreadsheets are usually not tested very rigorously and thus comprise faults. Locating faults is a hard task due to the size and the structure, which is usually not directly visible to the user, i.e., the functions are hidden behind the cells and only the computed values are presented. Hence, there is a strong need for debugging support. In this paper, we adapt three program-debugging approaches that have been designed for more traditional procedural or object-oriented programming languages. These techniques are Spectrum-based Fault Localization, Spectrum-Enhanced Dynamic Slicing, and Constraint-based Debugging. Beside the theoretical foundations, we present a more sophisticated empirical evaluation including a comparison of these approaches. The empirical evaluation shows that Sfl (Spectrum-based Fault Localization) and Sendys (Spectrum ENhanced Dynamic Slicing) are the most promising techniques.

show abstract

Section: Related Workmentioning

confidence: 99%

On the Empirical Evaluation of Fault Localization Techniques for Spreadsheets

Hofer

Riboira

Wotawa

et al. 2013

Fundamental Approaches to Software Engineering

View full text Add to dashboard Cite

show abstract

“…For example, Cues infers constraints over web service data [14], and Forms/3 infers numeric constraints over spreadsheet cells [2]. From a conceptual standpoint, Toped generalizes these number-oriented systems to include string-like data.…”

Section: Related Workmentioning

confidence: 99%

Fast, Accurate Creation of Data Validation Formats by End-User Developers

Scaffidi

Myers

Shaw

2009

End-User Development

View full text Add to dashboard Cite

Abstract. Inputs to web forms often contain typos or other errors. However, existing web form design tools require end-user developers to write regular expressions ("regexps") or even scripts to validate inputs, which is slow and errorprone because of the poor match between common data types and the regexp notation. We present a new technique enabling end-user developers to describe data as a series of constrained parts, and we have incorporated our technique into a prototype tool. Using this tool, end-user developers can create validation code more quickly and accurately than with existing techniques, finding 90% of invalid inputs in a lab study. This study and our evaluation of the technique's generality have motivated several tool improvements, which we have implemented and now evaluate using the Cognitive Dimensions framework.

show abstract

“…Consistency checking can also be carried out using assertions on the range of values allowed in spreadsheet cells [8].…”

Section: Related Workmentioning

confidence: 99%