[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

dialogsheet (Dialog Sheet)

This is the root element for Sheet Parts of type 'dialogsheet'.

Parent Elements

Root element of SpreadsheetML Dialogsheet part


Child Elements


customSheetViews (Custom Sheet Views)


drawing (Drawing)


extLst (Future Feature Data Storage Area)


headerFooter (Header Footer Settings)


legacyDrawing (Legacy Drawing Reference)


legacyDrawingHF (Legacy Drawing Reference in Header Footer)


oleObjects (Embedded Objects)


pageMargins (Page Margins)


pageSetup (Page Setup Settings)


printOptions (Print Options)


sheetFormatPr (Sheet Format Properties)


sheetPr (Sheet Properties)


sheetProtection (Sheet Protection Options)


sheetViews (Sheet Views)


The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Dialogsheet">


   <element name="sheetPr" minOccurs="0" type="CT_SheetPr"/>

   <element name="sheetViews" minOccurs="0" type="CT_SheetViews"/>

   <element name="sheetFormatPr" minOccurs="0" type="CT_SheetFormatPr"/>

   <element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1"/>

   <element name="customSheetViews" minOccurs="0" type="CT_CustomSheetViews"/>

   <element name="printOptions" minOccurs="0" type="CT_PrintOptions"/>

   <element name="pageMargins" minOccurs="0" type="CT_PageMargins"/>

   <element name="pageSetup" minOccurs="0" type="CT_PageSetup"/>

   <element name="headerFooter" minOccurs="0" type="CT_HeaderFooter"/>

   <element name="drawing" minOccurs="0" type="CT_Drawing"/>

   <element name="legacyDrawing" minOccurs="0" type="CT_LegacyDrawing"/>

   <element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>

   <element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>