Dependence tracing techniques for spreadsheets: An investigation

Sohon Roy, Felienne Hermans

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

64 Downloads (Pure)

Abstract

Spreadsheet cells contain data but also may contain formulas that refer to data from other cells, perform operations on them, and render the results directly to show it to the user. In order to understand the structure of spreadsheets, one needs to understand the formulas that control cell-to-cell dataflow. Understanding this cell-to-cell inter-relation or dependence tracing is easier done in visual manners and therefore quite a few techniques have been proposed over the years. This paper aims to report the results of an investigative study of such techniques. The study is a first step of an attempt to evaluate the relevance of these techniques from the point of view of their benefits and effectiveness in the context of real world spreadsheet users. Results obtained from such a study will have the potential for motivating the conception of newer and better techniques, in case it is found that the need for them is still not fully catered.
Original languageEnglish
Title of host publicationSoftware Engineering Methods in Spreadsheets
Subtitle of host publicationFirst International Workshop
EditorsFelienne Hermans, Richard F. Paige, Peter Sestoft
Place of PublicationDelft
PublisherCEUR-WS
Pages32-35
Number of pages4
Volume1209
Publication statusPublished - 2 Jul 2014
EventSems 14: Workshop on Software
Engineering Methods in Spreadsheets
- Delft, Netherlands
Duration: 2 Jul 20142 Jul 2014

Conference

ConferenceSems 14: Workshop on Software
Engineering Methods in Spreadsheets
Country/TerritoryNetherlands
CityDelft
Period2/07/142/07/14

Fingerprint

Dive into the research topics of 'Dependence tracing techniques for spreadsheets: An investigation'. Together they form a unique fingerprint.

Cite this