Bidirectional transformation of model-driven spreadsheets

Jácome Cunha, João P. Fernandes, Jorge Mendes, Hugo Pacheco, João Saraiva

Research output: Chapter in Book/Report/Conference proceedingConference contribution


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.

Original languageEnglish (US)
Title of host publicationTheory and Practice of Model Transformations - 5th International Conference, ICMT 2012, Proceedings
Number of pages16
StatePublished - 2012
Event5th International Conference on Theory and Practice of Model Transformations, ICMT 2012 - Prague, Czech Republic
Duration: May 28 2012May 29 2012

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume7307 LNCS
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349


Conference5th International Conference on Theory and Practice of Model Transformations, ICMT 2012
Country/TerritoryCzech Republic


  • Bidirectional Transformation
  • Data Evolution
  • Model Synchronization
  • Software Evolution
  • Spreadsheets

ASJC Scopus subject areas

  • Theoretical Computer Science
  • General Computer Science


Dive into the research topics of 'Bidirectional transformation of model-driven spreadsheets'. Together they form a unique fingerprint.

Cite this