Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All Worksheet Sort Map Part

Content Type


Root Namespace


Source Relationship


An instance of this part contains information about a series of before and after row or column mapping to resolve different sort operations performed on the same range by different users when the workbook is shared.

A package is permitted to contain zero or one Worksheet Sort Map part for each worksheet, and that part shall be the target of an implicit relationship from the Worksheet part ("[ECMA-376] Part 1 §12.3.24; Worksheet Part").

[Example: The following Worksheet part-relationship item contains a relationship to the Worksheet Sort Map part, which is stored in the ZIP item wsSortMap1.xml:

<Relationships xmlns="…">
  <Relationship Id="rId1" 
    Type="http://…/wsSortMap" Target="wsSortMap1.xml"/>

end example]

The root element for a part of this content type shall be worksheetSortMap.

[Example: This Worksheet Sort Map part results from a row sort on a range containing 3 rows:

<worksheetSortMap xmlns:st="…">
  <rowSortMap ref="A1:XFD3" count="3">
    <row newVal="0" oldVal="1"/>
    <row newVal="1" oldVal="2"/>
    <row newVal="2" oldVal="0"/>

end example]

A Worksheet Sort Map part shall be located within the package containing the source relationship (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Worksheet Sort Map part shall not have implicit or explicit relationships to any part defined by ECMA-376 Office Open XML File Formats [ECMA-376].

© 2015 Microsoft