Difference between revisions of "Significant characteristics of spreadsheets"

From Archivematica
Jump to navigation Jump to search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Main Page]] > [[Documentation]] > [[Media type preservation plans]] > [[Significant characteristics]] > Significant characteristics of spreadsheets
+
[[Main Page]] > [[Documentation]] > [[Format policies]] > [[Significant characteristics]] > Significant characteristics of spreadsheets
 +
 
 +
<div style="padding: 10px 10px; border: 1px solid black; background-color: #F79086;">This page is no longer being maintained and may contain inaccurate information. Please see the [https://www.archivematica.org/docs/latest/ Archivematica documentation] for up-to-date information.</div><p>
  
 
From Florida Digital Archive Plan: BIFF8 (http://www.fcla.edu/digitalArchive/formatInfo.htm):  
 
From Florida Digital Archive Plan: BIFF8 (http://www.fcla.edu/digitalArchive/formatInfo.htm):  

Latest revision as of 16:34, 11 February 2020

Main Page > Documentation > Format policies > Significant characteristics > Significant characteristics of spreadsheets

This page is no longer being maintained and may contain inaccurate information. Please see the Archivematica documentation for up-to-date information.

From Florida Digital Archive Plan: BIFF8 (http://www.fcla.edu/digitalArchive/formatInfo.htm):

BIFF8 exhibits the following significant characteristics. They are the significant characteristics which the Florida Digital Archive intends to preserve for adopting migration or normalization policy.

  • Content: All cell data and formula will be preserved. Chart and Pivot tables may not be preserved.
  • Context: Contextual information about the spreadsheet, such as author, title, etc, will be preserved.
  • Behavior: BIFF8 can encode VBA macros which can be used for defining custom spreadsheet behaviors. In addition, BIFF8 can contain external links to external sources. These behaviors may not be preserved.
  • Structure: Structural information such as the cell locations (row, column) and the nested worksheets will be preserved.
  • Appearance: BIFF8 can contain appearance attributes such as fonts, colors, sizes, cell formats, etc. Cell formats will be preserved. The rest of the appearance attributes may not be preserved.