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