valueMetadata

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 indicates the index of the <metadataType> record in <metadataTypes> collection.

  • v 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 type "XLMDX". This indicates that the @v index is pointing to the 0th <mdxMetadata> record.