The Significant Properties Of Spreadsheets

Abstract

When preserving spreadsheets, in certain cases it is decided to convert the spreadsheet file format to an image-based file format such as TIF. However, during this conversion, a loss of information can occur. Certain functionalities cannot be translated to the new file format and therefore lose their meaning. An example of this are formulas. When converting towards an image-based file format, the outcome of the formula will still be displayed, but the calculation that is behind it is lost. It is therefore imperative to find out which properties in spreadsheets are significant, such that these can be preserved. The Open Preservation Foundation’s Archives Interest Group (OPF AIG) decided to research this using the InSPECT methodology, which consists of both an Object Analysis and a Stakeholder Analysis. These two types of analysis eventually led to a longer report which was published, in which not only our results were shared, but also a reusable and practice-tested method to apply the InSPECT methodology. In this paper, we present the main findings of our research.

Details

Creators
Van Veenendaal, Remco; Wijsman, Lotte; Skødt, Asbjørn; Sein, Kati; Takema, Jacob; O’sullivan, Jack
Institutions
National Archives of the Netherlands; Danish National Archives; National Archives of Estonia; Preservica
Date
Keywords
significant properties; spreadsheets; preservation; object analysis; stakeholder analysis
Publication Type
paper
License
CC BY 4.0 International
Direct Download
214333 bytes

View This Publication