openxml - 公式元素中的 t ="shared"是什么意思？

Question

检查 XLSX 文件中的单元格元素时，我发现以下公式元素:

<f t="shared" si="0"/>

这样的公式元素是什么意思？

Answer 1

ECMA-376第 1 部分第 18.3.1.40 节说:

The possible values for the t attribute are defined by the simple type ST_CellFormulaType, and are as follows:

...
shared (Shared formula)
...

Shared formula. If a cell contains the same formula as another cell, the "shared" value can be used for the t attribute and the si attribute can be used to refer to the cell containing the formula. Two formulas are considered to be the same when their respective representations in R1C1-reference notation, are the same.

基本上它是一种节省空间的优化。对于解析/修改文件的任何人来说，这肯定是一种痛苦。