Metadata Behaviors

The metadata type expresses operations on cells that allow the metadata to remain associated with the cell. Operations not listed or set to '0' would cause the metadata to no longer be associated with the cell.

<metadataTypes count="1">
  <metadataType name="XLMDX" minSupportedVersion="120000" copy="1"
    pasteAll="1" pasteValues="1" merge="1" splitFirst="1"
    rowColShift="1" clearFormats="1" clearComments="1" assign="1"
    coerce="1"/>
</metadataTypes>

Regarding <metadataTypes>:

  • @count is the number of <metadataType> elements.

  • @type is a particular set of cell operations.

Regarding <metadataType>:

  • @name is the name of this particular metadata type.

  • @minSupportedVersion indicates the earliest version of the application which supports this metadata type.

  • @copy value of 1 indicates that this metadata will be copied to other cells when the cell is copied.

  • @pasteAll value of 1 indicates that this metadata will be pasted to another cell when 'paste all' is chosen during a copy/paste operation.

  • @pasteValues value of 1 indicates that this metadata will be pasted to another cell when only the values of the cell is pasted during a copy/paste operation.

  • @merge value of 1 indicates that when the cell is merged, the metadata associated with the cell remains.

  • @splitFirst value of 1 indicates that when a merged cell is split, the metadata associated with the merged cell is only applied to the first (from top left) cell resulting from the split.

  • @rowColShift value of 1 indicates that metadata associated with a cell remains after rows and columns are inserted, even when the cell is moved.

  • @clearFormats value of 1 indicates that the metadata remains after the cell has been cleared of all formatting.

  • @clearComments value of 1 indicates that the metadata remains after comments have been cleared from the cell.

  • @assign value of 1 indicates that the metadata propagates through formula assignment operations

  • @coerce value of 1 indicates that the metadata can be removed when the data type is coerced to another type.