Static Analysis for Spreadsheet Applications for Type-Unsafe Operations Detection - INRIA - Institut National de Recherche en Informatique et en Automatique Accéder directement au contenu
Communication Dans Un Congrès Année : 2015

Static Analysis for Spreadsheet Applications for Type-Unsafe Operations Detection

Tie Cheng
  • Fonction : Auteur
  • PersonId : 933513

Résumé

Spreadsheets are widely used, yet are error-prone: they use a weak type system, allowing certain operations that will silently return unexpected results, like comparisons of integer values with string values. However, discovering these issues is hard, since data and formulas can be dynamically set, read or modified. We propose a static analysis that de- tects all run-time type-unsafe operations in spreadsheets. It is based on an abstract interpretation of spreadsheet applications, including spreadsheet tables, global re-evaluation and associated programs. Our implementation supports the features commonly found in real-world spreadsheets. We ran our analyzer on the EUSES Spreadsheet Corpus. This evaluation shows that our tool is able to automatically verify a large number of real spread- sheets, runs in a reasonable time and discovers complex bugs that are difficult to detect by code review or by testing.
Fichier non déposé

Dates et versions

hal-01098377 , version 1 (24-12-2014)

Identifiants

  • HAL Id : hal-01098377 , version 1

Citer

Tie Cheng, Xavier Rival. Static Analysis for Spreadsheet Applications for Type-Unsafe Operations Detection. European Symposium On Programming (ESOP 2015), Apr 2015, London, United Kingdom. ⟨hal-01098377⟩
102 Consultations
0 Téléchargements

Partager

Gmail Facebook X LinkedIn More