Problem mit dem html/xhtml Export aus Calc

Muckel · Beitrag von **Muckel** » Mi 15. Jun 2011, 16:44

Guten Tag zusammen,

mit LibreOffice Calc habe ich eine Tabelle erzeugt, in der ich am Anfang nur Blutwerte und deren Einheiten vergleichen möchte, später soll in einem zweiten Tabellen-Blatt die Werte gesammelt werden.

Um die Werte zu Vergleichen und diese Übersicht mit anderen zu teilen, wollte ich sie gerne online stellen, wozu ich eben eine HTML-Tabelle benötige. Der Export von Calc ist ziemlich aufgebläht:

Code: Alles auswählen

<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://dublincore.org/documents/dcmi-terms/">
<!--This file was converted to xhtml by OpenOffice.org - see http://xml.openoffice.org/odf2xhtml for more info.-->
<meta http-equiv="Content-Type"
content="application/xhtml+xml; charset=utf-8" />
<title xml:lang="en-US">- no title specified</title>
<meta name="DCTERMS.title" content="" xml:lang="en-US" />
<meta name="DCTERMS.language" content="en-US" scheme="DCTERMS.RFC4646" />
<meta name="DCTERMS.source"
content="http://xml.openoffice.org/odf2xhtml" />
<meta name="DCTERMS.creator" content="Tobias Müller" />
<meta name="DCTERMS.issued" content="2011-06-15T11:11:38"
scheme="DCTERMS.W3CDTF" />
<meta name="DCTERMS.contributor" content="Tobias Müller" />
<meta name="DCTERMS.modified" content="2011-06-15T15:44:00"
scheme="DCTERMS.W3CDTF" />
<meta name="DCTERMS.provenance" content="" xml:lang="en-US" />
<meta name="DCTERMS.subject" content="," xml:lang="en-US" />
<link rel="schema.DC" href="http://purl.org/dc/elements/1.1/"
hreflang="en" />
<link rel="schema.DCTERMS" href="http://purl.org/dc/terms/"
hreflang="en" />
<link rel="schema.DCTYPE" href="http://purl.org/dc/dcmitype/"
hreflang="en" />
<link rel="schema.DCAM" href="http://purl.org/dc/dcam/" hreflang="en" />
<base href="." />
<style type="text/css">
@page { }
table { border-collapse:collapse; border-spacing:0; empty-cells:show }
td, th { vertical-align:top; font-size:10pt;}
h1, h2, h3, h4, h5, h6 { clear:both }
ol, ul { margin:0; padding:0;}
li { list-style: none; margin:0; padding:0;}
<!-- "li span.odfLiEnd" - IE 7 issue-->
li span. { clear: both; line-height:0; width:0; height:0; margin:0; padding:0; }
span.footnodeNumber { padding-right:1em; }
span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000; margin:0; border:0; padding:0; }
* { margin:0;}
.ta1 { writing-mode:lr-tb; }
.Default { font-family:Arial; font-size:12pt; }
.ce10 { font-size:12pt; font-family:Arial; vertical-align:middle; text-align:center ! important; }
.ce11 { font-size:12pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce12 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce13 { font-size:12pt; font-family:Arial; }
.ce14 { font-size:10pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce15 { font-size:10pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:normal; }
.ce16 { font-size:10pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:left ! important; font-weight:normal; }
.ce17 { font-size:10pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce18 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce19 { font-size:20pt; font-family:Arial; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.ce20 { font-size:12pt; font-family:Arial; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; }
.ce21 { font-size:12pt; font-family:Georgia; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; }
.ce22 { font-size:12pt; font-family:Arial; border-style:none; vertical-align:middle; text-align:center ! important; }
.ce23 { font-size:12pt; font-family:Arial; }
.ce24 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.ce25 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce26 { font-size:10pt; font-family:Georgia; background-color:transparent; border-style:none; vertical-align:middle; text-align:center ! important; font-weight:normal; }
.ce3 { font-size:20pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce4 { font-size:14pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:bold; }
.ce5 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:left ! important; font-weight:bold; }
.ce6 { font-size:12pt; font-family:Arial; vertical-align:middle; text-align:left ! important; }
.ce7 { font-size:12pt; font-family:Georgia; background-color:transparent; vertical-align:middle; text-align:left ! important; font-weight:bold; }
.ce8 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; text-decoration:none ! important; font-weight:normal; }
.ce9 { font-size:12pt; font-family:Georgia; background-color:transparent; border-width:0.018cm; border-style:solid; border-color:#000000; padding:0.049cm; vertical-align:middle; text-align:center ! important; font-weight:bold; }
.co2 { width:5.001cm; }
.co3 { width:2.499cm; }
.co4 { width:4.001cm; }
.co5 { width:2.267cm; }
.co6 { width:3cm; }
.ro2 { height:0.536cm; }
.ro3 { height:1.499cm; }
.T1 { font-weight:normal; }
<!-- ODF styles with no properties representable as CSS -->
{ }
</style>
</head>
<body dir="ltr" style="margin: 1cm; max-width: 42cm;">
<table class="ta1" border="0" cellpadding="0" cellspacing="0">
<colgroup><col width="219" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="109" /><col width="109" /><col
width="109" /><col width="109" /><col width="219" /><col width="175" /><col
width="131" /><col width="131" /><col width="131" /><col width="131" /><col
width="131" /><col width="99" /><col width="99" /><col width="99" /><col
width="99" /></colgroup><tbody>
<tr class="ro3">
<td colspan="2" style="text-align: left; width: 5.001cm;"
class="ce3">
<p>Laborwerte</p>
</td>
<td colspan="2" rowspan="2"
style="text-align: left; width: 2.499cm;" class="ce3">
<p>Einheiten aus Berichten</p>
</td>
<td colspan="4" style="text-align: left; width: 2.499cm;"
class="ce3">
<p>Einheiten aus dem Buch</p>
</td>
<td colspan="2" rowspan="2"
style="text-align: left; width: 2.499cm;" class="ce3">
<p>Normal-werte aus Berichten</p>
</td>
<td colspan="3" style="text-align: left; width: 2.499cm;"
class="ce3">
<p>Normalwerte aus dem Buch</p>
</td>
<td rowspan="2" style="text-align: left; width: 5.001cm;"
class="ce19">
<p>Notizen</p>
</td>
<td style="text-align: left; width: 4.001cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce4">
<p>Name</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Kürzel</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alte</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alt in Neu</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neue</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neu in Alt</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alter</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Alt in Neu</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce4">
<p>Neuer</p>
</td>
<td style="text-align: left; width: 4.001cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce22">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce26">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">
<p>ACE</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>U/l</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
<!-- Hier waere mehr Inhalt... -->
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">
<p>TSH</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>mU/l</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>mcU/ml</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">
<p>0,4-4,0</p>
</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
<tr class="ro3">
<td style="text-align: left; width: 5.001cm;" class="ce5">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce9">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 2.499cm;" class="ce12">&nbsp;</td>
<td style="text-align: left; width: 5.001cm;" class="ce21">&nbsp;</td>
<td style="text-align: left; width: 4.001cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 3cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce14">&nbsp;</td>
<td style="text-align: left; width: 2.267cm;" class="ce23">&nbsp;</td>
</tr>
</tbody>
</table>

Doch ich bevorzuge dies schlankere, reine xhtml-Tabelle:

Code: Alles auswählen

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="author" content="Tobias M&uuml;ller">
	<meta name="description" content="&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten um sie Vergleichen und umrechnen zu k&ouml;nnen.">
	<meta name="keywords" lang="de" content="Labor,Laborwerte,Blut,Blutbild,Entzuendungswete">
	<meta http-equiv="content-language" content="de">
	<meta name="robots" content="all">
	<title>&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten</title>
	<!-- Style-Sheet Anfang -->
		<!-- <link href="style.css" rel="stylesheet" type="text/css" /> -->
	<!-- Style Sheet Ende -->
</head>
<body>
<h1>&Uuml;bersicht der Laborwerte mit den Einheiten und Normalwerten</h1>
<p>Evtl. etwas Text...</p>
<table border="1" cellpadding="1" cellspacing="1" style="margin:0.5em;">
  <thead>
   <tr>
    <th colspan="2">Laborwerte</th>
    <th colspan="2" rowspan="2">Einheiten aus Berichten</th>
    <th colspan="4">Einheiten aus dem Buch</th>
    <th colspan="2">Normalwerte aus Berichten</th>
    <th colspan="3">Normalwerte aus dem Buch</th>
    <th rowspan="2">Notizen</th>
  </tr>
  <tr>
    <th>Name</th>
    <th>K&uuml;rzel</th>
    <th>Alte</th>
    <th>Alt in Neu</th>
    <th>Neue</th>
    <th>Neu in Alt</th>
    <th>Variante 1</th>
    <th>Variante 2</th>
    <th>Alter</th>
    <th>Alt in Neu</th>
    <th>Neuer</th>
  </tr>
  </thead> <tbody>
    <tr>
      <td>ACE</td>
      <td>&nbsp;</td>
      <td>U/l</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;8</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
    <td>Albumine</td>
    <td>&nbsp;</td>
    <td>%</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>55,8-66,1</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>alk. Phosph</td>
    <td>&nbsp;</td>
    <td>U/l</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>40-130</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
<!-- Hier waere noch mehr Inhalt -->
  <tr>
    <td>x</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</tbody>
<tfoot>
  <tr>
    <td colspan="14" align="center"><small>Diese Liste wurde von Tobias zusammengestellt und wird zur Zeit noch ergänzt.</small></td>
  </tr>
</tfoot>
</table>
<p>Evtl. nochmal Text...</p>
</body>
</html>

Hoffe ihr könnt mir einen Tipp geben, wie sich das anstellen lässt!

Lieben Gruß Tobias

karolus · Beitrag von **karolus** » Fr 17. Jun 2011, 09:50

Hallo

Ich würde den Original-Html-Export aus Calc wegwerfen, und stattdessen dein xhtml_template per Script mit den Daten aus der Tabelle "befüllen".

Gruß Karo

LibreOffice-Forum

Problem mit dem html/xhtml Export aus Calc

Problem mit dem html/xhtml Export aus Calc

Re: Problem mit dem html/xhtml Export aus Calc

An alle, die das LibreOffice-Forum gern nutzen und unterstützen wollen: