Warning, /office/calligra/sheets/dtd/kspread.dtd is written in an unsupported language. File is not indexed.
0001 <!-- $Id$
0002
0003 This is an XML document type definition (DTD) for the KSpread
0004 document format.
0005 Written by Kalle Dalheimer <kalle@kde.org> with (obviously) input from
0006 KSpread's author Torben Weis <weis@kde.org>.
0007
0008 Please report all bugs to Kalle and Torben at the above addresses.
0009
0010 Note that all tags are in fact lowercase.
0011 -->
0012
0013
0014
0015 <!-- A KSpread document consists of a paper description and a map that
0016 contains the table data.
0017
0018 Attributes:
0019
0020 author: The document's author
0021 email: The document's author's email address
0022 editor: The program this file was written with
0023 syntaxVersion: Integer version of the syntax. Currently 1.
0024 mime: The MIME type (must always have the value application/x-kspread)
0025 -->
0026 <!ELEMENT spreadsheet (paper, locale, areaname, map)>
0027 <!ATTLIST spreadsheet author CDATA #IMPLIED
0028 email CDATA #IMPLIED
0029 editor CDATA #IMPLIED
0030 syntaxVersion NMTOKEN #IMPLIED
0031 mime CDATA #FIXED "application/x-kspread">
0032
0033 <!-- Describes the page format. Can have no or one BORDERS child that
0034 describes the margins.
0035
0036 Attributes:
0037
0038 format: page format, e.g. "A4", "Letter", "Executive" etc.
0039 orientation: "Landscape" or "Portrait"
0040 -->
0041 <!ELEMENT paper (BORDERS|HEAD|FOOT)*>
0042 <!ATTLIST paper format CDATA #REQUIRED
0043 orientation CDATA #REQUIRED>
0044
0045
0046
0047 <!-- Describes the margins of the page.
0048
0049 Attributes:
0050
0051 left: left margin in pixels
0052 right: right margin in pixels
0053 top: top margin in pixels
0054 bottom: bottom margin in pixels
0055 -->
0056 <!ELEMENT borders EMPTY>
0057 <!ATTLIST borders left CDATA #REQUIRED
0058 right CDATA #REQUIRED
0059 top CDATA #REQUIRED
0060 bottom CDATA #REQUIRED>
0061
0062
0063 <!-- Describes the page header.
0064
0065 Attributes:
0066
0067 left: the text to appear in the upper left
0068 center: the text to appear in the upper middle
0069 right: the text to appear in the upper right
0070 -->
0071 <!ELEMENT head EMPTY>
0072 <!ATTLIST head left CDATA #IMPLIED
0073 center CDATA #IMPLIED
0074 right CDATA #IMPLIED>
0075
0076
0077 <!-- Describes the page footer.
0078
0079 Attributes:
0080
0081 left: the text to appear in the lower left
0082 center: the text to appear in the lower middle
0083 right: the text to appear in the lower right
0084 -->
0085 <!ELEMENT foot EMPTY>
0086 <!ATTLIST foot left CDATA #IMPLIED
0087 center CDATA #IMPLIED
0088 right CDATA #IMPLIED>
0089
0090
0091
0092 <!-- Contains locale format.
0093
0094 Attributes:
0095
0096 positivePrefixCurrencySymbol:
0097 negativeMonetarySignPosition:
0098 negativePrefixCurrencySymbol:
0099 fracDigits:
0100 thousandsSeparator:
0101 dateFormat:
0102 timeFormat:
0103 monetaryDecimalSymbol:
0104 weekStartsMonday:
0105 currencySymbol:
0106 negativeSign:
0107 positiveSign:
0108 positiveMonetarySignPosition:
0109 decimalSymbol:
0110 monetaryThousandsSeparator:
0111 dateFormatShort:
0112 -->
0113
0114 <!ELEMENT locale EMPTY>
0115 <!ATTLIST locale positivePrefixCurrencySymbol CDATA #REQUIRED
0116 negativeMonetarySignPosition CDATA #REQUIRED
0117 negativePrefixCurrencySymbol CDATA #REQUIRED
0118 fracDigits CDATA #REQUIRED
0119 thousandsSeparator CDATA #REQUIRED
0120 dateFormat CDATA #REQUIRED
0121 timeFormat CDATA #REQUIRED
0122 monetaryDecimalSymbol CDATA #REQUIRED
0123 weekStartsMonday CDATA #REQUIRED
0124 currencySymbol CDATA #REQUIRED
0125 negativeSign CDATA #REQUIRED
0126 positiveSign CDATA #REQUIRED
0127 positiveMonetarySignPosition CDATA #REQUIRED
0128 decimalSymbol CDATA #REQUIRED
0129 monetaryThousandsSeparator CDATA #REQUIRED
0130 dateFormatShort CDATA #REQUIRED>
0131
0132
0133 <!-- Contains the areaname for the various tables.
0134 Attributes:
0135 any
0136 -->
0137 <!ELEMENT areaname (reference)*>
0138
0139 <!-- Contains the definition of an area.
0140 Attributes:
0141 any
0142 -->
0143 <!ELEMENT reference (tabname,refname,rect)>
0144
0145 <!ELEMENT tabname (#PCDATA)>
0146
0147
0148 <!ELEMENT refname (#PCDATA)>
0149
0150 <!--
0151 They are two conflicting uses of <rect>
0152
0153 Use 1:
0154 Describe the area selected.
0155 Attributes:
0156
0157 left-rect value of the left border
0158 right-rect value of the right border
0159 bottom-rect value of the bottom border
0160 top-rect value of the top border
0161
0162 Use 2:
0163 Use unknown (### TODO)
0164 Attributes:
0165 x x position
0166 y y posution
0167 w width
0168 h height
0169 -->
0170 <!ELEMENT rect EMPTY>
0171 <!ATTLIST rect left-rect CDATA #IMPLIED
0172 right-rect CDATA #IMPLIED
0173 bottom-rect CDATA #IMPLIED
0174 top-rect CDATA #IMPLIED
0175 x CDATA #IMPLIED
0176 y CDATA #IMPLIED
0177 w CDATA #IMPLIED
0178 h CDATA #IMPLIED>
0179
0180 <!-- Contains the table data for the various tables.
0181
0182 Attributes:
0183 activeTable allows to set the active table
0184 markerColumn and markerRow allow to set the active cell
0185 -->
0186 <!ELEMENT map (table)*>
0187 <!ATTLIST map activeTable CDATA #IMPLIED
0188 markerColumn CDATA #IMPLIED
0189 markerRow CDATA #IMPLIED>
0190
0191
0192 <!-- Contains the data in one table or embedded objects.
0193
0194 Attributes:
0195
0196 name the name of the table
0197 columnnumber display column header as number
0198 borders show/hide page border (hide = "0", show = "1")
0199 hide hide/show table (hide ="1", show="0")
0200 hidezero don't show zero value (hide="1",show="0")
0201 firstletterupper Upper first letter (upper="1",nothing="0")
0202 grid show/hide grid on screen (hide="1", show="0")
0203 printGrid show/hide grid on printout (hide="1", show="0")
0204 printCommentIndicator show/hide comment indicator on printout (hide="1", show="0")
0205 printFormulaIndicator show/hide formula indicator on printout (hide="1", show="0")
0206 printGrid show/hide grid on printout (hide="1", show="0")
0207 printGrid zoom factor on printout (100%="1.0")
0208 showFormula show/hide formula
0209 showFormulaIndicator show/hide formula indicator on screen (hide="1", show="0")
0210 printZoom zoom of the printout ("100" = 100%)
0211 printPageLimitX adjust zoom to limit of pages in x direction, 0 = no limit
0212 printPageLimitY adjust zoom to limit of pages in y direction, 0 = no limit
0213 lcmode write on LxCx area selected
0214 autoCalc Autorecalc formula
0215 -->
0216 <!ELEMENT table (paper|cell|chart|column|row|printrange-rect|printrepeatcolumns|printrepeatrows)*>
0217 <!ATTLIST table name CDATA #REQUIRED
0218 columnnumber CDATA #REQUIRED
0219 borders CDATA #REQUIRED
0220 hide CDATA #REQUIRED
0221 hidezero CDATA #REQUIRED
0222 firstletterupper CDATA #REQUIRED
0223 grid CDATA #REQUIRED
0224 printGrid CDATA #REQUIRED
0225 printCommentIndicator CDATA #REQUIRED
0226 printFormulaIndicator CDATA #REQUIRED
0227 showFormula CDATA #REQUIRED
0228 showFormulaIndicator CDATA #REQUIRED
0229 printZoom CDATA #REQUIRED
0230 printPageLimitX CDATA #REQUIRED
0231 printPageLimitY CDATA #REQUIRED
0232 lcmode CDATA #REQUIRED
0233 borders1.2 CDATA #REQUIRED
0234 autoCalc CDATA #REQUIRED>
0235
0236
0237 <!-- Describes one cell including contents.
0238
0239 Attributes:
0240
0241 row the row number of the cell (starts at 1)
0242 column the column number of the cell (starts at 1)
0243 -->
0244 <!ELEMENT cell (text|result|format|validity|condition)*>
0245 <!ATTLIST cell row CDATA #REQUIRED
0246 column CDATA #REQUIRED>
0247
0248 <!-- Describes the contents of the cell.
0249 For instance, <text>My string</text> or
0250 <text>=A4+B5</text>
0251 Date data is stored in a locale independant way -
0252 <text>yyyy/mm/dd</text>
0253
0254 The dataType attribute may be any of "Str", "Bool" "Num", "Date",
0255 "Time", or "Other".
0256 -->
0257 <!ELEMENT text (#PCDATA)>
0258 <!ATTLIST text dataType CDATA #IMPLIED>
0259
0260
0261 <!-- result - describes the result of a formula
0262 only found in cells with formulas, and the format is identical
0263 to a 'text' attribute of a cell with just data.
0264 -->
0265 <!ELEMENT result (#PCDATA)>
0266 <!ATTLIST result dataType CDATA #IMPLIED>
0267
0268 <!-- Describes the format of one cell.
0269
0270 TODO: describe attributes
0271 -->
0272 <!ELEMENT format (font?,pen?)>
0273 <!ATTLIST format align CDATA #REQUIRED
0274 alignY CDATA #REQUIRED
0275 bgcolor CDATA #REQUIRED
0276 multirow CDATA #REQUIRED
0277 verticaltext CDATA #REQUIRED
0278 precision CDATA #REQUIRED
0279 prefix CDATA #REQUIRED
0280 postfix CDATA #REQUIRED
0281 float CDATA #REQUIRED
0282 floatcolor CDATA #REQUIRED
0283 faktor CDATA #REQUIRED
0284 format CDATA #REQUIRED
0285 angle CDATA #REQUIRED
0286 brushcolor CDATA #REQUIRED
0287 indent CDATA #REQUIRED
0288 dontprinttext CDATA #REQUIRED>
0289
0290
0291 <!ELEMENT pen EMPTY>
0292 <!ATTLIST pen width CDATA #REQUIRED
0293 style CDATA #REQUIRED
0294 color CDATA #REQUIRED>
0295
0296 <!ELEMENT font EMPTY>
0297 <!ATTLIST font size CDATA #REQUIRED
0298 family CDATA #REQUIRED
0299 weight CDATA #REQUIRED>
0300
0301 <!ELEMENT validity (param,title,message,timemin,timemax,inputtitle,inputmessage)>
0302
0303 <!-- Describes validate format.
0304
0305 Attributes:
0306 valmin Minimal value of the validate condition
0307 cond type of condition (None, Equal,Superior,Inferior,SuperiorEqual,InferiorEqual,Between,Different, DifferentTo)
0308 valmax Maximal value of the validate condition
0309 allow type of value allows (Allow_All, Allow_Number, Allow_Text,Allow_Time,Allow_Date,Allow_Integer,Allow_TextLength, Allow_List)
0310 action Action executes when it's not validate (Error, warning etc...)
0311 displaymessage display or not error alert
0312 displayvalidationinformation display or not input help
0313 allowemptycell allow to have an empty cell
0314 listvalidity gave list of test allow into cell
0315 -->
0316 <!ELEMENT param EMPTY>
0317 <!ATTLIST param valmin CDATA #REQUIRED
0318 cond CDATA #REQUIRED
0319 valmax CDATA #REQUIRED
0320 allow CDATA #REQUIRED
0321 action CDATA #REQUIRED
0322 displaymessage CDATA #REQUIRED
0323 displayvalidationinformation CDATA #REQUIRED
0324 allowemptycell CDATA #REQUIRED
0325 listvalidity CDATA #REQUIRED>
0326
0327 <!ELEMENT title (#PCDATA)>
0328
0329 <!ELEMENT message (#PCDATA)>
0330
0331 <!ELEMENT timemin (#PCDATA)>
0332
0333 <!ELEMENT timemax (#PCDATA)>
0334
0335 <!ELEMENT inputmessage (#PCDATA)>
0336
0337 <!ELEMENT inputtitle (#PCDATA)>
0338
0339 <!-- Describes conditional cell attribut format.
0340 -->
0341 <!ELEMENT condition (first | second | third)>
0342
0343
0344 <!-- Describes first conditon format.
0345
0346 Attributes:
0347
0348 cond: Define the condition apply on the cell (NONE, EQUAL etc...)
0349 val1: Inferior value of condition
0350 val2: Superior value of condition
0351 color: Color apply when condition is right
0352 -->
0353
0354 <!ELEMENT first (font) >
0355 <!ATTLIST first cond CDATA #REQUIRED
0356 val1 CDATA #REQUIRED
0357 val2 CDATA #REQUIRED
0358 color CDATA #REQUIRED>
0359
0360 <!ELEMENT second (font) >
0361 <!ATTLIST second cond CDATA #REQUIRED
0362 val1 CDATA #REQUIRED
0363 val2 CDATA #REQUIRED
0364 color CDATA #REQUIRED>
0365
0366 <!ELEMENT third (font) >
0367 <!ATTLIST third cond CDATA #REQUIRED
0368 val1 CDATA #REQUIRED
0369 val2 CDATA #REQUIRED
0370 color CDATA #REQUIRED>
0371
0372
0373 <!-- Describes one column
0374
0375 Attributes:
0376
0377 column the column number
0378 width the width of the column in points
0379 -->
0380 <!ELEMENT column (format)>
0381 <!ATTLIST column column CDATA #REQUIRED
0382 width CDATA #REQUIRED>
0383
0384
0385 <!-- Describes one row
0386
0387 Attributes:
0388
0389 row the row number
0390 height the height of the row in points
0391 -->
0392 <!ELEMENT row (format)>
0393 <!ATTLIST row row CDATA #REQUIRED
0394 height CDATA #REQUIRED>
0395
0396
0397 <!-- Describe the print range.
0398 Attributes:
0399
0400 left-rect value of the left border
0401 right-rect value of the right border
0402 bottom-rect value of the bottom border
0403 top-rect value of the top border
0404 -->
0405 <!ELEMENT printrange-rect EMPTY>
0406 <!ATTLIST printrange-rect left-rect CDATA #IMPLIED
0407 right-rect CDATA #IMPLIED
0408 bottom-rect CDATA #IMPLIED
0409 top-rect CDATA #IMPLIED>
0410
0411
0412 <!-- Describe the repeated columns on printout.
0413 Attributes:
0414
0415 left value of the left column
0416 right value of the right column
0417 -->
0418 <!ELEMENT printrepeatcolumns EMPTY>
0419 <!ATTLIST printrepeatcolumns left CDATA #IMPLIED
0420 right CDATA #IMPLIED>
0421
0422 <!-- Describe the repeated rows on printout.
0423 Attributes:
0424
0425 top value of the top row
0426 bottom value of the bottom row
0427 -->
0428 <!ELEMENT printrepeatrows EMPTY>
0429 <!ATTLIST printrepeatrows row CDATA #IMPLIED
0430 bottom CDATA #IMPLIED>
0431
0432
0433 <!-- Describes an embedded chart.
0434
0435 Attributes:
0436
0437 url the URL of the embedded chart
0438 (example: "store:/Table 1/0")
0439 mime the MIME type of the application that has generated
0440 the chart
0441 -->
0442 <!ELEMENT chart (rect|binding)*>
0443 <!ATTLIST chart url CDATA #REQUIRED
0444 mime CDATA #REQUIRED>
0445
0446 <!ELEMENT binding (rect)>
0447