Definition Type: ComplexType
Name: CT_WorkbookPr
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-workbook.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into defaultThemeVersion in schema sml-workbook_xsd Drilldown into refreshAllConnections in schema sml-workbook_xsd Drilldown into autoCompressPictures in schema sml-workbook_xsd Drilldown into checkCompatibility in schema sml-workbook_xsd Drilldown into publishItems in schema sml-workbook_xsd Drilldown into allowRefreshQuery in schema sml-workbook_xsd Drilldown into showPivotChartFilter in schema sml-workbook_xsd Drilldown into hidePivotFieldList in schema sml-workbook_xsd Drilldown into codeName in schema sml-workbook_xsd Drilldown into updateLinks in schema sml-workbook_xsd Drilldown into saveExternalLinkValues in schema sml-workbook_xsd Drilldown into backupFile in schema sml-workbook_xsd Drilldown into showInkAnnotation in schema sml-workbook_xsd Drilldown into promptedSolutions in schema sml-workbook_xsd Drilldown into filterPrivacy in schema sml-workbook_xsd Drilldown into showBorderUnselectedTables in schema sml-workbook_xsd Drilldown into showObjects in schema sml-workbook_xsd Drilldown into date1904 in schema sml-workbook_xsdXSD Diagram of CT_WorkbookPr in schema sml-workbook_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_WorkbookPr">
    <xsd:attribute name="date1904" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Date 1904</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showObjects" type="ST_Objects" use="optional" default="all">
        <xsd:annotation>
            <xsd:documentation>Show Objects</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showBorderUnselectedTables" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Border Unselected Table</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="filterPrivacy" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Filter Privacy</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="promptedSolutions" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Prompted Solutions</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showInkAnnotation" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Ink Annotations</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="backupFile" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Create Backup File</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="saveExternalLinkValues" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Save External Link Values</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="updateLinks" type="ST_UpdateLinks" use="optional" default="userSet">
        <xsd:annotation>
            <xsd:documentation>Update Links Behavior</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="codeName" type="xsd:string" use="optional">
        <xsd:annotation>
            <xsd:documentation>Code Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hidePivotFieldList" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Hide Pivot Field List</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPivotChartFilter" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Pivot Chart Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allowRefreshQuery" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Allow Refresh Query</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="publishItems" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Publish Items</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="checkCompatibility" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Check Compatibility On Save</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="autoCompressPictures" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Auto Compress Pictures</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshAllConnections" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Refresh all Connections on Open</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultThemeVersion" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Default Theme Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Attributes:
Name Type Default Value Use
date1904 nsM:date1904 false Optional
showObjects nsM:showObjects all Optional
showBorderUnselectedTables nsM:showBorderUnselectedTables true Optional
filterPrivacy nsM:filterPrivacy false Optional
promptedSolutions nsM:promptedSolutions false Optional
showInkAnnotation nsM:showInkAnnotation true Optional
backupFile nsM:backupFile false Optional
saveExternalLinkValues nsM:saveExternalLinkValues true Optional
updateLinks nsM:updateLinks userSet Optional
codeName nsM:codeName Optional
hidePivotFieldList nsM:hidePivotFieldList false Optional
showPivotChartFilter nsM:showPivotChartFilter false (Optional)
allowRefreshQuery nsM:allowRefreshQuery false Optional
publishItems nsM:publishItems false Optional
checkCompatibility nsM:checkCompatibility false Optional
autoCompressPictures nsM:autoCompressPictures true Optional
refreshAllConnections nsM:refreshAllConnections false Optional
defaultThemeVersion nsM:defaultThemeVersion Optional
Collapse Derivation Tree:
Collapse References:
nsM:workbookPr