Open AccessBook Chapter10.1007/978-3-319-50230-4_29

TrueGrid: Code the Table, Tabulate the Data

- 04 Jul 2016

- pp 388-393

TL;DR: Programming languages excel at abstraction, but most mainstream languages or integrated development environments (IDEs) do not support the interactive, live feedback loop of spreadsheets, so exploring and testing of code is cumbersome and indirect.

Abstract: 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.

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

Most frequently asked questions

1. What are the contributions mentioned in the paper "Truegrid: code the table, tabulate the data" ?

In this paper the authors propose a method to bring both worlds closer together, by juxtaposing ordinary code and spreadsheet-like grids in the IDE, called TrueGrid.

2. What have the authors stated for future works in "Truegrid: code the table, tabulate the data" ?

Further research is needed to empirically investigate the benefits of TrueGrid from both the programmer and spreadsheet user perspectives.

Fig. 3. Mockup of TrueGrid for spreadsheet use

Fig. 2. A True Grid implementation, with the code editor on the left hand side and the grid on the righ, available via http://www.felienne.com/TrueGrid/

Fig. 1. Live programming: on the right the source code and on the left its instantiation of the code which changes immediately when the code is updated, screenshot from [11].

Fig. 4. Exploring function behavior using TrueGrid

Citations

•Dissertation•10.21954/OU.RO.00010AC4

The 'lish' : a data model for grid free spreadsheets

Alan Geoffrey Hall

- 28 Nov 2019

TL;DR: A “lish calculus” is developed, an extension to vector arithmetic for hierarchical structures that provides a concise notation for calculations with lishes that simplifies the usual spreadsheet formula expressions, and enables the machine to interpret them consistently with the context in which they are located.

...read moreread less

Journal Article•10.1016/J.JSS.2018.03.064

On some end-user programming constructs and their understandability

Michal Mackowiak, +2 more

- 01 Aug 2018

- Journal of Systems and Software

TL;DR: Evaluating the understandability of a set of programming constructs based on the spreadsheet metaphor from the point of view of end-user programmers in the context of Management Information found them to be an interesting option when designing an end- user programming language for domain experts.

...read moreread less

References

•Journal Article•10.1145/1922649.1922658

The state of the art in end-user software engineering

Amy J. Ko, +13 more

- 29 Apr 2011

- ACM Computing Surveys

TL;DR: This article summarizes and classifies research on end-user software engineering activities, defining the area of End-User Software Engineering (EUSE) and related terminology, and addresses several crosscutting issues in the design of EUSE tools.

...read moreread less

666

•Book Chapter•10.1007/978-3-642-33182-4_10

Model-based programming environments for spreadsheets

Jácome Cunha, +2 more

- 23 Sep 2012

- Science of Computer Programming

TL;DR: A method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment is devised.

...read moreread less

•Journal Article•10.1016/J.SCICO.2014.02.002

Model-based programming environments for spreadsheets

CunhaJácome, +3 more

- 15 Dec 2014

- Science of Computer Programming

TL;DR: In this article, the authors describe the limitations of spreadsheets as a flexible programming environment, but they lack some of the concepts of regular programming languages, such as structured data types.

...read moreread less

Proceedings Article•10.1145/2814204.2814215

Towards tool support for spreadsheet-based domain-specific languages

Sorin Adam, +1 more

- 26 Oct 2015

- Sigplan Notices

TL;DR: A simple notion of two-dimensional grammars for SDSLs are defined, and it is shown how such Grammars can be used for automatically generating parsers that extract structured data from a spreadsheet in the form of an AST.

...read moreread less

•Journal Article

Beyond ASCII - Parsing Programs with Graphical Presentations

Martijn M. Schrage, +1 more

- 01 Jan 2008

- Journal of Universal Computer Science

TL;DR: This paper explains the scanning and parsing process for presentations that are a possibly nested combination of text and graphical elements in Proxima, which is especially well-suited for defining source editors for programming languages.

...read moreread less

TrueGrid: Code the Table, Tabulate the Data

Chat with Paper

AI Agents for this Paper

Most frequently asked questions

1. What are the contributions mentioned in the paper "Truegrid: code the table, tabulate the data" ?

2. What have the authors stated for future works in "Truegrid: code the table, tabulate the data" ?

Figures

Citations

The 'lish' : a data model for grid free spreadsheets

On some end-user programming constructs and their understandability

References

The state of the art in end-user software engineering

Model-based programming environments for spreadsheets

Model-based programming environments for spreadsheets

Towards tool support for spreadsheet-based domain-specific languages

Beyond ASCII - Parsing Programs with Graphical Presentations

Related Papers (5)

Co-evolution as the key for live programming

Towards multilingual programming environments

A programming environment for Visual block-based domain-specific languages

Language-Parametric Methods for Developing Interactive Programming Systems

Reflection and Hyper-Programming in Persistent Programming Systems