%0 Conference Paper %B Proceedings of the Software Engineering Track at the 27th Annual Symposium On Applied Computing - SAC %D 2012 %T From Relational ClassSheets to UML+OCL %A Jácome Cunha %A João Paulo Fernandes %A João Alexandre Saraiva %C Trento, Italy %I ACM %P 1151–1158 %X

Spreadsheets are among the most popular programming languages in the world. Unfortunately, spreadsheet systems were not tailored from scratch with modern programming language features that guarantee, as much as possible, program correctness. As a consequence, spreadsheets are populated with unacceptable amounts of errors. In other programming language settings, model-based approaches have been proposed to increase productivity and program e ectiveness. Within spreadsheets, this approach has also been followed, namely by ClassSheets. In this paper, we propose an extension to ClassSheets to allow the speci cation of spreadsheets that can be viewed as relational databases. Moreover, we present a transformation from ClassSheet models to UML class diagrams enriched with OCL constraints. This brings to the spreadsheet realm the entire paraphernalia of model validation techniques that are available for UML.

%8 March %> https://haslab.uminho.pt/sites/default/files/jacome/files/sac-se12.pdf