[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Value
Meaning
0	Functions are calculated using the current application’s algorithms.
1	Functions are calculated using algorithms implemented in Office Excel 2007.
2	Functions are calculated using algorithms implemented in Excel 2010.

<9> Section 2.6.24: Office Excel 2007 does not support multiple uses of the same OLAP measure in one cache hierarchy, and does not discard the associated cache hierarchy when ignore is TRUE.

<10> Section 2.6.25: Office Excel 2007 will not ignore the fld attribute of the ancestor CT_DataField ([ISO/IEC29500-4:2011] section A.2).

<11> Section 2.6.30: Office Excel 2007 does not ignore these complex types.

<12> Section 2.6.31: Office Excel 2007 does not support multiple uses of the same OLAP measure in one PivotTable view, and does not ignore this pivot field when ignore is TRUE.

<13> Section 2.6.34: The 2007 Office system does not load a file in which this field (1) contains a value that it does not recognize, or is not recognized by the underlying operating system. The 2007 Office system recognizes the following language tags.