%0 Conference Paper
%B Theory and Practice of Model Transformations - ICMT
%D 2012
%T Bidirectional Transformation of Model-Driven Spreadsheets
%A Jácome Cunha
%A João Paulo Fernandes
%A Jorge Mendes
%A Hugo Pacheco
%A João Alexandre Saraiva
%E Zhenjiang Hu
%E Juan de Lara
%C Prague, Czech Republic
%I Springer
%P 105–120
%S Lecture Notes in Computer Science
%V 7307
%X <p>Spreadsheets play an important role in software organizations. Indeed, in large software organizations, spreadsheets are not only used to dene sheets containing data and formulas, but also to collect information from dierent 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.<br /> 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 dened 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.</p>
%8 May
%@ 978-3-642-30475-0
%> https://haslab.uminho.pt/sites/default/files/jacome/files/icmt12.pdf