Title (en)
The Significant Properties Of Spreadsheets
Language
English
Description (en)
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.
Keywords (en)
Significant Properties, Spreadsheets, Preservation, Object Analysis, Stakeholder Analysis
Author of the digital object
Remco Van Veenendaal  (National Archives of the Netherlands)
Author of the digital object
Lotte Wijsman  (National Archives of the Netherlands)
Author of the digital object
Asbjørn Skødt  (Danish National Archives)
Author of the digital object
Kati Sein  (National Archives of Estonia)
Author of the digital object
Jacob Takema  (National Archives of the Netherlands)
Author of the digital object
Jack O’sullivan  (Preservica)
Licence Selected
Conferences
iPRES Conference