Dialogsheet Part

Content Type:

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

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/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:

<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" tabId="4" type="dialog" r:id="rId2"/>
  </sheets>
  …
</workbook>

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

example:

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

A Dialogsheet part shall be located within the package containing the source relationship (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 this Standard:

Printer Settings (§15.2.14)

A Dialogsheet part is permitted to have explicit relationships to the following parts defined by this Standard:

Embedded Control Persistence (§15.2.8)
Drawings (§12.3.8)
Embedded Object (§15.2.9)

A Dialogsheet part shall not have implicit or explicit relationships to any other part defined by this Standard.