1*cdf0e10cSrcweir<!-- 2*cdf0e10cSrcweir 3*cdf0e10cSrcweir DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir 5*cdf0e10cSrcweir Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir 7*cdf0e10cSrcweir OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir 9*cdf0e10cSrcweir This file is part of OpenOffice.org. 10*cdf0e10cSrcweir 11*cdf0e10cSrcweir OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir 15*cdf0e10cSrcweir OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir 21*cdf0e10cSrcweir You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir 26*cdf0e10cSrcweir--> 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir<!ELEMENT table:calculation-settings (table:null-date?, table:iteration?)> 29*cdf0e10cSrcweir<!ATTLIST table:calculation-settings 30*cdf0e10cSrcweir table:case-sensitive %boolean; "true" 31*cdf0e10cSrcweir table:precision-as-shown %boolean; "false" 32*cdf0e10cSrcweir table:search-criteria-must-apply-to-whole-cell %boolean; "true" 33*cdf0e10cSrcweir table:automatic-find-labels %boolean; "true" 34*cdf0e10cSrcweir table:use-regular-expressions %boolean; "true" 35*cdf0e10cSrcweir table:null-year %positiveInteger; "1930" 36*cdf0e10cSrcweir> 37*cdf0e10cSrcweir<!ELEMENT table:null-date EMPTY> 38*cdf0e10cSrcweir<!ATTLIST table:null-date 39*cdf0e10cSrcweir table:value-type %valueType; #FIXED "date" 40*cdf0e10cSrcweir table:date-value %date; "1899-12-30" 41*cdf0e10cSrcweir> 42*cdf0e10cSrcweir<!ELEMENT table:iteration EMPTY> 43*cdf0e10cSrcweir<!ATTLIST table:iteration 44*cdf0e10cSrcweir table:status (enable | disable) "disable" 45*cdf0e10cSrcweir table:steps %positiveInteger; "100" 46*cdf0e10cSrcweir table:maximum-difference %float; "0.001" 47*cdf0e10cSrcweir> 48*cdf0e10cSrcweir 49*cdf0e10cSrcweir<!ELEMENT table:tracked-changes (table:cell-content-change | table:insertion | table:deletion | table:movement | table:rejection)*> 50*cdf0e10cSrcweir<!ATTLIST table:tracked-changes table:track-changes %boolean; "true" 51*cdf0e10cSrcweir table:protected %boolean; "false" 52*cdf0e10cSrcweir table:protection-key CDATA #IMPLIED 53*cdf0e10cSrcweir> 54*cdf0e10cSrcweir 55*cdf0e10cSrcweir<!ELEMENT table:dependences (table:dependence)+> 56*cdf0e10cSrcweir<!ELEMENT table:dependence EMPTY> 57*cdf0e10cSrcweir<!ATTLIST table:dependence 58*cdf0e10cSrcweir table:id CDATA #REQUIRED 59*cdf0e10cSrcweir> 60*cdf0e10cSrcweir<!ELEMENT table:deletions (table:cell-content-deletion | table:change-deletion)+> 61*cdf0e10cSrcweir<!ELEMENT table:cell-content-deletion (table:cell-address?, table:change-track-table-cell?)> 62*cdf0e10cSrcweir<!ATTLIST table:cell-content-deletion 63*cdf0e10cSrcweir table:id CDATA #IMPLIED 64*cdf0e10cSrcweir> 65*cdf0e10cSrcweir<!ELEMENT table:change-deletion EMPTY> 66*cdf0e10cSrcweir<!ATTLIST table:change-deletion 67*cdf0e10cSrcweir table:id CDATA #IMPLIED 68*cdf0e10cSrcweir> 69*cdf0e10cSrcweir<!ELEMENT table:insertion (office:change-info, table:dependences?, table:deletions?)> 70*cdf0e10cSrcweir<!ATTLIST table:insertion 71*cdf0e10cSrcweir table:id CDATA #REQUIRED 72*cdf0e10cSrcweir table:acceptance-state (accepted | rejected | pending) "pending" 73*cdf0e10cSrcweir table:rejecting-change-id %positiveInteger; #IMPLIED 74*cdf0e10cSrcweir table:type (row | column | table) #REQUIRED 75*cdf0e10cSrcweir table:position %integer; #REQUIRED 76*cdf0e10cSrcweir table:count %positiveInteger; "1" 77*cdf0e10cSrcweir table:table %integer; #IMPLIED 78*cdf0e10cSrcweir> 79*cdf0e10cSrcweir<!ELEMENT table:deletion (office:change-info, table:dependences?, table:deletions?, table:cut-offs?)> 80*cdf0e10cSrcweir<!ATTLIST table:deletion 81*cdf0e10cSrcweir table:id CDATA #REQUIRED 82*cdf0e10cSrcweir table:acceptance-state (accepted | rejected | pending) "pending" 83*cdf0e10cSrcweir table:rejecting-change-id %positiveInteger; #IMPLIED 84*cdf0e10cSrcweir table:type (row | column | table) #REQUIRED 85*cdf0e10cSrcweir table:position %integer; #REQUIRED 86*cdf0e10cSrcweir table:count %positiveInteger; "1" 87*cdf0e10cSrcweir table:table %integer; #IMPLIED 88*cdf0e10cSrcweir table:multi-deletion-spanned %integer; #IMPLIED 89*cdf0e10cSrcweir> 90*cdf0e10cSrcweir<!ELEMENT table:cut-offs (table:movement-cut-off+ | (table:insertion-cut-off, table:movement-cut-off*))> 91*cdf0e10cSrcweir<!ELEMENT table:insertion-cut-off EMPTY> 92*cdf0e10cSrcweir<!ATTLIST table:insertion-cut-off 93*cdf0e10cSrcweir table:id CDATA #REQUIRED 94*cdf0e10cSrcweir table:position %integer; #REQUIRED 95*cdf0e10cSrcweir> 96*cdf0e10cSrcweir<!ELEMENT table:movement-cut-off EMPTY> 97*cdf0e10cSrcweir<!ATTLIST table:movement-cut-off 98*cdf0e10cSrcweir table:id CDATA #REQUIRED 99*cdf0e10cSrcweir table:start-position %integer; #IMPLIED 100*cdf0e10cSrcweir table:end-position %integer; #IMPLIED 101*cdf0e10cSrcweir table:position %integer; #IMPLIED 102*cdf0e10cSrcweir> 103*cdf0e10cSrcweir<!ELEMENT table:movement (table:source-range-address, table:target-range-address, office:change-info, table:dependences?, table:deletions?)> 104*cdf0e10cSrcweir<!ATTLIST table:movement 105*cdf0e10cSrcweir table:id CDATA #REQUIRED 106*cdf0e10cSrcweir table:acceptance-state (accepted | rejected | pending) "pending" 107*cdf0e10cSrcweir table:rejecting-change-id %positiveInteger; #IMPLIED 108*cdf0e10cSrcweir> 109*cdf0e10cSrcweir<!ELEMENT table:target-range-address EMPTY> 110*cdf0e10cSrcweir<!ATTLIST table:target-range-address 111*cdf0e10cSrcweir table:column %integer; #IMPLIED 112*cdf0e10cSrcweir table:row %integer; #IMPLIED 113*cdf0e10cSrcweir table:table %integer; #IMPLIED 114*cdf0e10cSrcweir table:start-column %integer; #IMPLIED 115*cdf0e10cSrcweir table:start-row %integer; #IMPLIED 116*cdf0e10cSrcweir table:start-table %integer; #IMPLIED 117*cdf0e10cSrcweir table:end-column %integer; #IMPLIED 118*cdf0e10cSrcweir table:end-row %integer; #IMPLIED 119*cdf0e10cSrcweir table:end-table %integer; #IMPLIED 120*cdf0e10cSrcweir> 121*cdf0e10cSrcweir<!ELEMENT table:source-range-address EMPTY> 122*cdf0e10cSrcweir<!ATTLIST table:source-range-address 123*cdf0e10cSrcweir table:column %integer; #IMPLIED 124*cdf0e10cSrcweir table:row %integer; #IMPLIED 125*cdf0e10cSrcweir table:table %integer; #IMPLIED 126*cdf0e10cSrcweir table:start-column %integer; #IMPLIED 127*cdf0e10cSrcweir table:start-row %integer; #IMPLIED 128*cdf0e10cSrcweir table:start-table %integer; #IMPLIED 129*cdf0e10cSrcweir table:end-column %integer; #IMPLIED 130*cdf0e10cSrcweir table:end-row %integer; #IMPLIED 131*cdf0e10cSrcweir table:end-table %integer; #IMPLIED 132*cdf0e10cSrcweir> 133*cdf0e10cSrcweir<!ELEMENT table:change-track-table-cell (text:p*)> 134*cdf0e10cSrcweir<!ATTLIST table:change-track-table-cell 135*cdf0e10cSrcweir table:cell-address %cell-address; #IMPLIED 136*cdf0e10cSrcweir table:matrix-covered (true | false) "false" 137*cdf0e10cSrcweir table:formula %string; #IMPLIED 138*cdf0e10cSrcweir table:number-matrix-rows-spanned %positiveInteger; #IMPLIED 139*cdf0e10cSrcweir table:number-matrix-columns-spanned %positiveInteger; #IMPLIED 140*cdf0e10cSrcweir table:value-type %valueType; "string" 141*cdf0e10cSrcweir table:value %float; #IMPLIED 142*cdf0e10cSrcweir table:date-value %date; #IMPLIED 143*cdf0e10cSrcweir table:time-value %timeInstance; #IMPLIED 144*cdf0e10cSrcweir table:string-value %string; #IMPLIED 145*cdf0e10cSrcweir> 146*cdf0e10cSrcweir<!ELEMENT table:cell-content-change (table:cell-address, office:change-info, table:dependences?, table:deletions?, table:previous)> 147*cdf0e10cSrcweir<!ATTLIST table:cell-content-change 148*cdf0e10cSrcweir table:id CDATA #REQUIRED 149*cdf0e10cSrcweir table:acceptance-state (accepted | rejected | pending) "pending" 150*cdf0e10cSrcweir table:rejecting-change-id %positiveInteger; #IMPLIED 151*cdf0e10cSrcweir> 152*cdf0e10cSrcweir<!ELEMENT table:cell-address EMPTY> 153*cdf0e10cSrcweir<!ATTLIST table:cell-address 154*cdf0e10cSrcweir table:column %integer; #IMPLIED 155*cdf0e10cSrcweir table:row %integer; #IMPLIED 156*cdf0e10cSrcweir table:table %integer; #IMPLIED 157*cdf0e10cSrcweir> 158*cdf0e10cSrcweir<!ELEMENT table:previous (table:change-track-table-cell)> 159*cdf0e10cSrcweir<!ATTLIST table:previous 160*cdf0e10cSrcweir table:id CDATA #IMPLIED 161*cdf0e10cSrcweir> 162*cdf0e10cSrcweir<!ELEMENT table:rejection (office:change-info, table:dependences?, table:deletions?)> 163*cdf0e10cSrcweir<!ATTLIST table:rejection 164*cdf0e10cSrcweir table:id CDATA #REQUIRED 165*cdf0e10cSrcweir table:acceptance-state (accepted | rejected | pending) "pending" 166*cdf0e10cSrcweir table:rejecting-change-id %positiveInteger; #IMPLIED 167*cdf0e10cSrcweir> 168*cdf0e10cSrcweir 169*cdf0e10cSrcweir<!ENTITY % table-columns "table:table-columns | ( table:table-column | table:table-column-group )+"> 170*cdf0e10cSrcweir<!ENTITY % table-header-columns "table:table-header-columns"> 171*cdf0e10cSrcweir<!ENTITY % table-rows "table:table-rows | ( table:table-row | table:table-row-group )+"> 172*cdf0e10cSrcweir<!ENTITY % table-header-rows "table:table-header-rows"> 173*cdf0e10cSrcweir<!ENTITY % table-column-groups "((%table-columns;),(%table-header-columns;,(%table-columns;)?)?) | (%table-header-columns;,(%table-columns;)?)"> 174*cdf0e10cSrcweir<!ENTITY % table-row-groups "((%table-rows;),(%table-header-rows;,(%table-rows;)?)?) | (%table-header-rows;,(%table-rows;)?)"> 175*cdf0e10cSrcweir<!ELEMENT table:table (table:table-source?, table:scenario?, office:forms?, table:shapes?, (%table-column-groups;), (%table-row-groups;))> 176*cdf0e10cSrcweir<!ATTLIST table:table 177*cdf0e10cSrcweir table:name %string; #IMPLIED 178*cdf0e10cSrcweir table:style-name %styleName; #IMPLIED 179*cdf0e10cSrcweir table:protected %boolean; "false" 180*cdf0e10cSrcweir table:protection-key CDATA #IMPLIED 181*cdf0e10cSrcweir table:print-ranges %cell-range-address-list; #IMPLIED 182*cdf0e10cSrcweir table:automatic-print-range %boolean; #IMPLIED 183*cdf0e10cSrcweir> 184*cdf0e10cSrcweir<!ELEMENT table:table-source EMPTY> 185*cdf0e10cSrcweir<!ATTLIST table:table-source 186*cdf0e10cSrcweir table:mode (copy-all | copy-results-only) "copy-all" 187*cdf0e10cSrcweir xlink:type (simple) #FIXED "simple" 188*cdf0e10cSrcweir xlink:actuate (onRequest) "onRequest" 189*cdf0e10cSrcweir xlink:href %uriReference; #REQUIRED 190*cdf0e10cSrcweir table:filter-name CDATA #IMPLIED 191*cdf0e10cSrcweir table:table-name CDATA #IMPLIED 192*cdf0e10cSrcweir table:filter-options CDATA #IMPLIED 193*cdf0e10cSrcweir table:refresh-delay %timeDuration; #IMPLIED 194*cdf0e10cSrcweir> 195*cdf0e10cSrcweir<!ELEMENT table:scenario EMPTY> 196*cdf0e10cSrcweir<!ATTLIST table:scenario 197*cdf0e10cSrcweir table:display-border %boolean; "true" 198*cdf0e10cSrcweir table:border-color %color; #IMPLIED 199*cdf0e10cSrcweir table:copy-back %boolean; "true" 200*cdf0e10cSrcweir table:copy-styles %boolean; "true" 201*cdf0e10cSrcweir table:copy-formulas %boolean; "true" 202*cdf0e10cSrcweir table:is-active %boolean; #REQUIRED 203*cdf0e10cSrcweir table:scenario-ranges %cell-range-address-list; #REQUIRED 204*cdf0e10cSrcweir table:comment CDATA #IMPLIED 205*cdf0e10cSrcweir> 206*cdf0e10cSrcweir<!ELEMENT table:shapes %shapes;> 207*cdf0e10cSrcweir<!ELEMENT table:table-column-group (table:table-header-columns | table:table-column | table:table-column-group)+> 208*cdf0e10cSrcweir<!ATTLIST table:table-column-group 209*cdf0e10cSrcweir table:display %boolean; "true" 210*cdf0e10cSrcweir> 211*cdf0e10cSrcweir<!ELEMENT table:table-header-columns (table:table-column | table:table-column-group)+> 212*cdf0e10cSrcweir<!ELEMENT table:table-columns (table:table-column | table:table-column-group)+> 213*cdf0e10cSrcweir<!ELEMENT table:table-column EMPTY> 214*cdf0e10cSrcweir<!ATTLIST table:table-column 215*cdf0e10cSrcweir table:number-columns-repeated %positiveInteger; "1" 216*cdf0e10cSrcweir table:style-name %styleName; #IMPLIED 217*cdf0e10cSrcweir table:visibility (visible | collapse | filter) "visible" 218*cdf0e10cSrcweir table:default-cell-style-name %styleName; #IMPLIED 219*cdf0e10cSrcweir> 220*cdf0e10cSrcweir<!ELEMENT table:table-row-group (table:table-header-rows | table:table-row | table:table-row-group)+> 221*cdf0e10cSrcweir<!ATTLIST table:table-row-group 222*cdf0e10cSrcweir table:display %boolean; "true" 223*cdf0e10cSrcweir> 224*cdf0e10cSrcweir<!ELEMENT table:table-header-rows (table:table-row | table:table-row-group)+> 225*cdf0e10cSrcweir<!ELEMENT table:table-rows (table:table-row | table:table-row-group)+> 226*cdf0e10cSrcweir<!ENTITY % table-cells "(table:table-cell|table:covered-table-cell)+"> 227*cdf0e10cSrcweir<!ELEMENT table:table-row %table-cells;> 228*cdf0e10cSrcweir<!ATTLIST table:table-row 229*cdf0e10cSrcweir table:number-rows-repeated %positiveInteger; "1" 230*cdf0e10cSrcweir table:style-name %styleName; #IMPLIED 231*cdf0e10cSrcweir table:visibility (visible | collapse | filter) "visible" 232*cdf0e10cSrcweir table:default-cell-style-name %styleName; #IMPLIED 233*cdf0e10cSrcweir> 234*cdf0e10cSrcweir 235*cdf0e10cSrcweir<!ENTITY % text-wo-table "(text:h|text:p|text:ordered-list|text:unordered-list|%shapes;)*"> 236*cdf0e10cSrcweir<!ENTITY % cell-content "(table:cell-range-source?,office:annotation?,table:detective?,(table:sub-table|%text-wo-table;))"> 237*cdf0e10cSrcweir<!ELEMENT table:table-cell %cell-content;> 238*cdf0e10cSrcweir<!ELEMENT table:covered-table-cell %cell-content;> 239*cdf0e10cSrcweir<!ATTLIST table:table-cell 240*cdf0e10cSrcweir table:number-columns-repeated %positiveInteger; "1" 241*cdf0e10cSrcweir table:number-rows-spanned %positiveInteger; "1" 242*cdf0e10cSrcweir table:number-columns-spanned %positiveInteger; "1" 243*cdf0e10cSrcweir table:style-name %styleName; #IMPLIED 244*cdf0e10cSrcweir table:validation-name CDATA #IMPLIED 245*cdf0e10cSrcweir table:formula %string; #IMPLIED 246*cdf0e10cSrcweir table:number-matrix-rows-spanned %positiveInteger; #IMPLIED 247*cdf0e10cSrcweir table:number-matrix-columns-spanned %positiveInteger; #IMPLIED 248*cdf0e10cSrcweir table:value-type %valueType; "string" 249*cdf0e10cSrcweir table:value %float; #IMPLIED 250*cdf0e10cSrcweir table:date-value %date; #IMPLIED 251*cdf0e10cSrcweir table:time-value %timeInstance; #IMPLIED 252*cdf0e10cSrcweir table:boolean-value %boolean; #IMPLIED 253*cdf0e10cSrcweir table:string-value %string; #IMPLIED 254*cdf0e10cSrcweir table:currency %string; #IMPLIED 255*cdf0e10cSrcweir> 256*cdf0e10cSrcweir<!ATTLIST table:covered-table-cell 257*cdf0e10cSrcweir table:number-columns-repeated %positiveInteger; "1" 258*cdf0e10cSrcweir table:style-name %styleName; #IMPLIED 259*cdf0e10cSrcweir table:validation-name CDATA #IMPLIED 260*cdf0e10cSrcweir table:formula %string; #IMPLIED 261*cdf0e10cSrcweir table:number-matrix-rows-spanned %positiveInteger; #IMPLIED 262*cdf0e10cSrcweir table:number-matrix-columns-spanned %positiveInteger; #IMPLIED 263*cdf0e10cSrcweir table:value-type %valueType; "string" 264*cdf0e10cSrcweir table:value %float; #IMPLIED 265*cdf0e10cSrcweir table:date-value %date; #IMPLIED 266*cdf0e10cSrcweir table:time-value %timeInstance; #IMPLIED 267*cdf0e10cSrcweir table:boolean-value %boolean; #IMPLIED 268*cdf0e10cSrcweir table:string-value %string; #IMPLIED 269*cdf0e10cSrcweir table:currency %string; #IMPLIED 270*cdf0e10cSrcweir> 271*cdf0e10cSrcweir<!-- cell protection in writer: cell attribute; calc uses format --> 272*cdf0e10cSrcweir<!ATTLIST table:table-cell table:protected %boolean; "false"> 273*cdf0e10cSrcweir 274*cdf0e10cSrcweir<!ELEMENT table:cell-range-source EMPTY> 275*cdf0e10cSrcweir<!ATTLIST table:cell-range-source 276*cdf0e10cSrcweir table:name %string; #REQUIRED 277*cdf0e10cSrcweir xlink:type (simple) #FIXED "simple" 278*cdf0e10cSrcweir xlink:actuate (onRequest) #FIXED "onRequest" 279*cdf0e10cSrcweir xlink:href %uriReference; #REQUIRED 280*cdf0e10cSrcweir table:filter-name %string; #REQUIRED 281*cdf0e10cSrcweir table:filter-options %string; #IMPLIED 282*cdf0e10cSrcweir table:last-column-spanned %positiveInteger; #REQUIRED 283*cdf0e10cSrcweir table:last-row-spanned %positiveInteger; #REQUIRED 284*cdf0e10cSrcweir table:refresh-delay %timeDuration; #IMPLIED 285*cdf0e10cSrcweir> 286*cdf0e10cSrcweir 287*cdf0e10cSrcweir<!ELEMENT table:detective (table:highlighted-range*, table:operation*)> 288*cdf0e10cSrcweir<!ELEMENT table:highlighted-range EMPTY> 289*cdf0e10cSrcweir<!ATTLIST table:highlighted-range 290*cdf0e10cSrcweir table:cell-range-address %cell-range-address; #IMPLIED 291*cdf0e10cSrcweir table:direction (from-another-table | to-another-table | from-same-table | to-same-table) #IMPLIED 292*cdf0e10cSrcweir table:contains-error %boolean; #IMPLIED 293*cdf0e10cSrcweir table:marked-invalid %boolean; #IMPLIED 294*cdf0e10cSrcweir> 295*cdf0e10cSrcweir<!ELEMENT table:operation EMPTY> 296*cdf0e10cSrcweir<!ATTLIST table:operation 297*cdf0e10cSrcweir table:name (trace-dependents | remove-dependents | trace-precedents | remove-precedents | trace-errors) #REQUIRED 298*cdf0e10cSrcweir table:index %nonNegativeInteger; #REQUIRED 299*cdf0e10cSrcweir> 300*cdf0e10cSrcweir 301*cdf0e10cSrcweir<!ELEMENT table:content-validations (table:content-validation)+> 302*cdf0e10cSrcweir<!ELEMENT table:content-validation (table:help-message?, (table:error-message | (table:error-macro, office:events?))?)> 303*cdf0e10cSrcweir<!ATTLIST table:content-validation 304*cdf0e10cSrcweir table:name CDATA #REQUIRED 305*cdf0e10cSrcweir table:condition CDATA #IMPLIED 306*cdf0e10cSrcweir table:base-cell-address %cell-address; #IMPLIED 307*cdf0e10cSrcweir table:allow-empty-cell %boolean; #IMPLIED 308*cdf0e10cSrcweir table:show-list (no | unsorted | sorted-ascending) #IMPLIED 309*cdf0e10cSrcweir> 310*cdf0e10cSrcweir<!ELEMENT table:help-message (text:p*)> 311*cdf0e10cSrcweir<!ATTLIST table:help-message 312*cdf0e10cSrcweir table:title CDATA #IMPLIED 313*cdf0e10cSrcweir table:display %boolean; #IMPLIED 314*cdf0e10cSrcweir> 315*cdf0e10cSrcweir<!ELEMENT table:error-message (text:p*)> 316*cdf0e10cSrcweir<!ATTLIST table:error-message 317*cdf0e10cSrcweir table:title CDATA #IMPLIED 318*cdf0e10cSrcweir table:message-type (stop | warning | information) #IMPLIED 319*cdf0e10cSrcweir table:display %boolean; #IMPLIED 320*cdf0e10cSrcweir> 321*cdf0e10cSrcweir<!ELEMENT table:error-macro EMPTY> 322*cdf0e10cSrcweir<!ATTLIST table:error-macro 323*cdf0e10cSrcweir table:name CDATA #IMPLIED 324*cdf0e10cSrcweir table:execute %boolean; #IMPLIED 325*cdf0e10cSrcweir> 326*cdf0e10cSrcweir 327*cdf0e10cSrcweir<!ELEMENT table:sub-table ((%table-column-groups;) , (%table-row-groups;))> 328*cdf0e10cSrcweir 329*cdf0e10cSrcweir<!ELEMENT table:label-ranges (table:label-range)*> 330*cdf0e10cSrcweir<!ELEMENT table:label-range EMPTY> 331*cdf0e10cSrcweir<!ATTLIST table:label-range 332*cdf0e10cSrcweir table:label-cell-range-address %cell-range-address; #REQUIRED 333*cdf0e10cSrcweir table:data-cell-range-address %cell-range-address; #REQUIRED 334*cdf0e10cSrcweir table:orientation (column | row) #REQUIRED 335*cdf0e10cSrcweir> 336*cdf0e10cSrcweir 337*cdf0e10cSrcweir<!ELEMENT table:named-expressions (table:named-range | table:named-expression)*> 338*cdf0e10cSrcweir<!ELEMENT table:named-range EMPTY> 339*cdf0e10cSrcweir<!ATTLIST table:named-range 340*cdf0e10cSrcweir table:name CDATA #REQUIRED 341*cdf0e10cSrcweir table:cell-range-address %cell-range-address; #REQUIRED 342*cdf0e10cSrcweir table:base-cell-address %cell-address; #IMPLIED 343*cdf0e10cSrcweir table:range-usable-as CDATA "none" 344*cdf0e10cSrcweir> 345*cdf0e10cSrcweir<!ELEMENT table:named-expression EMPTY> 346*cdf0e10cSrcweir<!ATTLIST table:named-expression 347*cdf0e10cSrcweir table:name CDATA #REQUIRED 348*cdf0e10cSrcweir table:expression CDATA #REQUIRED 349*cdf0e10cSrcweir table:base-cell-address %cell-address; #IMPLIED 350*cdf0e10cSrcweir> 351*cdf0e10cSrcweir 352*cdf0e10cSrcweir<!ELEMENT table:filter (table:filter-condition | table:filter-and | table:filter-or)> 353*cdf0e10cSrcweir<!ATTLIST table:filter 354*cdf0e10cSrcweir table:target-range-address %cell-range-address; #IMPLIED 355*cdf0e10cSrcweir table:condition-source-range-address %cell-range-address; #IMPLIED 356*cdf0e10cSrcweir table:condition-source (self | cell-range) "self" 357*cdf0e10cSrcweir table:display-duplicates %boolean; "true" 358*cdf0e10cSrcweir> 359*cdf0e10cSrcweir<!ELEMENT table:filter-and (table:filter-or | table:filter-condition)+> 360*cdf0e10cSrcweir<!ELEMENT table:filter-or (table:filter-and | table:filter-condition)+> 361*cdf0e10cSrcweir<!ELEMENT table:filter-condition EMPTY> 362*cdf0e10cSrcweir<!ATTLIST table:filter-condition 363*cdf0e10cSrcweir table:field-number %nonNegativeInteger; #REQUIRED 364*cdf0e10cSrcweir table:case-sensitive %boolean; "false" 365*cdf0e10cSrcweir table:data-type (text | number) "text" 366*cdf0e10cSrcweir table:value CDATA #REQUIRED 367*cdf0e10cSrcweir table:operator CDATA #REQUIRED 368*cdf0e10cSrcweir> 369*cdf0e10cSrcweir 370*cdf0e10cSrcweir<!ELEMENT table:database-ranges (table:database-range)*> 371*cdf0e10cSrcweir<!ELEMENT table:database-range ((table:database-source-sql | table:database-source-table | table:database-source-query)?, table:filter?, table:sort?, table:subtotal-rules?)> 372*cdf0e10cSrcweir<!ATTLIST table:database-range 373*cdf0e10cSrcweir table:name CDATA #IMPLIED 374*cdf0e10cSrcweir table:is-selection %boolean; "false" 375*cdf0e10cSrcweir table:on-update-keep-styles %boolean; "false" 376*cdf0e10cSrcweir table:on-update-keep-size %boolean; "true" 377*cdf0e10cSrcweir table:has-persistant-data %boolean; "true" 378*cdf0e10cSrcweir table:orientation (row | column) "row" 379*cdf0e10cSrcweir table:contains-header %boolean; "true" 380*cdf0e10cSrcweir table:display-filter-buttons %boolean; "false" 381*cdf0e10cSrcweir table:target-range-address %cell-range-address; #REQUIRED 382*cdf0e10cSrcweir table:refresh-delay %timeDuration; #IMPLIED 383*cdf0e10cSrcweir> 384*cdf0e10cSrcweir<!ELEMENT table:database-source-sql EMPTY> 385*cdf0e10cSrcweir<!ATTLIST table:database-source-sql 386*cdf0e10cSrcweir table:database-name CDATA #REQUIRED 387*cdf0e10cSrcweir table:sql-statement CDATA #REQUIRED 388*cdf0e10cSrcweir table:parse-sql-statements %boolean; "false" 389*cdf0e10cSrcweir> 390*cdf0e10cSrcweir<!ELEMENT table:database-source-table EMPTY> 391*cdf0e10cSrcweir<!ATTLIST table:database-source-table 392*cdf0e10cSrcweir table:database-name CDATA #REQUIRED 393*cdf0e10cSrcweir table:table-name CDATA #REQUIRED 394*cdf0e10cSrcweir> 395*cdf0e10cSrcweir<!ELEMENT table:database-source-query EMPTY> 396*cdf0e10cSrcweir<!ATTLIST table:database-source-query 397*cdf0e10cSrcweir table:database-name CDATA #REQUIRED 398*cdf0e10cSrcweir table:query-name CDATA #REQUIRED 399*cdf0e10cSrcweir> 400*cdf0e10cSrcweir 401*cdf0e10cSrcweir<!ELEMENT table:sort (table:sort-by)+> 402*cdf0e10cSrcweir<!ATTLIST table:sort 403*cdf0e10cSrcweir table:bind-styles-to-content %boolean; "true" 404*cdf0e10cSrcweir table:target-range-address %cell-range-address; #IMPLIED 405*cdf0e10cSrcweir table:case-sensitive %boolean; "false" 406*cdf0e10cSrcweir table:language CDATA #IMPLIED 407*cdf0e10cSrcweir table:country CDATA #IMPLIED 408*cdf0e10cSrcweir table:algorithm CDATA #IMPLIED 409*cdf0e10cSrcweir> 410*cdf0e10cSrcweir<!ELEMENT table:sort-by EMPTY> 411*cdf0e10cSrcweir<!ATTLIST table:sort-by 412*cdf0e10cSrcweir table:field-number %nonNegativeInteger; #REQUIRED 413*cdf0e10cSrcweir table:data-type CDATA "automatic" 414*cdf0e10cSrcweir table:order (ascending | descending) "ascending" 415*cdf0e10cSrcweir> 416*cdf0e10cSrcweir 417*cdf0e10cSrcweir<!ELEMENT table:subtotal-rules (table:sort-groups? | table:subtotal-rule*)?> 418*cdf0e10cSrcweir<!ATTLIST table:subtotal-rules 419*cdf0e10cSrcweir table:bind-styles-to-content %boolean; "true" 420*cdf0e10cSrcweir table:case-sensitive %boolean; "false" 421*cdf0e10cSrcweir table:page-breaks-on-group-change %boolean; "false" 422*cdf0e10cSrcweir> 423*cdf0e10cSrcweir<!ELEMENT table:sort-groups EMPTY> 424*cdf0e10cSrcweir<!ATTLIST table:sort-groups 425*cdf0e10cSrcweir table:data-type CDATA "automatic" 426*cdf0e10cSrcweir table:order (ascending | descending) "ascending" 427*cdf0e10cSrcweir> 428*cdf0e10cSrcweir<!ELEMENT table:subtotal-rule (table:subtotal-field)*> 429*cdf0e10cSrcweir<!ATTLIST table:subtotal-rule 430*cdf0e10cSrcweir table:group-by-field-number %nonNegativeInteger; #REQUIRED 431*cdf0e10cSrcweir> 432*cdf0e10cSrcweir<!ELEMENT table:subtotal-field EMPTY> 433*cdf0e10cSrcweir<!ATTLIST table:subtotal-field 434*cdf0e10cSrcweir table:field-number %nonNegativeInteger; #REQUIRED 435*cdf0e10cSrcweir table:function CDATA #REQUIRED 436*cdf0e10cSrcweir> 437*cdf0e10cSrcweir 438*cdf0e10cSrcweir<!ELEMENT table:data-pilot-tables (table:data-pilot-table)*> 439*cdf0e10cSrcweir<!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+)> 440*cdf0e10cSrcweir<!ATTLIST table:data-pilot-table 441*cdf0e10cSrcweir table:name CDATA #REQUIRED 442*cdf0e10cSrcweir table:application-data CDATA #IMPLIED 443*cdf0e10cSrcweir table:grand-total (none | row | column | both) "both" 444*cdf0e10cSrcweir table:ignore-empty-rows %boolean; "false" 445*cdf0e10cSrcweir table:identify-categories %boolean; "false" 446*cdf0e10cSrcweir table:target-range-address %cell-range-address; #REQUIRED 447*cdf0e10cSrcweir table:buttons %cell-range-address-list; #REQUIRED 448*cdf0e10cSrcweir> 449*cdf0e10cSrcweir<!ELEMENT table:source-service EMPTY> 450*cdf0e10cSrcweir<!ATTLIST table:source-service 451*cdf0e10cSrcweir table:name CDATA #REQUIRED 452*cdf0e10cSrcweir table:source-name CDATA #REQUIRED 453*cdf0e10cSrcweir table:object-name CDATA #REQUIRED 454*cdf0e10cSrcweir table:username CDATA #IMPLIED 455*cdf0e10cSrcweir table:password CDATA #IMPLIED 456*cdf0e10cSrcweir> 457*cdf0e10cSrcweir<!ELEMENT table:source-cell-range (table:filter)?> 458*cdf0e10cSrcweir<!ATTLIST table:source-cell-range 459*cdf0e10cSrcweir table:cell-range-address %cell-range-address; #REQUIRED 460*cdf0e10cSrcweir> 461*cdf0e10cSrcweir<!ELEMENT table:data-pilot-field (table:data-pilot-level)?> 462*cdf0e10cSrcweir<!ATTLIST table:data-pilot-field 463*cdf0e10cSrcweir table:source-field-name CDATA #REQUIRED 464*cdf0e10cSrcweir table:is-data-layout-field %boolean; "false" 465*cdf0e10cSrcweir table:function CDATA #REQUIRED 466*cdf0e10cSrcweir table:orientation (row | column | data | page | hidden) #REQUIRED 467*cdf0e10cSrcweir table:used-hierarchy %positiveInteger; "1" 468*cdf0e10cSrcweir> 469*cdf0e10cSrcweir<!ELEMENT table:data-pilot-level (table:data-pilot-subtotals?, table:data-pilot-members?)> 470*cdf0e10cSrcweir<!ATTLIST table:data-pilot-level 471*cdf0e10cSrcweir table:display-empty %boolean; #IMPLIED 472*cdf0e10cSrcweir> 473*cdf0e10cSrcweir<!ELEMENT table:data-pilot-subtotals (table:data-pilot-subtotal)*> 474*cdf0e10cSrcweir<!ELEMENT table:data-pilot-subtotal EMPTY> 475*cdf0e10cSrcweir<!ATTLIST table:data-pilot-subtotal 476*cdf0e10cSrcweir table:function CDATA #REQUIRED 477*cdf0e10cSrcweir> 478*cdf0e10cSrcweir<!ELEMENT table:data-pilot-members (table:data-pilot-member)*> 479*cdf0e10cSrcweir<!ELEMENT table:data-pilot-member EMPTY> 480*cdf0e10cSrcweir<!ATTLIST table:data-pilot-member 481*cdf0e10cSrcweir table:name CDATA #REQUIRED 482*cdf0e10cSrcweir table:display %boolean; #IMPLIED 483*cdf0e10cSrcweir table:display-details %boolean; #IMPLIED 484*cdf0e10cSrcweir> 485*cdf0e10cSrcweir 486*cdf0e10cSrcweir<!ELEMENT table:consolidation EMPTY> 487*cdf0e10cSrcweir<!ATTLIST table:consolidation 488*cdf0e10cSrcweir table:function CDATA #REQUIRED 489*cdf0e10cSrcweir table:source-cell-range-addresses %cell-range-address-list; #REQUIRED 490*cdf0e10cSrcweir table:target-cell-address %cell-address; #REQUIRED 491*cdf0e10cSrcweir table:use-label (none | column | row | both) "none" 492*cdf0e10cSrcweir table:link-to-source-data %boolean; "false" 493*cdf0e10cSrcweir> 494*cdf0e10cSrcweir 495*cdf0e10cSrcweir<!ELEMENT table:dde-links (table:dde-link)+> 496*cdf0e10cSrcweir<!ELEMENT table:dde-link (office:dde-source, table:table)> 497