Libre Office

Problem mit dem html/xhtml Export aus Calc

CALC ist die Tabellenkalkulation, die Sie immer wollten.
Antworten
Benutzeravatar
Muckel
Beiträge: 36
Registriert: Mi 15. Jun 2011, 15:33
Wohnort: Braunschweig
Kontaktdaten:
Kontaktdaten von Muckel

Problem mit dem html/xhtml Export aus Calc

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
Nach oben
Benutzeravatar
karolus
* LO-Experte *
Beiträge: 2721
Registriert: Fr 10. Dez 2010, 10:01

Re: Problem mit dem html/xhtml Export aus Calc

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
LO25.2.x.y debian 13(trixie) auf Raspberry5 8GB (64bit)
LO25.8.x.y flatpak debian 13(trixie) auf Raspberry5 8GB (64bit)
Nach oben
Open Office
Antworten

Zurück zu „LibreOffice Calc“