File indexing completed on 2025-01-19 13:27:13
0001 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> 0002 <html> 0003 <head> 0004 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 0005 <title>Calligra filters status: Applix Spreadsheet FILTER</title> 0006 </head> 0007 <body text="#000000" bgcolor="#FFFFFF" link="#000099" vlink="#666666" alink="#666666"> 0008 <A NAME="START"> </A> 0009 0010 <BR> 0011 <center> 0012 <h1> 0013 Calligra filters status: <i>Applix Spreadsheet FILTER</i> 0014 </h1> 0015 </center> 0016 0017 <hr NOSHADE SIZE=2 WIDTH="70%"> 0018 0019 <font size="-1"><b> 0020 <A HREF="#import">Import</A> | 0021 <A HREF="#export">Export</A> 0022 </b></font> 0023 0024 <BR><BR><BR> 0025 <center><a NAME="import"></a></center> 0026 0027 <A HREF="#START"><font size="-1"><b>Up</b></font></A> 0028 <center> 0029 <table BORDER=0 CELLSPACING=0 BGCOLOR="#000000" WIDTH="100%"> 0030 <tr> 0031 <td> 0032 <table BORDER=0 CELLPADDING=2 BGCOLOR="#FFFFFF" WIDTH="100%"> 0033 0034 <tr BGCOLOR="#DDFFDD"> 0035 <td COLSPAN="2"> 0036 <center><b><i><font size="+1"> 0037 <BR> 0038 Import Applix Spreadsheet for kspread<BR> 0039 <BR> 0040 </font></i></b></center> 0041 </td> 0042 </tr> 0043 0044 <tr BGCOLOR="#EEEEFF"> 0045 <td VALIGN=TOP WIDTH="1%" NOWRAP><b><font size="+1">Last update</font></b></td> 0046 <td>03 mar 2001</td> 0047 </tr> 0048 0049 <tr BGCOLOR="#CCCCFF"> 0050 <td VALIGN=TOP><b><font size="+1">Features</font></b></td> 0051 <td> 0052 - can import simple and complex Applix Spreadsheet documents<br> 0053 - tests the headline of the document<br> 0054 - converts <, >, &, to &lt; &gt; &amp;<br> 0055 - converts all applix special characters<br> 0056 - converts fontsize, fontcolor, horizontal and vertical alignment, bold, italic, underline<br> 0057 - eats long text strings (more than one row in inputfile)<br> 0058 - converts different tables inside of one document<br> 0059 - cellformat: background color, brushstyles, brushcolor<br> 0060 - cellframe: linewidth, linetype, linecolor<br> 0061 - row height and column width<br> 0062 - converting the fontfamily (incl. reading the typeface table)<br> 0063 - correct process bar value emiting (procent)<br> 0064 - rows A-Z and greater Z (AA-ZZ) are right translate into integer values<br> 0065 - detects formulas<br> 0066 </td> 0067 </tr> 0068 0069 <tr BGCOLOR="#EEEEFF"> 0070 <td VALIGN=TOP><b><font size="+1">Todo</font></b></td> 0071 <td> 0072 - cellframes: double lines are not supported in kspread till now. So they can't translated correct.<br> 0073 - check the row height and column width - they are not right sometimes<br> 0074 - grouped row and column formats<br> 0075 - add endoffile checking with dialog in do-while loops<br> 0076 - convert a formula, date or something else right with cell references<br> 0077 - change the printf output to debug (xxxxx) output<br> 0078 </td> 0079 </tr> 0080 0081 <tr BGCOLOR="#CCCCFF"> 0082 <td VALIGN=TOP><b><font size="+1">History</font></b></td> 0083 <td> 0084 0085 0086 <table border="0" cellspacing="0"> 0087 <tr valign=top> 0088 <td align=right>17 mar 2001</td> 0089 <td> : </td> 0090 <td>The fontfamily in support (incl. bugfix)<BR> 0091 Longnamed columns like AA are right supported now- for cell elements and column width elements<BR> 0092 Corrected the row width values. They start with 32768!<BR> 0093 Little code cleanup. Updated the fileformat description. 0094 </td> 0095 </tr> 0096 <tr> 0097 <td align=right>13 mar 2001</td> 0098 <td> : </td> 0099 <td>Added the progress bar value emiting (<A HREF="faure@kde.org">David Faure</A>)</td> 0100 </tr> 0101 <tr> 0102 <td align=right>11 mar 2001</td> 0103 <td> : </td> 0104 <td>Added fileformat description.</td> 0105 </tr> 0106 <tr> 0107 <td align=right>10 mar 2001</td> 0108 <td> : </td> 0109 <td>Checked in this version after discussion with David Faure. He told me that he just tried to begin with a applix spreadsheet import filter too.</td> 0110 </tr> 0111 <tr> 0112 <td align=right>09 mar 2001</td> 0113 <td> : </td> 0114 <td>Read the row height and column width.</td> 0115 </tr> 0116 <tr> 0117 <td align=right>03 mar 2001</td> 0118 <td> : </td> 0119 <td>Reads the typefont and the colortable, converts cmyk to rgb, added some style information (cell and string)</td> 0120 </tr> 0121 <tr> 0122 <td align=right>24 feb 2001</td> 0123 <td> : </td> 0124 <td>Add <, >, & and applix character convertation</td> 0125 </tr> 0126 <tr> 0127 <td align=right>11 feb 2001</td> 0128 <td> : </td> 0129 <td>Written a filter that only can filter simple applix files</td> 0130 </tr> 0131 </table> 0132 0133 0134 </td> 0135 </tr> 0136 0137 <tr BGCOLOR="#EEEEFF"> 0138 <td VALIGN=TOP><b><font size="+1">Authors </font></b></td> 0139 <td><A HREF="mailto:ebartels@nwn.de">Enno Bartels</A></td> 0140 </tr> 0141 0142 <tr BGCOLOR="#CCCCFF"> 0143 <td VALIGN=TOP><b><font size="+1">Links</font></b></td> 0144 <td><A HREF="http://home.nordwest.net/ebartels/applixinfo/as/index.html">Applixword example</A></td> 0145 </tr> 0146 0147 <tr BGCOLOR="#EEEEFF"> 0148 <td VALIGN=TOP><b><font size="+1">Progress report </font></b></td> 0149 <td><B><U><font size="+1">Fileformat:</font></U></B><BR> 0150 <BR> 0151 <B><U>Main Structure:</U></B><BR> 0152 <spacer size="20">1. Header<BR> 0153 <spacer size="20">2. Colortable<BR> 0154 <spacer size="20">3. Fonttable<BR> 0155 <spacer size="20">...<BR> 0156 <spacer size="20">4. View<BR> 0157 <spacer size="20">...<BR> 0158 <spacer size="20">5. Headers and footers<BR> 0159 <spacer size="20">6. Cellvalues<BR> 0160 <spacer size="20">7. End<BR><BR><BR> 0161 0162 0163 <B><U>1. Header:</U></B><BR> 0164 <spacer size="10">The headerline looks like that:<BR> 0165 <spacer size="20"><B><I>*BEGIN SPREADSHEETS VERSION=430/430 ENCODING=7BIT</I></B><BR><BR><BR> 0166 0167 0168 <B><U>2. Colormap:</U></B><BR> 0169 <spacer size="10">The colormap has 3 parts<BR> 0170 <spacer size="10">2.1. Starting line<BR> 0171 <spacer size="10">2.2. Value lines<BR> 0172 <spacer size="10">2.3. Ending line<BR> 0173 <BR> 0174 0175 <spacer size="10"><U>2.1. Colormap start:</U><BR> 0176 <spacer size="20">The colormap begins with this line<BR> 0177 <spacer size="20"><B><I>COLORMAP</I></B><BR> 0178 <BR> 0179 0180 <spacer size="10"><U>2.2. Colormap value:</U><BR> 0181 <spacer size="20">A color value line has the following parts (cmyk - colorsystem)<BR> 0182 <spacer size="20"><B>Text 0 c m y k 0</B><BR> 0183 <BR> 0184 0185 <spacer size="20"> 0186 <TABLE CELLPADDING="0" BORDER="0"> 0187 <TR> 0188 <TD>2.2.1.</TD> 0189 <TD>Text</TD> 0190 <TD>= Textstring</TD> 0191 <TD>-</TD> 0192 </TR> 0193 <TR> 0194 <TD>2.2.2.</TD> 0195 <TD>0</TD> 0196 <TD>= NULL</TD> 0197 <TD>-</TD> 0198 </TR> 0199 <TR> 0200 <TD>2.2.3.</TD> 0201 <TD>c</TD> 0202 <TD>= cyan</TD> 0203 <TD>0-255</TD> 0204 </TR> 0205 <TR> 0206 <TD>2.2.4.</TD> 0207 <TD>m</TD> 0208 <TD>= magenta</TD> 0209 <TD>0-255</TD> 0210 </TR> 0211 <TR> 0212 <TD>2.2.5.</TD> 0213 <TD>y</TD> 0214 <TD>= yellow</TD> 0215 <TD>0-255</TD> 0216 </TR> 0217 <TR> 0218 <TD>2.2.6.</TD> 0219 <TD>k</TD> 0220 <TD>= black (key)</TD> 0221 <TD>0-255</TD> 0222 </TR> 0223 <TR> 0224 <TD>2.2.7.</TD> 0225 <TD>0</TD> 0226 <TD>= NULL</TD> 0227 <TD>-</TD> 0228 </TR> 0229 </TABLE> 0230 <BR><BR> 0231 0232 <spacer size="20">Color converting is very simple cmyk to rgb:<BR> 0233 <spacer size="20">r = 255 - (c+k)<BR> 0234 <spacer size="20">g = 255 - (m+k)<BR> 0235 <spacer size="20">b = 255 - (y+k)<BR> 0236 <spacer size="20">If the value of r, g or b if less then 0 you must set it to 0 .<BR> 0237 <BR> 0238 <spacer size="20">For examples inside calligra look a this files too<br> 0239 <spacer size="20"><I>calligra/kimageshop/core/kis_color.cc and kis_color.h</I><BR> 0240 <BR><BR> 0241 0242 <spacer size="10"><U>2.3. Colormap end:</U><BR> 0243 <spacer size="20">The colormap ends with this line:<BR> 0244 <spacer size="20"><B><I>END COLORMAP</I></B> 0245 <BR><BR> 0246 0247 0248 <B><U>3. Fonttable:</U></B><BR> 0249 <spacer size="10">The fonttable has 3 parts<BR> 0250 <spacer size="10">3.1. Starting line<BR> 0251 <spacer size="10">3.2. Value lines<BR> 0252 <spacer size="10">3.3. Ending line<BR> 0253 <BR> 0254 0255 <spacer size="10"><U>3.1. Starting line</U><BR> 0256 <spacer size="20">The fonttable begins with this line:<BR> 0257 <spacer size="20"><B><I>TYPEFACE TABLE</I></B><BR> 0258 <BR> 0259 0260 <spacer size="10"><U>3.2. Value line</U><BR> 0261 <spacer size="20">The fonttable value line looks like that:<BR> 0262 <spacer size="20"><B>Helvetica</B><BR> 0263 <BR> 0264 0265 <spacer size="10"><U>3.3. Ending line</U><BR> 0266 <spacer size="20">The colormap ends with this line ends with<BR> 0267 <spacer size="20"><B><I>END TYPEFACE TABLE</I></B><BR> 0268 <BR><BR> 0269 0270 0271 <B><U>4. View:</U></B><BR> 0272 <spacer size="10">Each table has its own view section and everyone has 3 parts<br> 0273 <spacer size="10">4.1. Starting line<BR> 0274 <spacer size="10">4.2. Value lines<BR> 0275 <spacer size="10">4.3. Ending line<BR> 0276 <spacer size="10">This is an example with the table name <B>A</B><BR> 0277 <BR> 0278 0279 <spacer size="10"><U>4.1. Starting line</U><BR> 0280 <spacer size="20">The view of table <B>A</B> begins with this line:<BR> 0281 <spacer size="20"><B><I>View Start, Name: ~A:~</I></B><br> 0282 <BR> 0283 0284 <spacer size="10"><U>4.2. Value lines</U><BR> 0285 <spacer size="20">There are different value lines, but all of them start with <B>view</B><BR> 0286 <spacer size="20">There are following important value lines:<BR> 0287 0288 <spacer size="20">4.2.1. Column width <BR> 0289 <spacer size="20">4.2.2. Row heights<BR> 0290 <BR> 0291 0292 <spacer size="20"><U>4.2.1. Column width</U><BR> 0293 <spacer size="30">In the view of an table block is for example the width of a column:<br> 0294 <spacer size="30"><B><I>View Column Widths: A:3 B:3 C:3 D:3 E:3 F:3 G:4 H:4</I></B><br> 0295 <BR> 0296 0297 <spacer size="20"><U>4.2.1. Row height</U><BR> 0298 <spacer size="30">or the height of a row<br> 0299 <spacer size="30"><B><I>View Row Heights: 3:18 4:24 8:32804 </I></B><br> 0300 <spacer size="30">Attention: If the row value is greater then 32768 you have to calc rowHeight = rowHeight - 32768 to get the right value! 0301 <br><br> 0302 0303 <spacer size="10"><U>4.3. Ending line</U><BR> 0304 <spacer size="20">The view of table <B>A</B> ends with this line:<BR> 0305 <spacer size="20"><B><I>View End, Name: ~A:~</I></B><BR> 0306 <br><br> 0307 0308 0309 <B><U>5. Headers and footers:</U></B><BR> 0310 <spacer size="10">The headers and footers section has 3 parts<BR> 0311 <spacer size="10">5.1. Starting line<BR> 0312 <spacer size="10">5.2. Value lines<BR> 0313 <spacer size="10">5.3. Ending line<BR> 0314 <BR> 0315 0316 <spacer size="10"><U>5.1. Starting line</U><BR> 0317 <spacer size="20">The headers and footers section begins with this line:<BR> 0318 <spacer size="20"><B><I>Headers And Footers</I></B><BR> 0319 <BR> 0320 0321 <spacer size="10"><U>5.2. Value lines</U><BR> 0322 <spacer size="20">-<BR> 0323 <spacer size="20">-<BR> 0324 <BR> 0325 0326 <spacer size="10"><U>5.3. Ending line</U><BR> 0327 <spacer size="20">The headers and footers section end with<BR> 0328 <spacer size="20"><B><I>Headers And Footers End</I></B><BR> 0329 <BR><BR> 0330 0331 0332 0333 <B><U>6. Cellvalue:</U></B><BR> 0334 <spacer size="10">This is a cellvalue line<BR> 0335 <spacer size="10"><B><I>('DN|B,I,U,TF1,P18|T4) A!D11: Hello everybody</I></B><BR> <BR> 0336 <spacer size="10">a cellvalue line has 3 parts:<BR> 0337 <spacer size="10">6.1. Formatpart<BR> 0338 <spacer size="10">6.2. Location part<BR> 0339 <spacer size="10">6.3. Text String, formular, value, link, etc.<BR> 0340 <BR> 0341 0342 0343 <spacer size="10"><U>6.1. Formatpart:</U><BR> 0344 <spacer size="20">The format part looks like that:<BR> 0345 <spacer size="20"><B>('DN|B,I,U,TF1,P18|T4)</B><BR> 0346 <spacer size="20">There are 3 formatsubparts divided by <B>|</B>:<BR> 0347 <spacer size="20"><B>(Part1|Part2|Part3)</B><BR> 0348 <spacer size="20">5.1.1. Part 1 - Alignment format<BR> 0349 <spacer size="20">5.1.2. Part 2 - Text format<BR> 0350 <spacer size="20">5.1.3. Part 3 - Cell format<BR> 0351 <BR> 0352 0353 0354 <spacer size="20"><U>6.1.1. Part 1 - Alignment format</U><BR> 0355 <spacer size="30">This is the alignment format for vertical, horizontal alignment<BR> 0356 <spacer size="30"> 0357 <TABLE CELLPADDING="0" BORDER="0"> 0358 <TR> 0359 <TD>6.1.1.1 </TD> 0360 <TD><B>1</B></TD> 0361 <TD>horizontal alignment</TD> 0362 <TD>left</TD> 0363 </TR> 0364 <TR> 0365 <TD>6.1.1.2 </TD> 0366 <TD><B>2</B></TD> 0367 <TD>horizontal alignment</TD> 0368 <TD>right</TD> 0369 </TR> 0370 <TR> 0371 <TD>6.1.1.3 </TD> 0372 <TD><B>3</B></TD> 0373 <TD>horizontal alignment</TD> 0374 <TD>center</TD> 0375 </TR> 0376 <TR> 0377 <TD>6.1.1.4 </TD> 0378 <TD><B>VT</B></TD> 0379 <TD>vertical alignment</TD> 0380 <TD>top</TD> 0381 </TR> 0382 <TR> 0383 <TD>6.1.1.5 </TD> 0384 <TD><B>VC</B></TD> 0385 <TD>vertical alignment</TD> 0386 <TD>center</TD> 0387 </TR> 0388 <TR> 0389 <TD>6.1.1.5 </TD> 0390 <TD><B>VB</B></TD> 0391 <TD>vertical alignment</TD> 0392 <TD>bottom</TD> 0393 </TR> 0394 <TR> 0395 <TD>6.1.1.6 </TD> 0396 <TD><B>DN</B></TD> 0397 <TD>??</TD> 0398 <TD>??</TD> 0399 </TR> 0400 </TABLE> 0401 <BR> 0402 0403 0404 <spacer size="20"><U>6.1.2. Part 2 - Text format</U><BR> 0405 <spacer size="30">This is the alignment format for the text<BR> 0406 <spacer size="30"> 0407 <TABLE CELLPADDING="0" BORDER="0"> 0408 <TR> 0409 <TD>6.1.2.1. </TD> 0410 <TD><B>B</B></TD> 0411 <TD>bold</TD> 0412 <TD>-</TD> 0413 </TR> 0414 <TR> 0415 <TD>6.1.2.2. </TD> 0416 <TD><B>I</B></TD> 0417 <TD>italic</TD> 0418 <TD>-</TD> 0419 </TR> 0420 <TR> 0421 <TD>6.1.2.3. </TD> 0422 <TD><B>U</B></TD> 0423 <TD>underline</TD> 0424 <TD>-</TD> 0425 </TR> 0426 <TR> 0427 <TD>6.1.2.4. </TD> 0428 <TD><B>TFx</B></TD> 0429 <TD>fontfamily</TD> 0430 <TD>x is the number in the fonttable.</TD> 0431 </TR> 0432 <TR> 0433 <TD>6.1.2.5. </TD> 0434 <TD><B>Px</B></TD> 0435 <TD>fontsize</TD> 0436 <TD>x is the fontsize.</TD> 0437 </TR> 0438 </TABLE> 0439 <BR> 0440 0441 0442 0443 <spacer size="20"><U>6.1.3. Part 3 - Cell format</U><BR> 0444 <spacer size="30">This is the alignment format for the text<BR> 0445 <spacer size="30"> 0446 <TABLE CELLPADDING="0" BORDER="0"> 0447 <TR> 0448 <TD>6.1.3.1. </TD> 0449 <TD><B>Txy</B></TD> 0450 <TD>Frame at the top</TD> 0451 </TR> 0452 <TR> 0453 <TD>6.1.3.2. </TD> 0454 <TD><B>Bxy</B></TD> 0455 <TD>Frame at the bottom</TD> 0456 </TR> 0457 <TR> 0458 <TD>6.1.3.3. </TD> 0459 <TD><B>Lxy</B></TD> 0460 <TD>Frame at the left side</TD> 0461 </TR> 0462 <TR> 0463 <TD>6.1.3.4. </TD> 0464 <TD><B>Rxy</B></TD> 0465 <TD>Frame at the right side</TD> 0466 </TR> 0467 </TABLE> 0468 <BR> 0469 0470 <spacer size="30">x = number describes the penwidth and penstyle of the frame line<BR> 0471 <spacer size="30"> 0472 <TABLE CELLPADDING="0" BORDER="1"> 0473 <TR> 0474 <TD ALIGN=CENTER colspan=2>applix</TD> 0475 <TD ALIGN=CENTER> </TD> 0476 <TD ALIGN=CENTER colspan=2> kspread</TD> 0477 </TR> 0478 <TR> 0479 <TD ALIGN=CENTER>number x</TD> 0480 <TD ALIGN=CENTER>info</TD> 0481 <TD ALIGN=CENTER> </TD> 0482 <TD ALIGN=CENTER>penwidth</TD> 0483 <TD ALIGN=CENTER>penstyle</TD> 0484 </TR> 0485 <TR> 0486 <TD>1</TD> 0487 <TD>-</TD> 0488 <TD> = </TD> 0489 <TD>1</TD> 0490 <TD>1</TD> 0491 </TR> 0492 <TR> 0493 <TD>2</TD> 0494 <TD>-</TD> 0495 <TD> = </TD> 0496 <TD>2</TD> 0497 <TD>1</TD> 0498 </TR> 0499 <TR> 0500 <TD>3</TD> 0501 <TD>-</TD> 0502 <TD> = </TD> 0503 <TD>3</TD> 0504 <TD>1</TD> 0505 </TR> 0506 <TR> 0507 <TD>4</TD> 0508 <TD>dashed</TD> 0509 <TD> = </TD> 0510 <TD>1</TD> 0511 <TD>3</TD> 0512 </TR> 0513 <TR> 0514 <TD>5</TD> 0515 <TD>double line</TD> 0516 <TD> = </TD> 0517 <TD>5</TD> 0518 <TD>1</TD> 0519 </TR> 0520 </TABLE> 0521 <BR> 0522 0523 0524 <spacer size="30">y = examples <B>FG7</B> <B>SH11FG18</B> <B>SH11FG18BG4</B><BR> 0525 <spacer size="30">it has max 3 Parts:<BR> 0526 <spacer size="30">6.1.3.4.1. Foreground color.<BR> 0527 <spacer size="30">6.1.3.4.2. Background shade type.<BR> 0528 <spacer size="30">6.1.3.4.3. Background color.<BR> 0529 <BR> 0530 0531 <spacer size="30"><U>6.1.3.4.1. Foreground color:</U><BR> 0532 <spacer size="40">FGx = Foreground color. - x is the number in the colortable<BR> 0533 <BR> 0534 0535 <spacer size="30"><U>6.1.3.4.2. Background shade type:</U><BR> 0536 <spacer size="40">SHx = Background shade type. x is the shadetypenumber<BR> 0537 <spacer size="40">Not all can be translate !<BR> 0538 <BR> 0539 <spacer size="40"> 0540 <TABLE CELLPADDING="0" BORDER="1"> 0541 <TR> 0542 <TD ALIGN=CENTER>applix</TD> 0543 <TD ALIGN=CENTER> </TD> 0544 <TD ALIGN=CENTER>kspread</TD> 0545 </TR> 0546 <TR> 0547 <TD ALIGN=CENTER>shadetype number </TD> 0548 <TD ALIGN=CENTER> </TD> 0549 <TD ALIGN=CENTER>shadetype number</TD> 0550 </TR> 0551 <TR> 0552 <TD>1</TD> 0553 <TD>=</TD> 0554 <TD>0</TD> 0555 </TR> 0556 <TR> 0557 <TD>2</TD> 0558 <TD>=</TD> 0559 <TD>7</TD> 0560 </TR> 0561 <TR> 0562 <TD>3</TD> 0563 <TD>=</TD> 0564 <TD>0</TD> 0565 </TR> 0566 <TR> 0567 <TD>4</TD> 0568 <TD>=</TD> 0569 <TD>4</TD> 0570 </TR> 0571 <TR> 0572 <TD>5</TD> 0573 <TD>=</TD> 0574 <TD>3</TD> 0575 </TR> 0576 <TR> 0577 <TD>6</TD> 0578 <TD>=</TD> 0579 <TD>2</TD> 0580 </TR> 0581 <TR> 0582 <TD>7</TD> 0583 <TD>=</TD> 0584 <TD>0</TD> 0585 </TR> 0586 <TR> 0587 <TD>8</TD> 0588 <TD>=</TD> 0589 <TD>0</TD> 0590 </TR> 0591 <TR> 0592 <TD>9</TD> 0593 <TD>=</TD> 0594 <TD>10</TD> 0595 </TR> 0596 <TR> 0597 <TD>10</TD> 0598 <TD>=</TD> 0599 <TD>9</TD> 0600 </TR> 0601 <TR> 0602 <TD>11</TD> 0603 <TD>=</TD> 0604 <TD>11</TD> 0605 </TR> 0606 <TR> 0607 <TD>12</TD> 0608 <TD>=</TD> 0609 <TD>12</TD> 0610 </TR> 0611 <TR> 0612 <TD>13</TD> 0613 <TD>=</TD> 0614 <TD>13</TD> 0615 </TR> 0616 <TR> 0617 <TD>14</TD> 0618 <TD>=</TD> 0619 <TD>14</TD> 0620 </TR> 0621 <TR> 0622 <TD>15</TD> 0623 <TD>=</TD> 0624 <TD>0</TD> 0625 </TR> 0626 <TR> 0627 <TD>16</TD> 0628 <TD>=</TD> 0629 <TD>0</TD> 0630 </TR> 0631 <TR> 0632 <TD>17</TD> 0633 <TD>=</TD> 0634 <TD>0</TD> 0635 </TR> 0636 <TR> 0637 <TD>18</TD> 0638 <TD>=</TD> 0639 <TD>0</TD> 0640 </TR> 0641 <TR> 0642 <TD>19</TD> 0643 <TD>=</TD> 0644 <TD>0</TD> 0645 </TR> 0646 </TABLE> 0647 <BR> 0648 0649 <spacer size="30"><U>6.1.3.4.3. Background color:</U> <BR> 0650 <spacer size="40">BGx = Background color. x is the number in the colortable<BR> 0651 <BR><BR> 0652 0653 0654 <spacer size="10"><U>6.2. Location part:</U> <BR> 0655 <spacer size="20">The location part looks like that:<BR> 0656 <spacer size="20"><B>A!D11:</B><BR> 0657 <spacer size="20">A = table <BR> 0658 <spacer size="20">D11 = cellnumber<BR> 0659 <spacer size="30">D = columnnumber<BR> 0660 <spacer size="30">11 = rownumber<BR> 0661 <spacer size="30">:=textstring, ;=formular, .=value<BR> 0662 <BR> 0663 0664 <spacer size="10"><U>6.3. Text String etc:</U><BR> 0665 <spacer size="20">The text string part looks like that:<BR> 0666 <spacer size="20"><B>Hello everybody</B><BR> 0667 <BR> 0668 0669 0670 0671 0672 0673 0674 <B><U>7. End</U></B><BR> 0675 The end looks like that:<BR> 0676 <B><I></I>*END SPREADSHEETS</B><BR> 0677 <BR><BR> 0678 0679 0680 </td> 0681 </tr> 0682 </table> 0683 </td> 0684 </tr> 0685 </table> 0686 </center> 0687 <A HREF="#START"><font size="-1"><b>Up</b></font></A> 0688 0689 <br><br><br> 0690 0691 <hr NOSHADE SIZE=1> 0692 <br><br><br> 0693 0694 0695 <center> 0696 <a NAME="export"></a> 0697 </center> 0698 0699 <A HREF="#START"><font size="-1"><b>Up</b></font></A> 0700 <center> 0701 <table BORDER=0 CELLSPACING=0 BGCOLOR="#000000" WIDTH="100%"> 0702 <tr> 0703 <td> 0704 <table BORDER=0 CELLPADDING=2 BGCOLOR="#FFFFFF" WIDTH="100%"> 0705 <tr BGCOLOR="#FFDDDD"> 0706 <td COLSPAN="2"> 0707 <center><b><i><font size="+1"> 0708 <BR>Export kspread to Applix Spreadsheet<BR><BR> 0709 </font></i></b></center> 0710 </td> 0711 </tr> 0712 0713 <tr BGCOLOR="#EEEEFF"> 0714 <td VALIGN=TOP WIDTH="1%" NOWRAP><b><font size="+1">Last update</font></b></td> 0715 <td>-</td> 0716 </tr> 0717 0718 <tr BGCOLOR="#CCCCFF"> 0719 <td VALIGN=TOP><b><font size="+1">Features</font></b></td> 0720 <td>None</td> 0721 </tr> 0722 0723 <tr BGCOLOR="#EEEEFF"> 0724 <td VALIGN=TOP><b><font size="+1">Todo</font></b></td> 0725 <td>Everything</td> 0726 </tr> 0727 0728 <tr BGCOLOR="#CCCCFF"> 0729 <td VALIGN=TOP><b><font size="+1">History</font></b></td> 0730 <td>-</td> 0731 </tr> 0732 0733 <tr BGCOLOR="#EEEEFF"> 0734 <td VALIGN=TOP><b><font size="+1">Authors</font></b></td> 0735 <td><!a href="mailto:null@kde.org">-</a></td> 0736 </tr> 0737 0738 <tr BGCOLOR="#CCCCFF"> 0739 <td VALIGN=TOP><b><font size="+1">Links</font></b></td> 0740 <td><!a href="http://www.calligra.org">-</a></td> 0741 </tr> 0742 0743 <tr BGCOLOR="#EEEEFF"> 0744 <td VALIGN=TOP><b><font size="+1">Progress report </font></b></td> 0745 <td>---</td> 0746 </tr> 0747 </table> 0748 </td> 0749 </tr> 0750 </table> 0751 </center> 0752 <A HREF="#START"><font size="-1"><b>Up</b></font></A> 0753 0754 </body> 0755 </html>