Bidirectional Transformation of Model-Driven Spreadsheets

• Type: Article in International Conference Proceedings Book
• Date: 2012

Authors

Cunha, J (Author) Other; Joao Paulo Fernandes (Author) FEUP; Mendes, J (Author) Other; Pacheco, H (Author) Other; Saraiva, J (Author) Other

Conference proceedings International

Title: Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Pages: 105-120

5th International Conference on Theory and Practice of Model Transformations, ICMT 2012

Prague, 28 May 2012 through 29 May 2012

Indexing

Scopus - 32 Citations

Other information

Authenticus ID: P-008-4BK

DOI: 10.1007/978-3-642-30476-7_7

Abstract (EN): Spreadsheets play an important role in software organizations. Indeed, in large software organizations, spreadsheets are not only used to define sheets containing data and formulas, but also to collect information from different systems, to adapt data coming from one system to the format required by another, to perform operations to enrich or simplify data, etc. In fact, over time many spreadsheets turn out to be used for storing and processing increasing amounts of data and supporting increasing numbers of users. Unfortunately, spreadsheet systems provide poor support for modularity, abstraction, and transformation, thus, making the maintenance, update and evolution of spreadsheets a very complex and error-prone task. We present techniques for model-driven spreadsheet engineering where we employ bidirectional transformations to maintain spreadsheet models and instances synchronized. In our setting, the business logic of spreadsheets is defined by ClassSheet models to which the spreadsheet data conforms, and spreadsheet users may evolve both the model and the data instances. Our techniques are implemented as part of the MDSheet framework: an extension for a traditional spreadsheet system. © 2012 Springer-Verlag.

Language: English

Type (Professor's evaluation): Scientific