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