fileVersion

This contains file versioning properties, as follows.

• lastEdited – The version of the application that last saved the file.

• lowestEdited – The earliest version of the application that saved the file. This value is reset any time an application that understands all data in the file saves the file.

• rupBuild – An incremental public release of the application (e.g., RTM version or SP1 version).

• workbookPr – A group of various workbook properties.

• @backupFile – A flag that indicates whether the application should create a backup of the file in question during a save operation.

• saveExternalLinkValues – A flag that indicates whether the application should cache values retrieved from other workbooks via an externally linking formula during save. If yes, a supporting part is written out containing a cached cell table from the external workbook.

• updateLinks – A flag that dictates how external links are handled upon opening the file. In this example, never means don't ask the user if they want to refresh the cached values from an external workbook, and in fact, don't ever do it until the user initiates the action.

• calcPr – Various calculation properties grouped together.

• calcId – The version of the calculation engine used to calculate values in the workbook. When a newer version of the application opens a file with an older @calcId value, the application performs a full calculation of all formulas immediately after opening the workbook, to ensure proper calculation results.

• calcMode – A flag that indicates when the application should calculate formulas:

  • Manual means to wait for the user to initate the action.

  • Automatic means to perform only the needed calculations whenever a cell value changes.

• Iterate – When formula references are circular (i.e., they refer back on themselves for required input), the iterate flag specifies that this is an intended and valid state. Further properties not discussed here control the number of iterative calculations to perform before stopping calculation.

• bookViews – A collection of views.