Open Office ansprechen

Objektorientierte Programmiersprache auf Basis einer virtuellen Maschine (https://www.oracle.com/java/)
Antworten
dragonfight86
Beiträge: 15
Registriert: So Feb 28, 2016 6:17 pm

Open Office ansprechen

Beitrag von dragonfight86 » Do Mai 04, 2017 8:12 am

Beispiel.odt
Hallo zusammen,

ich muss aus einer OpenOffice Textdatei mit verknüpfter Tabelle Daten holen und in einer Datenbank speichern /Beispieldatei ist angehängt

Ehrlich gesagt habe ich keine Ahnung wie ich diese .odt ansprechen soll und Zugriff auf die Daten bekomme.

Hintergrund:
Betriebssystem Linux und Windows daher Umsetzung mit Java.
Ziel ist das einmalige einlesen und danach speichern in der Datenbank von bereits erstellten Rechnungen die im selben Format Vorliegen, siehe Beispieldatei.

Was ich bisher habe ist folgender stümperhafter Code

Code: Alles auswählen

 public static void main(String[] args) throws FileNotFoundException 
    {
        String r = "C:\\Users\\ca.martinez\\Desktop\\Projektwoche 2\\Neuer Ordner\\089 Karjalainen GR.odt";
        
               
        try
        {              
            TextDocument t;
        
            JTable Tabelle;
                    
            FileReader read = new FileReader(r);
            BufferedReader buff = new BufferedReader(read);
            
            while(read.ready())
            {
                System.out.println(buff.readLine());
            }
        }
        catch(IOException ex)
        {          
        }
    }
Ich hoffe das mir jemand helfen kann bzw. mir einen Tip geben kann wonach ich suchen muss ich habe absolut keine Ahnung.

Edit bei Xin: Dem Titel ein 'f' geklaut, damit man ihn 'googlen' kann.
Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.

Benutzeravatar
Xin
nur zu Besuch hier
Beiträge: 8721
Registriert: Fr Jul 04, 2008 11:10 pm
Wohnort: /home/xin
Kontaktdaten:

Re: Opfen Office ansprechen

Beitrag von Xin » Do Mai 04, 2017 12:50 pm

Ohne wirklich Ahnung von OpenOffice zu haben, stellt sich für mich als erstes die Frage, wie OpenOffice eigentlich das ODT-Format liest und schreibt.
Entsprechend würde ich auf die Suche nach den DLLs gehen (bzw. .class-Dateien), die das können.

Ich stelle mir vor, dass man mit der entsprechenden Library/Class anschließend die Datei öffnet und sich darin ähnlich wie in einem HTML-Dokument bewegen kann. Das weiß ich nicht - das ist einfach nur mal das, was ich erwarten würde, dass an Möglichkeiten existiert und entsprechend würde ich danach zunächst suchen.

Dafür würde ich mir zum einen einen den Quelltext von OpenOffice suchen und die Entwickler-Dokumentation.
Passende Schlüsselwörter bei Google führen mich hierhin: OpenOffice.org_Developers_Guide

Hilft das erstmal weiter zu kommen?
Merke: Wer Ordnung hellt ist nicht zwangsläufig eine Leuchte.

Ich beantworte keine generellen Programmierfragen per PN oder Mail. Dafür ist das Forum da.

dragonfight86
Beiträge: 15
Registriert: So Feb 28, 2016 6:17 pm

Re: Opfen Office ansprechen

Beitrag von dragonfight86 » Di Mai 09, 2017 7:27 am

Hallo Xin,

das hat mir erstmal weitergeholfen.

Also OpenOffice nutzt Archive so das ich mit ZipFile das Dokument entpackt habe.
Meine Daten liegen also in der content.xml und mit dem SAXbuilder kann ich die xml einlesen.
Des Weiteren habe ich mir die Struktur in eine Liste gepackt aber hier stecke ich fest. Ich sehe zwar alle Parent und Child Elemente aber kann diese nicht ansprechen.

Code: Alles auswählen

public String getText(String fileName) throws Exception {
        TextBuffer = new StringBuffer();
        
        //Unzip the openOffice Document
        ZipFile zipFile = new ZipFile(fileName);
        Enumeration entries = zipFile.entries();
        ZipEntry entry;
        
        while(entries.hasMoreElements()) {
            entry = (ZipEntry) entries.nextElement();
                            
            if (entry.getName().equals("Object 1/content.xml")) {
                
                TextBuffer = new StringBuffer();                
                SAXBuilder sax = new SAXBuilder();
                Document doc = sax.build(zipFile.getInputStream(entry));
                Element rootElement = doc.getRootElement();
                Element e = rootElement.getChild("body");  
Du hast keine ausreichende Berechtigung, um die Dateianhänge dieses Beitrags anzusehen.

Benutzeravatar
Xin
nur zu Besuch hier
Beiträge: 8721
Registriert: Fr Jul 04, 2008 11:10 pm
Wohnort: /home/xin
Kontaktdaten:

Re: Opfen Office ansprechen

Beitrag von Xin » Di Mai 09, 2017 8:40 am

dragonfight86 hat geschrieben:Ich sehe zwar alle Parent und Child Elemente aber kann diese nicht ansprechen.
...weil...?


"Es tut's nicht" ist keine brauchbare Fehlerbeschreibung... ;)
Merke: Wer Ordnung hellt ist nicht zwangsläufig eine Leuchte.

Ich beantworte keine generellen Programmierfragen per PN oder Mail. Dafür ist das Forum da.

dragonfight86
Beiträge: 15
Registriert: So Feb 28, 2016 6:17 pm

Re: Open Office ansprechen

Beitrag von dragonfight86 » Di Mai 09, 2017 10:14 am

Ich denke das ich rootElement.getChild("body"); falsch anspreche wobei laut Dokumentation public Element getChild(String cname) korrekt wäre doch bleibt die variable e null :(

Benutzeravatar
Xin
nur zu Besuch hier
Beiträge: 8721
Registriert: Fr Jul 04, 2008 11:10 pm
Wohnort: /home/xin
Kontaktdaten:

Re: Open Office ansprechen

Beitrag von Xin » Di Mai 09, 2017 10:41 am

Wie funktioniert getChild() denn? Greift es nur auf die Kinder zu oder auch auf die Enkel?
Hängt "Body" denn überhaupt unter rootElement?
Merke: Wer Ordnung hellt ist nicht zwangsläufig eine Leuchte.

Ich beantworte keine generellen Programmierfragen per PN oder Mail. Dafür ist das Forum da.

dragonfight86
Beiträge: 15
Registriert: So Feb 28, 2016 6:17 pm

Re: Open Office ansprechen

Beitrag von dragonfight86 » Mi Mai 10, 2017 11:52 am

Soweit ich das verstehe greift child auf das nächst mögliche zu, also eine ebene.

Die ebenen in eine liste zu packen das funktioniert (list children) doch das zugreifen leider nicht.

Soweit ich das verstehe ist body ein child von office

// office:body

Code: Alles auswählen

<?xml version="1.0" encoding="UTF-8"?>

-<office:document-content office:version="1.2" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:rpt="http://openoffice.org/2005/report" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:ooo="http://openoffice.org/2004/office" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0">

<office:scripts/>


-<office:font-face-decls>

<style:font-face style:font-pitch="variable" style:font-family-generic="roman" svg:font-family="'Times New Roman'" style:name="Times New Roman"/>

<style:font-face style:font-pitch="variable" style:font-family-generic="swiss" svg:font-family="Arial" style:name="Arial"/>

<style:font-face style:font-pitch="variable" style:font-family-generic="swiss" svg:font-family="'Liberation Sans'" style:name="Liberation Sans"/>

<style:font-face style:font-pitch="variable" style:font-family-generic="system" svg:font-family="'Arial Unicode MS'" style:name="Arial Unicode MS"/>

<style:font-face style:font-pitch="variable" style:font-family-generic="system" svg:font-family="'DejaVu Sans'" style:name="DejaVu Sans"/>

<style:font-face style:font-pitch="variable" style:font-family-generic="system" svg:font-family="Tahoma" style:name="Tahoma"/>

</office:font-face-decls>


-<office:automatic-styles>


-<style:style style:name="co1" style:family="table-column">

<style:table-column-properties style:column-width="1.236cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="co2" style:family="table-column">

<style:table-column-properties style:column-width="2.267cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="co3" style:family="table-column">

<style:table-column-properties style:column-width="3.829cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="co4" style:family="table-column">

<style:table-column-properties style:column-width="1.748cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="co5" style:family="table-column">

<style:table-column-properties style:column-width="2.552cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="co6" style:family="table-column">

<style:table-column-properties style:column-width="2.912cm" fo:break-before="auto"/>

</style:style>


-<style:style style:name="ro1" style:family="table-row">

<style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true" style:row-height="0.453cm"/>

</style:style>


-<style:style style:name="ro2" style:family="table-row">

<style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true" style:row-height="0.538cm"/>

</style:style>


-<style:style style:name="ro3" style:family="table-row">

<style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true" style:row-height="0.707cm"/>

</style:style>


-<style:style style:name="ro4" style:family="table-row">

<style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true" style:row-height="0.58cm"/>

</style:style>


-<style:style style:name="ro5" style:family="table-row">

<style:table-row-properties fo:break-before="auto" style:use-optimal-row-height="true" style:row-height="0.623cm"/>

</style:style>


-<style:style style:name="ta1" style:family="table" style:master-page-name="Default">

<style:table-properties style:writing-mode="lr-tb" table:display="true"/>

</style:style>


-<number:percentage-style style:name="N11">

<number:number number:min-integer-digits="1" number:decimal-places="2"/>

<number:text>%</number:text>

</number:percentage-style>


-<number:date-style style:name="N36" number:automatic-order="true">

<number:day number:style="long"/>

<number:text>.</number:text>

<number:month number:style="long"/>

<number:text>.</number:text>

<number:year number:style="long"/>

</number:date-style>


-<style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="8pt" style:font-weight-asian="bold" style:font-size-asian="8pt" fo:font-weight="bold" style:text-underline-color="font-color" style:text-underline-width="auto" style:text-underline-style="solid" fo:font-size="8pt"/>

</style:style>


-<style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt"/>

</style:style>


-<style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="16pt" style:font-weight-asian="bold" style:font-size-asian="16pt" fo:font-weight="bold" style:text-underline-color="font-color" style:text-underline-width="auto" style:text-underline-style="solid" fo:font-size="16pt"/>

</style:style>


-<style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="12pt" style:font-weight-asian="bold" style:font-size-asian="12pt" fo:font-weight="bold" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="13pt" style:font-weight-asian="bold" style:font-size-asian="13pt" fo:font-weight="bold" fo:font-size="13pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="none"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman" fo:color="#ff0000"/>

</style:style>


-<style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="14pt" style:font-weight-asian="bold" style:font-size-asian="14pt" fo:font-weight="bold" fo:font-size="14pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border="none"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border="none"/>

<style:text-properties style:font-size-complex="10.5pt" style:font-size-asian="10.5pt" fo:font-size="10.5pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="13pt" style:font-weight-asian="bold" style:font-size-asian="13pt" fo:font-weight="bold" fo:font-size="13pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="none"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

</style:style>


-<style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt"/>

</style:style>


-<style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N108">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="none"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman" fo:color="#000000"/>

</style:style>


-<style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N108">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="none"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N108">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="value-type"/>

<style:paragraph-properties fo:margin-left="0cm"/>

</style:style>


-<style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="value-type"/>

<style:paragraph-properties fo:margin-left="0cm"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt"/>

</style:style>


-<style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="value-type"/>

<style:paragraph-properties fo:margin-left="0cm"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="12pt" style:font-weight-asian="bold" style:font-size-asian="12pt" fo:font-weight="bold" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="value-type"/>

<style:paragraph-properties fo:margin-left="0cm"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="11pt" style:font-weight-asian="bold" style:font-size-asian="11pt" fo:font-weight="bold" fo:font-size="11pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="end"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="end"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="13pt" style:font-weight-asian="bold" style:font-size-asian="13pt" fo:font-weight="bold" fo:font-size="13pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="none"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="none" fo:border-right="0.002cm solid #000000" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="start"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="12pt" style:font-weight-asian="bold" style:font-size-asian="12pt" fo:font-weight="bold" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="start"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="12pt" style:font-weight-asian="bold" style:font-size-asian="12pt" fo:font-weight="bold" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default">

<style:table-cell-properties style:repeat-content="false" style:text-align-source="fix" fo:border-top="none" fo:border-right="none" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:paragraph-properties fo:margin-left="0cm" fo:text-align="center"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="13pt" style:font-weight-asian="bold" style:font-size-asian="13pt" fo:font-weight="bold" fo:font-size="13pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce36" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="none" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="0.002cm solid #000000" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N11">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="0.002cm solid #000000" fo:border-bottom="none"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="0.002cm solid #000000" fo:border-right="none" fo:border-left="0.002cm solid #000000" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-size-complex="12pt" style:font-size-asian="12pt" fo:font-size="12pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107">

<style:table-cell-properties fo:border-top="none" fo:border-right="none" fo:border-left="0.002cm solid #000000" fo:border-bottom="0.002cm solid #000000"/>

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="14pt" style:font-weight-asian="bold" style:font-size-asian="14pt" fo:font-weight="bold" fo:font-size="14pt" style:font-name="Times New Roman"/>

</style:style>


-<style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36">

<style:text-properties style:font-weight-complex="bold" style:font-size-complex="12pt" style:font-weight-asian="bold" style:font-size-asian="12pt" fo:font-weight="bold" fo:font-size="12pt" style:font-name="Times New Roman" fo:color="#ff0000"/>

</style:style>

</office:automatic-styles>


-<office:body>


-<office:spreadsheet>


-<table:table table:name="Tabelle1" table:style-name="ta1">

<table:table-column table:style-name="co1" table:default-cell-style-name="ce7"/>

<table:table-column table:style-name="co2" table:default-cell-style-name="ce11"/>

<table:table-column table:style-name="co3" table:default-cell-style-name="ce15"/>

<table:table-column table:style-name="co4" table:default-cell-style-name="ce21"/>

<table:table-column table:style-name="co5" table:default-cell-style-name="ce7"/>

<table:table-column table:style-name="co2" table:default-cell-style-name="ce30"/>

<table:table-column table:style-name="co6" table:default-cell-style-name="ce35"/>


-<table:table-row table:style-name="ro1" table:number-rows-repeated="5">

<table:table-cell table:style-name="Default" table:number-columns-repeated="7"/>

</table:table-row>


-<table:table-row table:style-name="ro1">


-<table:table-cell table:style-name="ce1" office:value-type="string">

<text:p>SPK-Gebäudereinigung Wolz ; Coloniaallee 19 ; 12524 Berlin</text:p>

</table:table-cell>

<table:table-cell table:style-name="Default" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce17"/>

<table:table-cell table:style-name="ce23"/>

<table:table-cell table:style-name="Default" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro1">

<table:table-cell table:style-name="Default" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce17"/>

<table:table-cell table:style-name="ce23"/>

<table:table-cell table:style-name="Default" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce2" office:value-type="string">

<text:p>Anrede</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce2" office:value-type="string">

<text:p>Name</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce2" office:value-type="string">

<text:p>Straße</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce2" office:value-type="string">

<text:p>PLZ Ort</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2" table:number-rows-repeated="2">

<table:table-cell table:style-name="ce2" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro3">


-<table:table-cell table:style-name="ce3" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="7">

<text:p>RECHNUNG</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:covered-table-cell table:style-name="ce18"/>

<table:covered-table-cell table:style-name="ce24"/>

<table:covered-table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro3">

<table:table-cell table:style-name="ce3"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce18"/>

<table:table-cell table:style-name="ce24"/>

<table:table-cell table:style-name="ce2" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro1">

<table:table-cell table:style-name="Default" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce17"/>

<table:table-cell table:style-name="ce23"/>

<table:table-cell table:style-name="Default" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce4" office:value-type="string">

<text:p>Über:</text:p>

</table:table-cell>


-<table:table-cell table:style-name="ce5" office:value-type="string">

<text:p>Reinigung</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce5"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce25" office:value-type="string">

<text:p>Datum:</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce5"/>


-<table:table-cell table:style-name="ce32" office:value-type="date" office:date-value="2017-03-30">

<text:p>30.03.2017</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce25" office:value-type="string">

<text:p>Rechnungsnummer:</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce5"/>


-<table:table-cell table:style-name="ce33" office:value-type="float" office:value="333333">

<text:p>333333</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2" table:number-rows-repeated="2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>

<table:table-cell table:style-name="ce26"/>

<table:table-cell table:style-name="ce5" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro4">


-<table:table-cell table:style-name="ce6" office:value-type="string">

<text:p>Pos.</text:p>

</table:table-cell>


-<table:table-cell table:style-name="ce6" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="2">

<text:p>Beschreibung</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce14"/>


-<table:table-cell table:style-name="ce6" office:value-type="string">

<text:p>Anzahl</text:p>

</table:table-cell>


-<table:table-cell table:style-name="ce27" office:value-type="string">

<text:p>Bezugsgröße</text:p>

</table:table-cell>


-<table:table-cell table:style-name="ce6" office:value-type="string">

<text:p>Satz</text:p>

</table:table-cell>


-<table:table-cell table:style-name="ce34" office:value-type="string">

<text:p>Betrag</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell office:value-type="float" office:value="1">

<text:p>1</text:p>

</table:table-cell>


-<table:table-cell office:value-type="string">

<text:p>Reinigung</text:p>

</table:table-cell>

<table:table-cell/>


-<table:table-cell table:style-name="ce20" office:value-type="float" office:value="1">

<text:p>1,00</text:p>

</table:table-cell>


-<table:table-cell office:value-type="string">

<text:p>Reinigung</text:p>

</table:table-cell>


-<table:table-cell table:number-columns-repeated="2" office:value-type="currency" office:value="0" office:currency="EUR">

<text:p>0,00 €</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell/>


-<table:table-cell table:style-name="ce12" office:value-type="string">

<text:p>(Fenster in Kinderzimmern,</text:p>

</table:table-cell>

<table:table-cell table:number-columns-repeated="5"/>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell/>


-<table:table-cell table:style-name="ce12" office:value-type="string">

<text:p>Wohnzimmer, Küche)</text:p>

</table:table-cell>

<table:table-cell table:number-columns-repeated="5"/>

</table:table-row>


-<table:table-row table:style-name="ro2" table:number-rows-repeated="11">

<table:table-cell table:number-columns-repeated="7"/>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce8"/>

<table:table-cell table:style-name="ce13"/>

<table:table-cell table:style-name="ce16"/>

<table:table-cell table:style-name="ce22"/>

<table:table-cell table:style-name="ce8"/>

<table:table-cell table:style-name="ce31"/>

<table:table-cell table:style-name="ce36"/>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5"/>

<table:table-cell/>

<table:table-cell table:style-name="ce5"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce28" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="2">

<text:p>Zwischensumme</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce28"/>


-<table:table-cell table:style-name="ce37" office:value-type="currency" office:value="0" office:currency="EUR" table:formula="of:=SUM([.G22:.G36])">

<text:p>0,00 €</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce28" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="2">

<text:p>Mehrwertstuersatz</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce28"/>


-<table:table-cell table:style-name="ce38" office:value-type="percentage" office:value="0.19">

<text:p>19,00%</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce28" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="2">

<text:p>Mehrwertsteuer</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce28"/>


-<table:table-cell table:style-name="ce39" office:value-type="currency" office:value="0" office:currency="EUR" table:formula="of:=[.G40]-[.G37]">

<text:p>0,00 €</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro5">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>


-<table:table-cell table:style-name="ce29" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="2">

<text:p>Rechnungsbetrag</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce28"/>


-<table:table-cell table:style-name="ce40" office:value-type="currency" office:value="0" office:currency="EUR" table:formula="of:=[.G37]*1.19">

<text:p>0,00 €</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>

<table:table-cell table:style-name="ce26"/>

<table:table-cell table:style-name="ce28"/>

<table:table-cell table:style-name="ce5"/>

</table:table-row>


-<table:table-row table:style-name="ro2">


-<table:table-cell table:style-name="ce9" office:value-type="string">

<text:p>Überweisen Sie den Rechnungsbetrag, auf das angegebene Konto, bitte bis:</text:p>

</table:table-cell>

<table:table-cell table:style-name="ce5" table:number-columns-repeated="2"/>

<table:table-cell table:style-name="ce19"/>

<table:table-cell table:style-name="ce26"/>

<table:table-cell table:style-name="ce5"/>


-<table:table-cell table:style-name="ce41" office:value-type="date" office:date-value="2017-04-07" table:formula="of:=[.G17]+7+1">

<text:p>07.04.2017</text:p>

</table:table-cell>

</table:table-row>


-<table:table-row table:style-name="ro2">

<table:table-cell table:style-name="ce5" table:number-columns-repeated="3"/>

<table:table-cell table:style-name="ce19"/>

<table:table-cell table:style-name="ce26"/>

<table:table-cell table:style-name="ce5" table:number-columns-repeated="2"/>

</table:table-row>


-<table:table-row table:style-name="ro5">


-<table:table-cell table:style-name="ce10" office:value-type="string" table:number-rows-spanned="1" table:number-columns-spanned="7">

<text:p>Vielen Dank für Ihren Auftrag !</text:p>

</table:table-cell>

<table:covered-table-cell table:style-name="ce5" table:number-columns-repeated="2"/>

<table:covered-table-cell table:style-name="ce19"/>

<table:covered-table-cell table:style-name="ce26"/>

<table:covered-table-cell table:style-name="ce5" table:number-columns-repeated="2"/>

</table:table-row>

</table:table>

</office:spreadsheet>

</office:body>

</office:document-content>

Benutzeravatar
Xin
nur zu Besuch hier
Beiträge: 8721
Registriert: Fr Jul 04, 2008 11:10 pm
Wohnort: /home/xin
Kontaktdaten:

Re: Open Office ansprechen

Beitrag von Xin » Mi Mai 10, 2017 12:23 pm

Das Ding heißt "office:body". Body kann es also mehrfach geben, Du suchst offenbar den "body" im Namensraum "office".
body ist hier kein Child von Office, sondern das ist der vollständige Name: "office:body" des Kindes. Man kann das wie Vorname (Body) und Nachname (Office) verstehen: Wenn ich "Christian" rufe, melden sich viele, ich suche aber einen aus einem speziellen Namensraum - eben dem Familiennamen. Also hänge muss ich den auch erwähnen.

Ich gehe also davon aus, dass Du auch nach "office:body" fragen musst.
Merke: Wer Ordnung hellt ist nicht zwangsläufig eine Leuchte.

Ich beantworte keine generellen Programmierfragen per PN oder Mail. Dafür ist das Forum da.

Antworten