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