Spreadsheet systems are live programming environments. Both the data and the code are right in front you, and if you edit either of them, the effects are immediately visible. Unfortunately, spreadsheets lack mechanisms for abstraction, such as classes, function definitions etc. Programming languages excel at abstraction, but most mainstream languages or integrated development environments (IDEs) do not support the interactive, live feedback loop of spreadsheets. As a result, exploring and testing of code is cumbersome and indirect. In this paper we propose a method to bring both worlds closer together, by juxtaposing ordinary code and spreadsheet-like grids in the IDE, called TrueGrid. Using TrueGrid spreadsheet cells can be programmed with a fully featured programming language. Spreadsheet users then may enjoy benefits of source code, including added abstractions, syntax highlighting, version control, etc. On the other hand, programmers may leverage the grid for interactive exploring and testing of code. We illustrate these benefits using a prototype implementation of True- Grid that runs in the browser and uses Javascript as a programming language.

Original languageEnglish
Title of host publicationSoftware Technologies
Subtitle of host publicationApplications and Foundations - STAF 2016 Collocated Workshops: DataMod, GCM, HOFM, MELO, SEMS, VeryComp, Revised Selected Papers
EditorsP. Milazzo, D. Varró, M. Wimmer
Place of PublicationCham
PublisherSpringer
Pages388-393
Number of pages6
ISBN (Electronic)978-3-319-50230-4
ISBN (Print)978-3-319-50229-8
DOIs
Publication statusPublished - 1 Jan 2016
EventSoftware Technologies: Applications and Foundations, STAF 2016 Collocated Workshops: 5th International Symposium on Data to Models and Back, DataMod 2016, 7th International Workshop on Graph Computation Models, GCM 2016, 3rd International Workshop on Human-Oriented Formal Methods, HOFM 2016, 2nd International Workshop on Model-Driven Engineering, Logic and Optimization, MELO 2016, 3rd International Workshop on Software Engineering Methods in Spreadsheets, SEMS 2016 and 1st International Workshop on Formal to Practical Software Verification and Composition, VeryComp 2016 - Vienna, Austria
Duration: 4 Jul 20168 Jul 2016

Publication series

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

Conference

ConferenceSoftware Technologies: Applications and Foundations, STAF 2016 Collocated Workshops: 5th International Symposium on Data to Models and Back, DataMod 2016, 7th International Workshop on Graph Computation Models, GCM 2016, 3rd International Workshop on Human-Oriented Formal Methods, HOFM 2016, 2nd International Workshop on Model-Driven Engineering, Logic and Optimization, MELO 2016, 3rd International Workshop on Software Engineering Methods in Spreadsheets, SEMS 2016 and 1st International Workshop on Formal to Practical Software Verification and Composition, VeryComp 2016
CountryAustria
CityVienna
Period4/07/168/07/16

ID: 45795816