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.
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 TrueGrid that runs in the browser and uses Javascript as a programming language.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Adam, S., Schultz, U.P.: Towards tool support for spreadsheet-based domain-specific languages. In: Proceedings of the 2015 ACM SIGPLAN International Conference on Generative Programming: Concepts and Experiences, pp. 95–98. ACM (2015)
Cunha, J., Mendes, J., Saraiva, J., Visser, J.: Model-based programming environments for spreadsheets. Sci. Comput. Program. 96, 254–275 (2014)
Hermans, F.: Analyzing and Visualizing Spreadsheets. Ph.D. thesis, Delft University of Technology (2013)
Hermans, F., van der Storm, T.: Copy-paste tracking: fixing spreadsheets without breaking them. In: Proceedings of the International Conference on Live Coding (2015)
Jetbrains: Meta programming system (2016). https://www.jetbrains.com/mps/
Jones, S.P., Blackwell, A., Burnett, M.: A user-centred approach to functions in excel. ACM SIGPLAN Not. 38(9), 165–176 (2003)
Ko, A.J., Abraham, R., Beckwith, L., Blackwell, A.F., Burnett, M.M., Erwig, M., Scaffidi, C., Lawrance, J., Lieberman, H., Myers, B.A., Rosson, M.B., Rothermel, G., Shaw, M., Wiedenbeck, S.: The state of the art in end-user software engineering. ACM Comput. Surv. 43(3), 21 (2011). http://doi.acm.org/10.1145/1922649.1922658
Lieberman, H., Fry, C.: Bridging the gulf between code and behavior in programming. In: Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, CHI 1995, pp. 480–486. ACM Press/Addison-Wesley Publishing Co., New York (1995). http://dx.doi.org/10.1145/223904.223969
Mugridge, R., Cunningham, W.: Fit for Developing Software: Framework for Integrated Tests. Prentice Hall, Englewood Cliffs (2005)
Schrage, M.M., Swierstra, S.D.: Beyond ASCII - parsing programs with graphical presentations. J. UCS 14(21), 3414–3430 (2008)
Victor, B.: Inventing on principle (2012). http://vimeo.com/36579366
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing AG
About this paper
Cite this paper
Hermans, F., van der Storm, T. (2016). TrueGrid: Code the Table, Tabulate the Data. In: Milazzo, P., Varró, D., Wimmer, M. (eds) Software Technologies: Applications and Foundations. STAF 2016. Lecture Notes in Computer Science(), vol 9946. Springer, Cham. https://doi.org/10.1007/978-3-319-50230-4_29
Download citation
DOI: https://doi.org/10.1007/978-3-319-50230-4_29
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-50229-8
Online ISBN: 978-3-319-50230-4
eBook Packages: Computer ScienceComputer Science (R0)