Validating the unit correctness of spreadsheet programs

  title={Validating the unit correctness of spreadsheet programs},
  author={Tudor Antoniu and P. A. Steckler and S. Krishnamurthi and E. Neuwirth and M. Felleisen},
  journal={Proceedings. 26th International Conference on Software Engineering},
  • Tudor Antoniu, P. A. Steckler, +2 authors M. Felleisen
  • Published 2004
  • Computer Science
  • Proceedings. 26th International Conference on Software Engineering
  • Financial companies, engineering firms and even scientists create increasingly larger spreadsheets and spreadsheet programs. The creators of large spreadsheets make errors and must track them down. One common class of errors concerns unit errors, because spreadsheets often employ formulas with physical or monetary units. In this paper, we describe XeLda, our tool for unit checking Excel spreadsheets. The tool highlights cells if their formulas process values with incorrect units and if derived… CONTINUE READING
    86 Citations

    Figures and Topics from this paper

    Explore Further: Topics Discussed in This Paper

    ExceLint: automatically finding spreadsheet formula errors
    • 22
    • PDF
    Automated model-based spreadsheet debugging
    • PDF
    Gencel: a program generator for correct spreadsheets
    • 54
    • PDF
    Introducing Units in Spreadsheets
    Spreadsheet Programming
    • 13
    • PDF
    Toward model-based debugging of spreadsheet programs
    • 25
    • PDF
    SS-BDD: Automated Acceptance Testing for Spreadsheets
    • 2
    Avoiding, finding and fixing spreadsheet errors - A survey of automated approaches for spreadsheet QA
    • 52
    Using objects of measurement to detect spreadsheet errors
    • 36
    • PDF
    Static Analysis of Spreadsheet Applications for Type-Unsafe Operations Detection
    • 7
    • PDF