A bidirectional model-driven spreadsheet environment
Jácome Cunha,João Paulo Fernandes,Jorge Mendes,João Saraiva +3 more
- 02 Jun 2012
- pp 1443-1444
TL;DR: This extended abstract presents a bidirectional model-driven framework to develop spreadsheets that allows to evolve a spreadsheet model and automatically have the data co-evolved.
read more
Abstract: In this extended abstract we present a bidirectional model-driven framework to develop spreadsheets. By being model driven, our approach allows to evolve a spreadsheet model and automatically have the data co-evolved. The bidirectional component achieves precisely the inverse, that is, to evolve the data and automatically obtain a new model to which the data conforms.
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
Citations
Adding Spreadsheets to the MDE Toolkit
Mărtinš Francis,Dimitrios S. Kolovos,Nicholas Matragkas,Richard F. Paige +3 more
- 29 Sep 2013
TL;DR: It is argued for the usefulness of model management support for querying and modifying spreadsheets, the conceptual gap between contemporary model management languages and spreadsheets is identified, and an approach for bridging it is proposed.
22
Combining Models for Improved Fault Localization in Spreadsheets
TL;DR: This paper explains how to use MBSD for fault localization in spreadsheets and compares three types of models for MBSD, namely the value-based model (VBM), the dependency based model (DBM), and an improved version of the DBM, which indicates that the combined approach computes the same number of diagnoses like the VBMs while requiring less computation time.
16
Refactoring Meets Model-Driven Spreadsheet Evolution
Jácome Cunha,João Paulo Fernandes,Pedro Martins,Rui Pereira,João Saraiva +4 more
- 15 Dec 2014
TL;DR: This paper presents a set of refactoring for Class Sheets, a modelling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion and proposes an automatic evolution of the data so it is always synchronized with the model.
•Proceedings Article
A semantic meta model of spreadsheets
Thomas Reschenhofer,Bernhard Waltl,Sirma Gjorgievska,Florian Matthes +3 more
- 01 Jan 2016
TL;DR: This paper proposes a meta model which defines how the semantic models of today’s spreadsheets can be described, and builds on the foundations of related approaches to model-driven spreadsheet development, and also captures semantic patterns of spreadsheets typically occurring in practice.
4
Refactoring Smelly Spreadsheet Models
Pedro Martins,Rui Pereira +1 more
- 30 Jun 2014
TL;DR: Identifying bad design patterns in software is a successful and inspiring research trend that raises potential problematic issues, often referred to as code smells, that can compromise maintainability or evolution.
References
Visual specifications of correct spreadsheets
Robin Abraham,Martin Erwig,Steve Kollmansberger,E. Seifert +3 more
- 20 Sep 2005
TL;DR: A visual specification language for spreadsheets that allows the definition of spreadsheet templates is introduced and it can be shown that spreadsheets created in this way are free from a large class of errors, such as reference, omission, and type errors.
MDSheet: a framework for model-driven spreadsheet engineering
Jácome Cunha,João Paulo Fernandes,Jorge Mendes,João Saraiva +3 more
- 02 Jun 2012
TL;DR: This framework offers a model-driven software development mechanism for spreadsheet users and provides a framework for the embedding, evolution and inference of spreadsheet models.
Bidirectional transformation of model-driven spreadsheets
Jácome Cunha,João Paulo Fernandes,Jorge Mendes,Hugo Pacheco,João Saraiva +4 more
- 28 May 2012
TL;DR: This work presents techniques for model-driven spreadsheet engineering where it employs bidirectional transformations to maintain spreadsheet models and instances synchronized and is implemented as an extension for a traditional spreadsheet system.
Two corpuses of spreadsheet errors
Raymond R. Panko
- 04 Jan 2000
TL;DR: This paper presents two corpora of errors seen in spreadsheet experiments, hoping these corpora will help assess the claims of spreadsheet reduction approaches and should guide theory creation and testing.
Embedding and evolution of spreadsheet models in spreadsheet systems
Jácome Cunha,Jorge Mendes,João Saraiva,João Paulo Fernandes +3 more
- 10 Nov 2011
TL;DR: This paper presents its work on extending a widely used spreadsheet system with such a model-driven spreadsheet engineering environment and uses advanced techniques to evolve spreadsheets and models and to have them synchronized.