Exception Handling in the Spreadsheet Paradigm

  • Authors:
  • Margaret Burnett;Anurag Agrawal;Pieter van Zee

  • Affiliations:
  • Oregon State Univ., Corvallis, OR;Qualcomm, Inc., San Diego, CA;Hewlett Packard, Inc., Corvallis, OR

  • Venue:
  • IEEE Transactions on Software Engineering - special section on current trends in exception handling—part II
  • Year:
  • 2000

Quantified Score

Hi-index 0.00

Visualization

Abstract

Exception handling is widely regarded as a necessity in programming languages today and almost every programming language currently used for professional software development supports some form of it. However, spreadsheet systems, which may be the most widely used type of 驴programming language驴 today in terms of number of users using it to create 驴programs驴 (spreadsheets), have traditionally had only extremely limited support for exception handling. Spreadsheet system users range from end users to professional programmers and this wide range suggests that an approach to exception handling for spreadsheet systems needs to be compatible with the equational reasoning model of spreadsheet formulas, yet feature expressive power comparable to that found in other programming languages. In this paper, we present an approach to exception handling for spreadsheet system users that is aimed at this goal. Some of the features of the approach are new; others are not new, but their effects on the programming language properties of spreadsheet systems have not been discussed before in the literature. We explore these properties, offer our solutions to problems that arise with these properties, and compare the functionality of the approach with that of exception handling approaches in other languages.