12.3.7 Dialogsheet Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.dialogsheet+xml

Root Namespace:

http://purl.oclc.org/ooxml/spreadsheetml/main

Source Relationship:

http://purl.oclc.org/ooxml/officeDocument/relationships/dialogsheet

An instance of this part type contains information about a legacy custom dialog box for a user form.

A package is permitted to contain one or more Dialogsheet parts, and each such part shall be the target of an explicit relationship from the Workbook part (12.3.23).

[Example: The following Workbook part-relationship item contains relationships to a Dialogsheet part, which is stored in the ZIP item dialogsheets/sheet1.xml:

<Relationships xmlns="…">
  <Relationship Id="rId2"
    Type="http://…/dialogsheet" Target="dialogsheets/sheet1.xml"/>
</Relationships>

The Workbook part contains the following:

<workbook xmlns:r="…" …>
  …
  <sheets>
    …
    <sheet name="Dialog1"
  </sheets>
  …
</workbook>

end example]

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

[Example: sheet1.xml contains the following:

<dialogsheet xmlns:r="…" …>
  <sheetPr>
    <pageSetUpPr/>
  </sheetPr>
  <sheetViews>
    …
  </sheetViews>
    …
  <legacyDrawing r:id="rId1"/>
</dialogsheet>

end example]

A Dialogsheet part shall be located within the package containing the relationships part (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Dialogsheet part is permitted to have implicit relationships to the following parts defined by ISO/IEC 29500:

• Printer Settings (15.2.15)

A Dialogsheet part is permitted to have explicit relationships to the following parts defined by ISO/IEC 29500:

• Embedded Control Persistence (15.2.9)
• Drawings (12.3.8)
• Embedded Object (15.2.10)

A Dialogsheet part shall not have implicit or explicit relationships to any other part defined by ISO/IEC 29500.