| <!--*********************************************************** | |
| * | |
| * Licensed to the Apache Software Foundation (ASF) under one | |
| * or more contributor license agreements. See the NOTICE file | |
| * distributed with this work for additional information | |
| * regarding copyright ownership. The ASF licenses this file | |
| * to you under the Apache License, Version 2.0 (the | |
| * "License"); you may not use this file except in compliance | |
| * with the License. You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| ***********************************************************--> | |
| <!ELEMENT table:calculation-settings (table:null-date?, table:iteration?)> | |
| <!ATTLIST table:calculation-settings | |
| table:case-sensitive %boolean; "true" | |
| table:precision-as-shown %boolean; "false" | |
| table:search-criteria-must-apply-to-whole-cell %boolean; "true" | |
| table:automatic-find-labels %boolean; "true" | |
| table:use-regular-expressions %boolean; "true" | |
| table:null-year %positiveInteger; "1930" | |
| > | |
| <!ELEMENT table:null-date EMPTY> | |
| <!ATTLIST table:null-date | |
| table:value-type %valueType; #FIXED "date" | |
| table:date-value %date; "1899-12-30" | |
| > | |
| <!ELEMENT table:iteration EMPTY> | |
| <!ATTLIST table:iteration | |
| table:status (enable | disable) "disable" | |
| table:steps %positiveInteger; "100" | |
| table:maximum-difference %float; "0.001" | |
| > | |
| <!ELEMENT table:tracked-changes (table:cell-content-change | table:insertion | table:deletion | table:movement | table:rejection)*> | |
| <!ATTLIST table:tracked-changes table:track-changes %boolean; "true" | |
| table:protected %boolean; "false" | |
| table:protection-key CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:dependences (table:dependence)+> | |
| <!ELEMENT table:dependence EMPTY> | |
| <!ATTLIST table:dependence | |
| table:id CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:deletions (table:cell-content-deletion | table:change-deletion)+> | |
| <!ELEMENT table:cell-content-deletion (table:cell-address?, table:change-track-table-cell?)> | |
| <!ATTLIST table:cell-content-deletion | |
| table:id CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:change-deletion EMPTY> | |
| <!ATTLIST table:change-deletion | |
| table:id CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:insertion (office:change-info, table:dependences?, table:deletions?)> | |
| <!ATTLIST table:insertion | |
| table:id CDATA #REQUIRED | |
| table:acceptance-state (accepted | rejected | pending) "pending" | |
| table:rejecting-change-id %positiveInteger; #IMPLIED | |
| table:type (row | column | table) #REQUIRED | |
| table:position %integer; #REQUIRED | |
| table:count %positiveInteger; "1" | |
| table:table %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:deletion (office:change-info, table:dependences?, table:deletions?, table:cut-offs?)> | |
| <!ATTLIST table:deletion | |
| table:id CDATA #REQUIRED | |
| table:acceptance-state (accepted | rejected | pending) "pending" | |
| table:rejecting-change-id %positiveInteger; #IMPLIED | |
| table:type (row | column | table) #REQUIRED | |
| table:position %integer; #REQUIRED | |
| table:count %positiveInteger; "1" | |
| table:table %integer; #IMPLIED | |
| table:multi-deletion-spanned %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:cut-offs (table:movement-cut-off+ | (table:insertion-cut-off, table:movement-cut-off*))> | |
| <!ELEMENT table:insertion-cut-off EMPTY> | |
| <!ATTLIST table:insertion-cut-off | |
| table:id CDATA #REQUIRED | |
| table:position %integer; #REQUIRED | |
| > | |
| <!ELEMENT table:movement-cut-off EMPTY> | |
| <!ATTLIST table:movement-cut-off | |
| table:id CDATA #REQUIRED | |
| table:start-position %integer; #IMPLIED | |
| table:end-position %integer; #IMPLIED | |
| table:position %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:movement (table:source-range-address, table:target-range-address, office:change-info, table:dependences?, table:deletions?)> | |
| <!ATTLIST table:movement | |
| table:id CDATA #REQUIRED | |
| table:acceptance-state (accepted | rejected | pending) "pending" | |
| table:rejecting-change-id %positiveInteger; #IMPLIED | |
| > | |
| <!ELEMENT table:target-range-address EMPTY> | |
| <!ATTLIST table:target-range-address | |
| table:column %integer; #IMPLIED | |
| table:row %integer; #IMPLIED | |
| table:table %integer; #IMPLIED | |
| table:start-column %integer; #IMPLIED | |
| table:start-row %integer; #IMPLIED | |
| table:start-table %integer; #IMPLIED | |
| table:end-column %integer; #IMPLIED | |
| table:end-row %integer; #IMPLIED | |
| table:end-table %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:source-range-address EMPTY> | |
| <!ATTLIST table:source-range-address | |
| table:column %integer; #IMPLIED | |
| table:row %integer; #IMPLIED | |
| table:table %integer; #IMPLIED | |
| table:start-column %integer; #IMPLIED | |
| table:start-row %integer; #IMPLIED | |
| table:start-table %integer; #IMPLIED | |
| table:end-column %integer; #IMPLIED | |
| table:end-row %integer; #IMPLIED | |
| table:end-table %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:change-track-table-cell (text:p*)> | |
| <!ATTLIST table:change-track-table-cell | |
| table:cell-address %cell-address; #IMPLIED | |
| table:matrix-covered (true | false) "false" | |
| table:formula %string; #IMPLIED | |
| table:number-matrix-rows-spanned %positiveInteger; #IMPLIED | |
| table:number-matrix-columns-spanned %positiveInteger; #IMPLIED | |
| table:value-type %valueType; "string" | |
| table:value %float; #IMPLIED | |
| table:date-value %date; #IMPLIED | |
| table:time-value %timeInstance; #IMPLIED | |
| table:string-value %string; #IMPLIED | |
| > | |
| <!ELEMENT table:cell-content-change (table:cell-address, office:change-info, table:dependences?, table:deletions?, table:previous)> | |
| <!ATTLIST table:cell-content-change | |
| table:id CDATA #REQUIRED | |
| table:acceptance-state (accepted | rejected | pending) "pending" | |
| table:rejecting-change-id %positiveInteger; #IMPLIED | |
| > | |
| <!ELEMENT table:cell-address EMPTY> | |
| <!ATTLIST table:cell-address | |
| table:column %integer; #IMPLIED | |
| table:row %integer; #IMPLIED | |
| table:table %integer; #IMPLIED | |
| > | |
| <!ELEMENT table:previous (table:change-track-table-cell)> | |
| <!ATTLIST table:previous | |
| table:id CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:rejection (office:change-info, table:dependences?, table:deletions?)> | |
| <!ATTLIST table:rejection | |
| table:id CDATA #REQUIRED | |
| table:acceptance-state (accepted | rejected | pending) "pending" | |
| table:rejecting-change-id %positiveInteger; #IMPLIED | |
| > | |
| <!ENTITY % table-columns "table:table-columns | ( table:table-column | table:table-column-group )+"> | |
| <!ENTITY % table-header-columns "table:table-header-columns"> | |
| <!ENTITY % table-rows "table:table-rows | ( table:table-row | table:table-row-group )+"> | |
| <!ENTITY % table-header-rows "table:table-header-rows"> | |
| <!ENTITY % table-column-groups "((%table-columns;),(%table-header-columns;,(%table-columns;)?)?) | (%table-header-columns;,(%table-columns;)?)"> | |
| <!ENTITY % table-row-groups "((%table-rows;),(%table-header-rows;,(%table-rows;)?)?) | (%table-header-rows;,(%table-rows;)?)"> | |
| <!ELEMENT table:table (table:table-source?, table:scenario?, office:forms?, table:shapes?, (%table-column-groups;), (%table-row-groups;))> | |
| <!ATTLIST table:table | |
| table:name %string; #IMPLIED | |
| table:style-name %styleName; #IMPLIED | |
| table:protected %boolean; "false" | |
| table:protection-key CDATA #IMPLIED | |
| table:print-ranges %cell-range-address-list; #IMPLIED | |
| table:automatic-print-range %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:table-source EMPTY> | |
| <!ATTLIST table:table-source | |
| table:mode (copy-all | copy-results-only) "copy-all" | |
| xlink:type (simple) #FIXED "simple" | |
| xlink:actuate (onRequest) "onRequest" | |
| xlink:href %uriReference; #REQUIRED | |
| table:filter-name CDATA #IMPLIED | |
| table:table-name CDATA #IMPLIED | |
| table:filter-options CDATA #IMPLIED | |
| table:refresh-delay %timeDuration; #IMPLIED | |
| > | |
| <!ELEMENT table:scenario EMPTY> | |
| <!ATTLIST table:scenario | |
| table:display-border %boolean; "true" | |
| table:border-color %color; #IMPLIED | |
| table:copy-back %boolean; "true" | |
| table:copy-styles %boolean; "true" | |
| table:copy-formulas %boolean; "true" | |
| table:is-active %boolean; #REQUIRED | |
| table:scenario-ranges %cell-range-address-list; #REQUIRED | |
| table:comment CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:shapes %shapes;> | |
| <!ELEMENT table:table-column-group (table:table-header-columns | table:table-column | table:table-column-group)+> | |
| <!ATTLIST table:table-column-group | |
| table:display %boolean; "true" | |
| > | |
| <!ELEMENT table:table-header-columns (table:table-column | table:table-column-group)+> | |
| <!ELEMENT table:table-columns (table:table-column | table:table-column-group)+> | |
| <!ELEMENT table:table-column EMPTY> | |
| <!ATTLIST table:table-column | |
| table:number-columns-repeated %positiveInteger; "1" | |
| table:style-name %styleName; #IMPLIED | |
| table:visibility (visible | collapse | filter) "visible" | |
| table:default-cell-style-name %styleName; #IMPLIED | |
| > | |
| <!ELEMENT table:table-row-group (table:table-header-rows | table:table-row | table:table-row-group)+> | |
| <!ATTLIST table:table-row-group | |
| table:display %boolean; "true" | |
| > | |
| <!ELEMENT table:table-header-rows (table:table-row | table:table-row-group)+> | |
| <!ELEMENT table:table-rows (table:table-row | table:table-row-group)+> | |
| <!ENTITY % table-cells "(table:table-cell|table:covered-table-cell)+"> | |
| <!ELEMENT table:table-row %table-cells;> | |
| <!ATTLIST table:table-row | |
| table:number-rows-repeated %positiveInteger; "1" | |
| table:style-name %styleName; #IMPLIED | |
| table:visibility (visible | collapse | filter) "visible" | |
| table:default-cell-style-name %styleName; #IMPLIED | |
| > | |
| <!ENTITY % text-wo-table "(text:h|text:p|text:ordered-list|text:unordered-list|%shapes;)*"> | |
| <!ENTITY % cell-content "(table:cell-range-source?,office:annotation?,table:detective?,(table:sub-table|%text-wo-table;))"> | |
| <!ELEMENT table:table-cell %cell-content;> | |
| <!ELEMENT table:covered-table-cell %cell-content;> | |
| <!ATTLIST table:table-cell | |
| table:number-columns-repeated %positiveInteger; "1" | |
| table:number-rows-spanned %positiveInteger; "1" | |
| table:number-columns-spanned %positiveInteger; "1" | |
| table:style-name %styleName; #IMPLIED | |
| table:validation-name CDATA #IMPLIED | |
| table:formula %string; #IMPLIED | |
| table:number-matrix-rows-spanned %positiveInteger; #IMPLIED | |
| table:number-matrix-columns-spanned %positiveInteger; #IMPLIED | |
| table:value-type %valueType; "string" | |
| table:value %float; #IMPLIED | |
| table:date-value %date; #IMPLIED | |
| table:time-value %timeInstance; #IMPLIED | |
| table:boolean-value %boolean; #IMPLIED | |
| table:string-value %string; #IMPLIED | |
| table:currency %string; #IMPLIED | |
| > | |
| <!ATTLIST table:covered-table-cell | |
| table:number-columns-repeated %positiveInteger; "1" | |
| table:style-name %styleName; #IMPLIED | |
| table:validation-name CDATA #IMPLIED | |
| table:formula %string; #IMPLIED | |
| table:number-matrix-rows-spanned %positiveInteger; #IMPLIED | |
| table:number-matrix-columns-spanned %positiveInteger; #IMPLIED | |
| table:value-type %valueType; "string" | |
| table:value %float; #IMPLIED | |
| table:date-value %date; #IMPLIED | |
| table:time-value %timeInstance; #IMPLIED | |
| table:boolean-value %boolean; #IMPLIED | |
| table:string-value %string; #IMPLIED | |
| table:currency %string; #IMPLIED | |
| > | |
| <!-- cell protection in writer: cell attribute; calc uses format --> | |
| <!ATTLIST table:table-cell table:protected %boolean; "false"> | |
| <!ELEMENT table:cell-range-source EMPTY> | |
| <!ATTLIST table:cell-range-source | |
| table:name %string; #REQUIRED | |
| xlink:type (simple) #FIXED "simple" | |
| xlink:actuate (onRequest) #FIXED "onRequest" | |
| xlink:href %uriReference; #REQUIRED | |
| table:filter-name %string; #REQUIRED | |
| table:filter-options %string; #IMPLIED | |
| table:last-column-spanned %positiveInteger; #REQUIRED | |
| table:last-row-spanned %positiveInteger; #REQUIRED | |
| table:refresh-delay %timeDuration; #IMPLIED | |
| > | |
| <!ELEMENT table:detective (table:highlighted-range*, table:operation*)> | |
| <!ELEMENT table:highlighted-range EMPTY> | |
| <!ATTLIST table:highlighted-range | |
| table:cell-range-address %cell-range-address; #IMPLIED | |
| table:direction (from-another-table | to-another-table | from-same-table | to-same-table) #IMPLIED | |
| table:contains-error %boolean; #IMPLIED | |
| table:marked-invalid %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:operation EMPTY> | |
| <!ATTLIST table:operation | |
| table:name (trace-dependents | remove-dependents | trace-precedents | remove-precedents | trace-errors) #REQUIRED | |
| table:index %nonNegativeInteger; #REQUIRED | |
| > | |
| <!ELEMENT table:content-validations (table:content-validation)+> | |
| <!ELEMENT table:content-validation (table:help-message?, (table:error-message | (table:error-macro, office:events?))?)> | |
| <!ATTLIST table:content-validation | |
| table:name CDATA #REQUIRED | |
| table:condition CDATA #IMPLIED | |
| table:base-cell-address %cell-address; #IMPLIED | |
| table:allow-empty-cell %boolean; #IMPLIED | |
| table:show-list (no | unsorted | sorted-ascending) #IMPLIED | |
| > | |
| <!ELEMENT table:help-message (text:p*)> | |
| <!ATTLIST table:help-message | |
| table:title CDATA #IMPLIED | |
| table:display %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:error-message (text:p*)> | |
| <!ATTLIST table:error-message | |
| table:title CDATA #IMPLIED | |
| table:message-type (stop | warning | information) #IMPLIED | |
| table:display %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:error-macro EMPTY> | |
| <!ATTLIST table:error-macro | |
| table:name CDATA #IMPLIED | |
| table:execute %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:sub-table ((%table-column-groups;) , (%table-row-groups;))> | |
| <!ELEMENT table:label-ranges (table:label-range)*> | |
| <!ELEMENT table:label-range EMPTY> | |
| <!ATTLIST table:label-range | |
| table:label-cell-range-address %cell-range-address; #REQUIRED | |
| table:data-cell-range-address %cell-range-address; #REQUIRED | |
| table:orientation (column | row) #REQUIRED | |
| > | |
| <!ELEMENT table:named-expressions (table:named-range | table:named-expression)*> | |
| <!ELEMENT table:named-range EMPTY> | |
| <!ATTLIST table:named-range | |
| table:name CDATA #REQUIRED | |
| table:cell-range-address %cell-range-address; #REQUIRED | |
| table:base-cell-address %cell-address; #IMPLIED | |
| table:range-usable-as CDATA "none" | |
| > | |
| <!ELEMENT table:named-expression EMPTY> | |
| <!ATTLIST table:named-expression | |
| table:name CDATA #REQUIRED | |
| table:expression CDATA #REQUIRED | |
| table:base-cell-address %cell-address; #IMPLIED | |
| > | |
| <!ELEMENT table:filter (table:filter-condition | table:filter-and | table:filter-or)> | |
| <!ATTLIST table:filter | |
| table:target-range-address %cell-range-address; #IMPLIED | |
| table:condition-source-range-address %cell-range-address; #IMPLIED | |
| table:condition-source (self | cell-range) "self" | |
| table:display-duplicates %boolean; "true" | |
| > | |
| <!ELEMENT table:filter-and (table:filter-or | table:filter-condition)+> | |
| <!ELEMENT table:filter-or (table:filter-and | table:filter-condition)+> | |
| <!ELEMENT table:filter-condition EMPTY> | |
| <!ATTLIST table:filter-condition | |
| table:field-number %nonNegativeInteger; #REQUIRED | |
| table:case-sensitive %boolean; "false" | |
| table:data-type (text | number) "text" | |
| table:value CDATA #REQUIRED | |
| table:operator CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:database-ranges (table:database-range)*> | |
| <!ELEMENT table:database-range ((table:database-source-sql | table:database-source-table | table:database-source-query)?, table:filter?, table:sort?, table:subtotal-rules?)> | |
| <!ATTLIST table:database-range | |
| table:name CDATA #IMPLIED | |
| table:is-selection %boolean; "false" | |
| table:on-update-keep-styles %boolean; "false" | |
| table:on-update-keep-size %boolean; "true" | |
| table:has-persistant-data %boolean; "true" | |
| table:orientation (row | column) "row" | |
| table:contains-header %boolean; "true" | |
| table:display-filter-buttons %boolean; "false" | |
| table:target-range-address %cell-range-address; #REQUIRED | |
| table:refresh-delay %timeDuration; #IMPLIED | |
| > | |
| <!ELEMENT table:database-source-sql EMPTY> | |
| <!ATTLIST table:database-source-sql | |
| table:database-name CDATA #REQUIRED | |
| table:sql-statement CDATA #REQUIRED | |
| table:parse-sql-statements %boolean; "false" | |
| > | |
| <!ELEMENT table:database-source-table EMPTY> | |
| <!ATTLIST table:database-source-table | |
| table:database-name CDATA #REQUIRED | |
| table:table-name CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:database-source-query EMPTY> | |
| <!ATTLIST table:database-source-query | |
| table:database-name CDATA #REQUIRED | |
| table:query-name CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:sort (table:sort-by)+> | |
| <!ATTLIST table:sort | |
| table:bind-styles-to-content %boolean; "true" | |
| table:target-range-address %cell-range-address; #IMPLIED | |
| table:case-sensitive %boolean; "false" | |
| table:language CDATA #IMPLIED | |
| table:country CDATA #IMPLIED | |
| table:algorithm CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:sort-by EMPTY> | |
| <!ATTLIST table:sort-by | |
| table:field-number %nonNegativeInteger; #REQUIRED | |
| table:data-type CDATA "automatic" | |
| table:order (ascending | descending) "ascending" | |
| > | |
| <!ELEMENT table:subtotal-rules (table:sort-groups? | table:subtotal-rule*)?> | |
| <!ATTLIST table:subtotal-rules | |
| table:bind-styles-to-content %boolean; "true" | |
| table:case-sensitive %boolean; "false" | |
| table:page-breaks-on-group-change %boolean; "false" | |
| > | |
| <!ELEMENT table:sort-groups EMPTY> | |
| <!ATTLIST table:sort-groups | |
| table:data-type CDATA "automatic" | |
| table:order (ascending | descending) "ascending" | |
| > | |
| <!ELEMENT table:subtotal-rule (table:subtotal-field)*> | |
| <!ATTLIST table:subtotal-rule | |
| table:group-by-field-number %nonNegativeInteger; #REQUIRED | |
| > | |
| <!ELEMENT table:subtotal-field EMPTY> | |
| <!ATTLIST table:subtotal-field | |
| table:field-number %nonNegativeInteger; #REQUIRED | |
| table:function CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:data-pilot-tables (table:data-pilot-table)*> | |
| <!ELEMENT table:data-pilot-table ((table:database-source-sql | table:database-source-table | table:database-source-query | table:source-service | table:source-cell-range)?, table:data-pilot-field+)> | |
| <!ATTLIST table:data-pilot-table | |
| table:name CDATA #REQUIRED | |
| table:application-data CDATA #IMPLIED | |
| table:grand-total (none | row | column | both) "both" | |
| table:ignore-empty-rows %boolean; "false" | |
| table:identify-categories %boolean; "false" | |
| table:target-range-address %cell-range-address; #REQUIRED | |
| table:buttons %cell-range-address-list; #REQUIRED | |
| > | |
| <!ELEMENT table:source-service EMPTY> | |
| <!ATTLIST table:source-service | |
| table:name CDATA #REQUIRED | |
| table:source-name CDATA #REQUIRED | |
| table:object-name CDATA #REQUIRED | |
| table:username CDATA #IMPLIED | |
| table:password CDATA #IMPLIED | |
| > | |
| <!ELEMENT table:source-cell-range (table:filter)?> | |
| <!ATTLIST table:source-cell-range | |
| table:cell-range-address %cell-range-address; #REQUIRED | |
| > | |
| <!ELEMENT table:data-pilot-field (table:data-pilot-level)?> | |
| <!ATTLIST table:data-pilot-field | |
| table:source-field-name CDATA #REQUIRED | |
| table:is-data-layout-field %boolean; "false" | |
| table:function CDATA #REQUIRED | |
| table:orientation (row | column | data | page | hidden) #REQUIRED | |
| table:used-hierarchy %positiveInteger; "1" | |
| > | |
| <!ELEMENT table:data-pilot-level (table:data-pilot-subtotals?, table:data-pilot-members?)> | |
| <!ATTLIST table:data-pilot-level | |
| table:display-empty %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:data-pilot-subtotals (table:data-pilot-subtotal)*> | |
| <!ELEMENT table:data-pilot-subtotal EMPTY> | |
| <!ATTLIST table:data-pilot-subtotal | |
| table:function CDATA #REQUIRED | |
| > | |
| <!ELEMENT table:data-pilot-members (table:data-pilot-member)*> | |
| <!ELEMENT table:data-pilot-member EMPTY> | |
| <!ATTLIST table:data-pilot-member | |
| table:name CDATA #REQUIRED | |
| table:display %boolean; #IMPLIED | |
| table:display-details %boolean; #IMPLIED | |
| > | |
| <!ELEMENT table:consolidation EMPTY> | |
| <!ATTLIST table:consolidation | |
| table:function CDATA #REQUIRED | |
| table:source-cell-range-addresses %cell-range-address-list; #REQUIRED | |
| table:target-cell-address %cell-address; #REQUIRED | |
| table:use-label (none | column | row | both) "none" | |
| table:link-to-source-data %boolean; "false" | |
| > | |
| <!ELEMENT table:dde-links (table:dde-link)+> | |
| <!ELEMENT table:dde-link (office:dde-source, table:table)> |