Schema Central > OpenDocument 1.1 > office.xsd > office:spreadsheet
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

office:spreadsheet

Element information

Type: Anonymous

Properties: Global, Qualified

Content

Attributes

NameOccTypeDescriptionNotes
table:structure-protected [0..1]text:booleanDefault value is "false". from group text:office-spreadsheet-attlist
table:protection-key [1..1]text:stringfrom group table:protection-key1

Used in

Substitution hierarchy

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>

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to contrib@functx.com