Spreadsheet bibliography

Title A literature review of spreadsheet technology
Authors Alexander Bock
Year 2016
Type Article
Publication IT University of Copenhagen Technical Report Series
Series TR-2016-199, November, pages 1-33
Abstract

It was estimated that there would be over 55 million end-user programmers in 2012 in many different fields such as engineering, insurance and banking, and the numbers are not expected to have dwindled since.

Consequently, technological advancements of spreadsheets is of great interest to a wide number of people from different backgrounds.

This literature review presents an overview of research on spreadsheet technology, its challenges and its solutions. We also attempt to identify why software developers generally frown upon spreadsheets and how spreadsheet research can help alter this view.

Full version Available
Sample
A spreadsheet's support graph
A spreadsheet's support graph

This graph shows the data flow between spreadsheet cells.

Such a graph is used in many spreadsheet applications to track dependencies between non-empty cells and efficiently recalculate those affected by an update.