Authors
Diogo Canteiro & Jacome Cunha
Abstract
Documentation is an important artefact of any software product. This is also the case for spreadsheets where, even considering an industrial setting, only 30% have some kind of documentation. This makes their usage and maintenance very difficult.
In this paper we describe a tool, SpreadsheetDoc, that allows users to document spreadsheets in a structured way, allowing them to describe different parts of spreadsheets.
For instance, for (future) spreadsheet users, it is possible to describe input and output cells, and for (future) developers, it is possible to describe computation, that is, formulas: their arguments, their internal computations, and their outputs.
Sample
Output cells are where the user usually sees the results produced by the other cells. Thus, these are probably the most important cells for end users.
The "Output" button opens a dialogue with two text boxes, one (in read-only mode) showing a list with all the output cells (name and type) of the spreadsheet, and a text box to describe the current selected output cell.
Publication
2015, 6th National Symposium of Informatics, September
Full article
SpreadsheetDoc: An Excel add-in for documenting spreadsheets
