L.2.8.3.2.5 valueMetadata

L.2.2 Sheets

This collection defines cell or value metadata information (depending on the value of metadataType’s cellMeta)

<valueMetadata count="26">
  <bk>
    <rc t="1" v="0"/>
  </bk>
  <bk>
    <rc t="1" v="1"/>
  </bk>
  <bk>
    <rc t="1" v="2"/>
  </bk>
  <bk>
    <rc t="1" v="3"/>
  </bk>
  <bk>
    <rc t="1" v="4"/>
  </bk>
  <bk>
    <rc t="1" v="5"/>
  </bk>
  <bk>
    <rc t="1" v="6"/>
  </bk>
  <bk>
    <rc t="1" v="7"/>
  </bk>
  <bk>
    <rc t="1" v="8"/>
  </bk>
  <bk>
    <rc t="1" v="9"/>
  </bk>
  <bk>
    <rc t="1" v="10"/>
  </bk>
  <bk>
    <rc t="1" v="11"/>
  </bk>
  <bk>
    <rc t="1" v="12"/>
  </bk>
  <bk>
    <rc t="1" v="13"/>
  </bk>
  <bk>
    <rc t="1" v="14"/>
  </bk>
  <bk>
    <rc t="1" v="15"/>
  </bk>
  <bk>
    <rc t="1" v="16"/>
  </bk>
  <bk>
    <rc t="1" v="17"/>
  </bk>
  <bk>
    <rc t="1" v="18"/>
  </bk>
  <bk>
    <rc t="1" v="19"/>
  </bk>
  <bk>
    <rc t="1" v="20"/>
  </bk>
  <bk>
    <rc t="1" v="21"/>
  </bk>
  <bk>
    <rc t="1" v="22"/>
  </bk>
  <bk>
    <rc t="1" v="23"/>
  </bk>
  <bk>
    <rc t="1" v="24"/>
  </bk>
  <bk>
    <rc t="1" v="25"/>
  </bk>
</valueMetadata>

Regarding valueMetadata:

count

indicates the number of metadata block records.

Regarding bk, which is a metadata block, and rc, which is a metadata record:

t
v

indicates the index of the metadataType record in metadataTypes collection. is the index of metadata record value in the storage corresponding to record type.

Looking at the first block using the bk element, the type of metadata with which this record is associated is the first (and only) metadataType record, which is of metadata type “XLMDX”. This indicates that the v index is pointing to the 0th mdxMetadata record.

Last updated on March 14, 2025

L.2.7.4.5 Custom Table Style L.2.9.3.4.5 Row Items