A bidirectional model-driven spreadsheet environment

Cunha, Jácome; Fernandes, João Paulo; Mendes, Jorge; Saraiva, João

doi:10.1109/icse.2012.6227073

Cited by 5 publications

(2 citation statements)

References 6 publications

(8 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In this section we survey the code smells defined for spreadsheet formulas introduced in [28]. Moreover, we adapt each of these five smells to the spreadsheet models described in [10,11,13,18,12].…”

Section: Classsheets-models For Spreadsheetsmentioning

confidence: 99%

“…In the previous sections we have introduced the concept of smell and refactoring adapted to spreadsheet models, that is, to ClassSheets. In section 5.1 we will present how such smells can be detected under the MDSheet framework [13,11]. Moreover, in section 5.2 we will explain how the refactorings presented before can be incorporated under the same framework.…”

Section: Model-driven Spreadsheet Frameworkmentioning

confidence: 99%

See 1 more Smart Citation

Refactoring Smelly Spreadsheet Models

Martins

Pereira

2014

Computational Science and Its Applications – ICCSA 2014

View full text Add to dashboard Cite

Identifying bad design patterns in software is a successful and inspiring research trend. While these patterns do not necessarily correspond to software errors, the fact is that they raise potential problematic issues, often referred to as code smells, and that can for example compromise maintainability or evolution. The identification of code smells in spreadsheets, which can be viewed as software development environments for non-professional programmers, has already been the subject of confluent researches by different groups. While these research groups have focused on detecting smells on concrete spreadsheets, or spreadsheet instances, in this paper we propose a comprehensive set of smells for abstract representations of spreadsheets, or spreadsheet models. We also propose a set of refactorings suggesting how spreadsheet models can become simpler to understand, manipulate and evolve. Finally we present the integration of both smells and refactorings under the MDSheet framework.

show abstract

Section: Classsheets-models For Spreadsheetsmentioning

confidence: 99%

Section: Model-driven Spreadsheet Frameworkmentioning

confidence: 99%

Refactoring Smelly Spreadsheet Models

Martins

Pereira

2014

Computational Science and Its Applications – ICCSA 2014

View full text Add to dashboard Cite

show abstract

Adding Spreadsheets to the MDE Toolkit

Francis

Kolovos

Matragkas

et al. 2013

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Spreadsheet quality assurance: a literature review

Poon,

Lau,

et al. 2024

Front. Comput. Sci.

View full text Add to dashboard Cite

Spreadsheets are very common for information processing to support decision making by both professional developers and non-technical end users. Moreover, business intelligence and artificial intelligence are increasingly popular in the industry nowadays, where spreadsheets have been used as, or integrated into, intelligent or expert systems in various application domains. However, it has been repeatedly reported that faults often exist in operational spreadsheets, which could severely compromise the quality of conclusions and decisions based on the spreadsheets. With a view to systematically examining this problem via survey of existing work, we have conducted a comprehensive literature review on the quality issues and related techniques of spreadsheets over a 35.5-year period (from January 1987 to June 2022) for target journals and a 10.5-year period (from January 2012 to June 2022) for target conferences. Among other findings, two major ones are: (a) Spreadsheet quality is best addressed throughout the whole spreadsheet life cycle, rather than just focusing on a few specific stages of the life cycle. (b) Relatively more studies focus on spreadsheet testing and debugging (related to fault detection and removal) when compared with spreadsheet specification, modeling, and design (related to development). As prevention is better than cure, more research should be performed on the early stages of the spreadsheet life cycle. Enlightened by our comprehensive review, we have identified the major research gaps as well as highlighted key research directions for future work in the area.

show abstract

A bidirectional model-driven spreadsheet environment

Cited by 5 publications

References 6 publications

Refactoring Smelly Spreadsheet Models

Refactoring Smelly Spreadsheet Models

Adding Spreadsheets to the MDE Toolkit

Spreadsheet quality assurance: a literature review

Contact Info

Product

Resources

About