Article
 

Systematic Evolution of Model-Based Spreadsheet Applications

Public Deposited

Downloadable Content

Download PDF
https://ir.library.oregonstate.edu/concern/articles/3r074w31n

Descriptions

Attribute NameValues
Creator
Abstract
  • Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications, although they have one critical drawback—spreadsheets are very error-prone. Recent research has developed methods to reduce this error-proneness by introducing a new way of object-oriented modeling of spreadsheets before using them. These spreadsheet models, termed ClassSheets, are used to generate concrete spreadsheets on the instance level. By this approach sources of errors are reduced and spreadsheet applications become easier to understand. As usual for almost every other application, requirements on spreadsheets change due to the changing environment. Thus, the problem of evolution of spreadsheets arises. The update and evolution of spreadsheets is the uttermost source of errors that may have severe impact. In this article, we will introduce a model-based approach to spreadsheet evolution by propagating updates on spreadsheet models (i.e. ClassSheets) to spreadsheets. To this end, update commands for the ClassSheet layer are automatically transformed to those for the spreadsheet layer. We describe spreadsheet model update propagation using a formal framework and present an integrated tool suite that allows the easy creation and safe update of spreadsheet models. The presented approach greatly contributes to the problem of software evolution and maintenance for spreadsheets and thus avoids many errors that might have severe impacts.
  • This is the author's manuscript version. The published article is copyrighted by Elsevier and can be found at: http://www.journals.elsevier.com/journal-of-visual-languages-and-computing/.
  • Keywords: propagation, update, evolution, spreadsheet, model-based
Resource Type
DOI
Date Available
Date Issued
Citation
  • Luckey, M., Erwig, M., & Engels, G. (2012). Systematic evolution of model-based spreadsheet applications. JOURNAL OF VISUAL LANGUAGES AND COMPUTING, 23(5), 267-286. doi: 10.1016/j.jvlc.2011.11.009
Journal Title
Journal Volume
  • 23
Journal Issue/Number
  • 5
Rights Statement
Publisher
Peer Reviewed
Language
Replaces

Relationships

Parents:

This work has no parents.

Items

Thumbnail Title Date Uploaded Visibility Actions
file details ErwigMartinEECSSystematicEvolutionModel.pdf 2017-07-18 Public Download