office:spreadsheet

Element information

Content

• Sequence [1..1]
  from group text:office-spreadsheet-content-prelude
  table:tracked-changes [0..1]    
  from group text:text-decls
  text:variable-decls [0..1]    
  text:sequence-decls [0..1]    
  text:user-field-decls [0..1]    
  text:dde-connection-decls [0..1]    
  text:alphabetical-index-auto-mark-file [0..1]    
  from group text:table-decls
  table:calculation-settings [0..1]    
  table:content-validations [0..1]    
  table:label-ranges [0..1]    
  from group text:office-spreadsheet-content-main
  table:table [0..*]    
  from group text:table-functions
  table:named-expressions [0..1]    
  table:database-ranges [0..1]    
  table:data-pilot-tables [0..1]    
  table:consolidation [0..1]    
  table:dde-links [0..1]    

Attributes

Used in

• Type text:office-body-content (Element office:body)

Substitution hierarchy

• text:office-body-content
  • can be substituted with office:spreadsheet

Sample instance

<office:spreadsheet table:protection-key="string">
   <table:tracked-changes>
      <table:cell-content-change table:id="string">
         <table:cell-address table:column="1" table:row="1" table:table="1"/>
         <office:change-info>...
         </office:change-info>
         <table:dependencies>...
         </table:dependencies>
         <table:deletions>...
         </table:deletions>
         <table:previous>...
         </table:previous>
      </table:cell-content-change>
   </table:tracked-changes>
   <text:variable-decls>
      <text:variable-decl text:name="string" office:value-type="float"/>
   </text:variable-decls>
   <text:sequence-decls>
      <text:sequence-decl text:name="string" text:display-outline-level="1"/>
   </text:sequence-decls>
   <text:user-field-decls>
      <text:user-field-decl text:name="string" office:value-type="float"/>
   </text:user-field-decls>
   <text:dde-connection-decls>
      <text:dde-connection-decl office:name="string" office:dde-application="string" office:dde-topic="string" office:dde-item="string"/>
   </text:dde-connection-decls>
   <text:alphabetical-index-auto-mark-file xlink:href="http://www.example.com/"/>
   <table:calculation-settings table:case-sensitive="true">
      <table:null-date/>
      <table:iteration/>
   </table:calculation-settings>
   <table:content-validations>
      <table:content-validation table:name="string">
         <table:help-message>...
         </table:help-message>
         <table:error-message>...
         </table:error-message>
      </table:content-validation>
   </table:content-validations>
   <table:label-ranges>
      <table:label-range table:label-cell-range-address="string" table:data-cell-range-address="string" table:orientation="column"/>
   </table:label-ranges>
   <table:table table:name="string" table:protection-key="any text content">
      <table:table-source xlink:actuate="onRequest" xlink:href="http://www.example.com/" table:refresh-delay="P1Y2M3DT10H"/>
      <office:dde-source office:dde-application="string" office:dde-topic="string" office:dde-item="string"/>
      <table:scenario table:scenario-ranges="string" table:is-active="true"/>
      <office:forms>
         <form:form xlink:actuate="onRequest">...
         </form:form>
      </office:forms>
      <table:shapes>
         <draw:rect svg:x="string" svg:y="string" svg:width="string" svg:height="string" draw:id="ID" draw:name="string">...
         </draw:rect>
      </table:shapes>
      <table:table-column-group>
         <table:table-column-group>...
         </table:table-column-group>
      </table:table-column-group>
      <table:table-row-group>
         <table:table-row-group>...
         </table:table-row-group>
      </table:table-row-group>
   </table:table>
   <table:named-expressions>
      <table:named-range table:name="string" table:cell-range-address="string"/>
   </table:named-expressions>
   <table:database-ranges>
      <table:database-range table:name="string" table:orientation="column" table:target-range-address="string" table:refresh-delay="true">
         <table:database-source-sql table:database-name="string" table:sql-statement="string"/>
         <table:filter>...
         </table:filter>
         <table:sort table:case-sensitive="true">...
         </table:sort>
         <table:subtotal-rules table:case-sensitive="true">...
         </table:subtotal-rules>
      </table:database-range>
   </table:database-ranges>
   <table:data-pilot-tables>
      <table:data-pilot-table table:name="string" table:target-range-address="string">
         <table:database-source-sql table:database-name="string" table:sql-statement="string"/>
         <table:data-pilot-field table:source-field-name="string" table:orientation="row">...
         </table:data-pilot-field>
      </table:data-pilot-table>
   </table:data-pilot-tables>
   <table:consolidation table:function="auto" table:source-cell-range-addresses="string" table:target-cell-address="string"/>
   <table:dde-links>
      <table:dde-link>
         <office:dde-source office:dde-application="string" office:dde-topic="string" office:dde-item="string"/>
         <table:table table:name="string" table:protection-key="any text content">...
         </table:table>
      </table:dde-link>
   </table:dde-links>
</office:spreadsheet>