3.2.1.2 Worksheet Sort Map Part

  • Article

Content Type

application/vnd.ms-excel.wsSortMap+xml

Root Namespace

http://schemas.microsoft.com/office/excel/2006/main

Source Relationship

http://schemas.microsoft.com/office/2006/relationships/wsSortMap

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 ("[ISO/IEC-29500-1] §12.3.24").

[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"/>
 </Relationships>

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"/>
   </rowSortMap>
 </worksheetSortMap>

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 Office Open XML File Formats [ISO/IEC-29500-1].