OREGON STATE UNIVERSITY

You are here

Systematic evolution of model-based spreadsheet applications

TitleSystematic evolution of model-based spreadsheet applications
Publication TypeJournal Article
Year of Publication2012
AuthorsLuckey, M., M. Erwig, and G. Engels
JournalJournal of Visual Languages & Computing
Volume23
Issue5
Pagination267 - 286
Date Published10/2012
ISSN1045926X
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 paper, 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.

DOI10.1016/j.jvlc.2011.11.009
Short TitleJournal of Visual Languages & Computing