/usr/share/kde4/apps/sheets/dtd/kspread.dtd is in calligrasheets 1:2.4.0-0ubuntu2.1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 | <!-- $Id$
This is an XML document type definition (DTD) for the KSpread
document format.
Written by Kalle Dalheimer <kalle@kde.org> with (obviously) input from
KSpread's author Torben Weis <weis@kde.org>.
Please report all bugs to Kalle and Torben at the above addresses.
Note that all tags are in fact lowercase.
-->
<!-- A KSpread document consists of a paper description and a map that
contains the table data.
Attributes:
author: The document's author
email: The document's author's email address
editor: The program this file was written with
syntaxVersion: Integer version of the syntax. Currently 1.
mime: The MIME type (must always have the value application/x-kspread)
-->
<!ELEMENT spreadsheet (paper, locale, areaname, map)>
<!ATTLIST spreadsheet author CDATA #IMPLIED
email CDATA #IMPLIED
editor CDATA #IMPLIED
syntaxVersion NMTOKEN #IMPLIED
mime CDATA #FIXED "application/x-kspread">
<!-- Describes the page format. Can have no or one BORDERS child that
describes the margins.
Attributes:
format: page format, e.g. "A4", "Letter", "Executive" etc.
orientation: "Landscape" or "Portrait"
-->
<!ELEMENT paper (BORDERS|HEAD|FOOT)*>
<!ATTLIST paper format CDATA #REQUIRED
orientation CDATA #REQUIRED>
<!-- Describes the margins of the page.
Attributes:
left: left margin in pixels
right: right margin in pixels
top: top margin in pixels
bottom: bottom margin in pixels
-->
<!ELEMENT borders EMPTY>
<!ATTLIST borders left CDATA #REQUIRED
right CDATA #REQUIRED
top CDATA #REQUIRED
bottom CDATA #REQUIRED>
<!-- Describes the page header.
Attributes:
left: the text to appear in the upper left
center: the text to appear in the upper middle
right: the text to appear in the upper right
-->
<!ELEMENT head EMPTY>
<!ATTLIST head left CDATA #IMPLIED
center CDATA #IMPLIED
right CDATA #IMPLIED>
<!-- Describes the page footer.
Attributes:
left: the text to appear in the lower left
center: the text to appear in the lower middle
right: the text to appear in the lower right
-->
<!ELEMENT foot EMPTY>
<!ATTLIST foot left CDATA #IMPLIED
center CDATA #IMPLIED
right CDATA #IMPLIED>
<!-- Contains locale format.
Attributes:
positivePrefixCurrencySymbol:
negativeMonetarySignPosition:
negativePrefixCurrencySymbol:
fracDigits:
thousandsSeparator:
dateFormat:
timeFormat:
monetaryDecimalSymbol:
weekStartsMonday:
currencySymbol:
negativeSign:
positiveSign:
positiveMonetarySignPosition:
decimalSymbol:
monetaryThousandsSeparator:
dateFormatShort:
-->
<!ELEMENT locale EMPTY>
<!ATTLIST locale positivePrefixCurrencySymbol CDATA #REQUIRED
negativeMonetarySignPosition CDATA #REQUIRED
negativePrefixCurrencySymbol CDATA #REQUIRED
fracDigits CDATA #REQUIRED
thousandsSeparator CDATA #REQUIRED
dateFormat CDATA #REQUIRED
timeFormat CDATA #REQUIRED
monetaryDecimalSymbol CDATA #REQUIRED
weekStartsMonday CDATA #REQUIRED
currencySymbol CDATA #REQUIRED
negativeSign CDATA #REQUIRED
positiveSign CDATA #REQUIRED
positiveMonetarySignPosition CDATA #REQUIRED
decimalSymbol CDATA #REQUIRED
monetaryThousandsSeparator CDATA #REQUIRED
dateFormatShort CDATA #REQUIRED>
<!-- Contains the areaname for the various tables.
Attributes:
any
-->
<!ELEMENT areaname (reference)*>
<!-- Contains the definition of an area.
Attributes:
any
-->
<!ELEMENT reference (tabname,refname,rect)>
<!ELEMENT tabname (#PCDATA)>
<!ELEMENT refname (#PCDATA)>
<!--
They are two conflicting uses of <rect>
Use 1:
Describe the area selected.
Attributes:
left-rect value of the left border
right-rect value of the right border
bottom-rect value of the bottom border
top-rect value of the top border
Use 2:
Use unknown (### TODO)
Attributes:
x x position
y y posution
w width
h height
-->
<!ELEMENT rect EMPTY>
<!ATTLIST rect left-rect CDATA #IMPLIED
right-rect CDATA #IMPLIED
bottom-rect CDATA #IMPLIED
top-rect CDATA #IMPLIED
x CDATA #IMPLIED
y CDATA #IMPLIED
w CDATA #IMPLIED
h CDATA #IMPLIED>
<!-- Contains the table data for the various tables.
Attributes:
activeTable allows to set the active table
markerColumn and markerRow allow to set the active cell
-->
<!ELEMENT map (table)*>
<!ATTLIST map activeTable CDATA #IMPLIED
markerColumn CDATA #IMPLIED
markerRow CDATA #IMPLIED>
<!-- Contains the data in one table or embedded objects.
Attributes:
name the name of the table
columnnumber display column header as number
borders show/hide page border (hide = "0", show = "1")
hide hide/show table (hide ="1", show="0")
hidezero don't show zero value (hide="1",show="0")
firstletterupper Upper first letter (upper="1",nothing="0")
grid show/hide grid on screen (hide="1", show="0")
printGrid show/hide grid on printout (hide="1", show="0")
printCommentIndicator show/hide comment indicator on printout (hide="1", show="0")
printFormulaIndicator show/hide formula indicator on printout (hide="1", show="0")
printGrid show/hide grid on printout (hide="1", show="0")
printGrid zoom factor on printout (100%="1.0")
showFormula show/hide formula
showFormulaIndicator show/hide formula indicator on screen (hide="1", show="0")
printZoom zoom of the printout ("100" = 100%)
printPageLimitX adjust zoom to limit of pages in x direction, 0 = no limit
printPageLimitY adjust zoom to limit of pages in y direction, 0 = no limit
lcmode write on LxCx area selected
autoCalc Autorecalc formula
-->
<!ELEMENT table (paper|cell|chart|column|row|printrange-rect|printrepeatcolumns|printrepeatrows)*>
<!ATTLIST table name CDATA #REQUIRED
columnnumber CDATA #REQUIRED
borders CDATA #REQUIRED
hide CDATA #REQUIRED
hidezero CDATA #REQUIRED
firstletterupper CDATA #REQUIRED
grid CDATA #REQUIRED
printGrid CDATA #REQUIRED
printCommentIndicator CDATA #REQUIRED
printFormulaIndicator CDATA #REQUIRED
showFormula CDATA #REQUIRED
showFormulaIndicator CDATA #REQUIRED
printZoom CDATA #REQUIRED
printPageLimitX CDATA #REQUIRED
printPageLimitY CDATA #REQUIRED
lcmode CDATA #REQUIRED
borders1.2 CDATA #REQUIRED
autoCalc CDATA #REQUIRED>
<!-- Describes one cell including contents.
Attributes:
row the row number of the cell (starts at 1)
column the column number of the cell (starts at 1)
-->
<!ELEMENT cell (text|result|format|validity|condition)*>
<!ATTLIST cell row CDATA #REQUIRED
column CDATA #REQUIRED>
<!-- Describes the contents of the cell.
For instance, <text>My string</text> or
<text>=A4+B5</text>
Date data is stored in a locale independant way -
<text>yyyy/mm/dd</text>
The dataType attribute may be any of "Str", "Bool" "Num", "Date",
"Time", or "Other".
-->
<!ELEMENT text (#PCDATA)>
<!ATTLIST text dataType CDATA #IMPLIED>
<!-- result - describes the result of a formula
only found in cells with formulas, and the format is identical
to a 'text' attribute of a cell with just data.
-->
<!ELEMENT result (#PCDATA)>
<!ATTLIST result dataType CDATA #IMPLIED>
<!-- Describes the format of one cell.
TODO: describe attributes
-->
<!ELEMENT format (font?,pen?)>
<!ATTLIST format align CDATA #REQUIRED
alignY CDATA #REQUIRED
bgcolor CDATA #REQUIRED
multirow CDATA #REQUIRED
verticaltext CDATA #REQUIRED
precision CDATA #REQUIRED
prefix CDATA #REQUIRED
postfix CDATA #REQUIRED
float CDATA #REQUIRED
floatcolor CDATA #REQUIRED
faktor CDATA #REQUIRED
format CDATA #REQUIRED
angle CDATA #REQUIRED
brushcolor CDATA #REQUIRED
indent CDATA #REQUIRED
dontprinttext CDATA #REQUIRED>
<!ELEMENT pen EMPTY>
<!ATTLIST pen width CDATA #REQUIRED
style CDATA #REQUIRED
color CDATA #REQUIRED>
<!ELEMENT font EMPTY>
<!ATTLIST font size CDATA #REQUIRED
family CDATA #REQUIRED
weight CDATA #REQUIRED>
<!ELEMENT validity (param,title,message,timemin,timemax,inputtitle,inputmessage)>
<!-- Describes validate format.
Attributes:
valmin Minimal value of the validate condition
cond type of condition (None, Equal,Superior,Inferior,SuperiorEqual,InferiorEqual,Between,Different, DifferentTo)
valmax Maximal value of the validate condition
allow type of value allows (Allow_All, Allow_Number, Allow_Text,Allow_Time,Allow_Date,Allow_Integer,Allow_TextLength, Allow_List)
action Action executes when it's not validate (Error, warning etc...)
displaymessage display or not error alert
displayvalidationinformation display or not input help
allowemptycell allow to have an empty cell
listvalidity gave list of test allow into cell
-->
<!ELEMENT param EMPTY>
<!ATTLIST param valmin CDATA #REQUIRED
cond CDATA #REQUIRED
valmax CDATA #REQUIRED
allow CDATA #REQUIRED
action CDATA #REQUIRED
displaymessage CDATA #REQUIRED
displayvalidationinformation CDATA #REQUIRED
allowemptycell CDATA #REQUIRED
listvalidity CDATA #REQUIRED>
<!ELEMENT title (#PCDATA)>
<!ELEMENT message (#PCDATA)>
<!ELEMENT timemin (#PCDATA)>
<!ELEMENT timemax (#PCDATA)>
<!ELEMENT inputmessage (#PCDATA)>
<!ELEMENT inputtitle (#PCDATA)>
<!-- Describes conditional cell attribut format.
-->
<!ELEMENT condition (first | second | third)>
<!-- Describes first conditon format.
Attributes:
cond: Define the condition apply on the cell (NONE, EQUAL etc...)
val1: Inferior value of condition
val2: Superior value of condition
color: Color apply when condition is right
-->
<!ELEMENT first (font) >
<!ATTLIST first cond CDATA #REQUIRED
val1 CDATA #REQUIRED
val2 CDATA #REQUIRED
color CDATA #REQUIRED>
<!ELEMENT second (font) >
<!ATTLIST second cond CDATA #REQUIRED
val1 CDATA #REQUIRED
val2 CDATA #REQUIRED
color CDATA #REQUIRED>
<!ELEMENT third (font) >
<!ATTLIST third cond CDATA #REQUIRED
val1 CDATA #REQUIRED
val2 CDATA #REQUIRED
color CDATA #REQUIRED>
<!-- Describes one column
Attributes:
column the column number
width the width of the column in points
-->
<!ELEMENT column (format)>
<!ATTLIST column column CDATA #REQUIRED
width CDATA #REQUIRED>
<!-- Describes one row
Attributes:
row the row number
height the height of the row in points
-->
<!ELEMENT row (format)>
<!ATTLIST row row CDATA #REQUIRED
height CDATA #REQUIRED>
<!-- Describe the print range.
Attributes:
left-rect value of the left border
right-rect value of the right border
bottom-rect value of the bottom border
top-rect value of the top border
-->
<!ELEMENT printrange-rect EMPTY>
<!ATTLIST printrange-rect left-rect CDATA #IMPLIED
right-rect CDATA #IMPLIED
bottom-rect CDATA #IMPLIED
top-rect CDATA #IMPLIED>
<!-- Describe the repeated columns on printout.
Attributes:
left value of the left column
right value of the right column
-->
<!ELEMENT printrepeatcolumns EMPTY>
<!ATTLIST printrepeatcolumns left CDATA #IMPLIED
right CDATA #IMPLIED>
<!-- Describe the repeated rows on printout.
Attributes:
top value of the top row
bottom value of the bottom row
-->
<!ELEMENT printrepeatrows EMPTY>
<!ATTLIST printrepeatrows row CDATA #IMPLIED
bottom CDATA #IMPLIED>
<!-- Describes an embedded chart.
Attributes:
url the URL of the embedded chart
(example: "store:/Table 1/0")
mime the MIME type of the application that has generated
the chart
-->
<!ELEMENT chart (rect|binding)*>
<!ATTLIST chart url CDATA #REQUIRED
mime CDATA #REQUIRED>
<!ELEMENT binding (rect)>
|