[Opgelost] Programmacode OpenOfficedocument oproepen?

[Pattattezak]

Dit is eigenlijk het logische vervolg op dit draadje. Door gebruik te maken van Windows met MS Office 2003 weet ik dat de toegevoegde programmacode in het oorspronkelijke excel document er ongeveer zo uitziet:

Code: [Selecteer]

.xl24

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

background:navy;

mso-pattern:navy none;}

.xl25

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:right;

background:navy;

mso-pattern:navy none;}

.xl26

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0";

text-align:right;

background:navy;

mso-pattern:navy none;}

.xl27

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

background:#CCFFFF;

mso-pattern:#CCFFFF none;}

.xl28

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

font-family:"MS Sans Serif", sans-serif;

mso-font-charset:0;

mso-number-format:"0\;\[Red\]0";

text-align:left;

border-top:.5pt solid #1A1A1A;

border-right:none;

border-bottom:.5pt solid #1A1A1A;

border-left:.5pt solid #1A1A1A;

background:#CCFFFF;

mso-pattern:#CCFFFF none;}

.xl29

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:center;

border:.5pt solid #1A1A1A;

background:#CCFFFF;

mso-pattern:#CCFFFF none;}

.xl30

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

font-family:"MS Sans Serif", sans-serif;

mso-font-charset:0;

mso-number-format:"\#\,\#\#0";

text-align:center;

border:.5pt solid #1A1A1A;

background:#CCFFFF;

mso-pattern:#CCFFFF none;}

.xl31

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:center;

background:navy;

mso-pattern:navy none;}

.xl32

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border-top:.5pt solid #1A1A1A;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl33

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:none;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl34

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\.00\;\[Red\]\#\,\#\#0\.00";

text-align:right;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;}

.xl35

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0";

text-align:right;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl36

{mso-style-parent:style0;

background:#CCFFFF;

mso-pattern:#CCFFFF none;

white-space:normal;}

.xl37

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl38

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:.5pt solid #1A1A1A;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl39

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl40

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

font-family:"MS Sans Serif", sans-serif;

mso-font-charset:0;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

border-top:none;

border-right:none;

border-bottom:.5pt solid #1A1A1A;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl41

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

font-family:"MS Sans Serif", sans-serif;

mso-font-charset:0;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

border-top:.5pt solid #1A1A1A;

border-right:none;

border-bottom:.5pt solid #1A1A1A;

border-left:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl42

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0";

text-align:right;

border:.5pt solid #1A1A1A;

background:#CCFFCC;

mso-pattern:#CCFFFF none;}

.xl43

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0";

text-align:right;

border:.5pt solid #1A1A1A;

background:#CCFFFF;

mso-pattern:#CCFFFF none;}

.xl44

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

background:navy;

mso-pattern:navy none;}

.xl45

{mso-style-parent:style0;

font-size:9.0pt;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;

background:#FFFFCC;

mso-pattern:white none;}

.xl46

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0";

text-align:right;

border-top:none;

border-right:.5pt solid #1A1A1A;

border-bottom:none;

border-left:.5pt solid #1A1A1A;

background:#FFFFCC;

mso-pattern:white none;}

.xl47

{mso-style-parent:style0;

background:white;

mso-pattern:#FFFFCC none;

white-space:normal;}

.xl48

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

font-family:"MS Sans Serif", sans-serif;

mso-font-charset:0;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:left;

border:.5pt solid #1A1A1A;

background:#FFFFCC;

mso-pattern:white none;}

.xl49

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:right;

border:.5pt solid #1A1A1A;

background:#FFFFCC;

mso-pattern:white none;}

.xl50

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0\;\[Red\]\#\,\#\#0";

text-align:right;

background:navy;

mso-pattern:navy none;}

.xl51

{mso-style-parent:style0;

font-size:9.0pt;

font-weight:700;

mso-number-format:"\#\,\#\#0\\ \;\[Red\]\\-\#\,\#\#0\\ ";

text-align:right;

border:.5pt solid #1A1A1A;

background:#FFFFCC;

mso-pattern:white none;} Het valt mij op dat Gedit de code anders weergeeft dan kladblok. Dit stukje code is gekopieerd uit VB dat standaard in MS Office ingebakken zit. Hoe kan men deze code oproepen bij een OpenOffice document onder Ubuntu?***

Als ik de volledige programmacode (dus niet enkel het bovenstaande stukje) kopieer in kladblok, dit opsla en vervolgens de extensie wijzig van *.txt in *.xls, dan opent excel dit perfect. Doe ik hetzelfde met gedit en Calc dan zijn de opmaak en de formules verdwenen.  Gedit kan trouwens geen *.ods bestand openen ... 

***:Dit is de vraag, de rest is randinformatie.

[Cumulus007]

Gedit kan geen OpenDocument-bestanden openen, omdat dat eigenlijk archiefbestanden zijn.

[vanadium]

Ook Office 2007 bestanden zijn archiefbestanden. Zowel MS Office bestanden als OOo bestanden zijn "ordinaire" zip archieven!

[Pattattezak]

Na het uitpakken met de archiefbeheerder, krijgt men xml bestanden die zich openen in de webbrowser. Het bestand content.xml bevat de programmacode van het bestand. Deze ziet er nogal anders uit. Maar goed, de toegevoegde code is in Pjotr zijn bestand is er nog altijd. Alleen ziet deze er nu uit als:

Code: [Selecteer]

<table:table-cell table:style-name="ce20" table:formula="of:=SUM([.C3:.N3])" office:value-type="float" office:value="0"> Ik vermoed dat deze code er voor zorgt dat er geen nullen zichtbaar zijn, maar zo vlug ben ik er niet in thuis en bijgevolg ben ik het ver van zeker ...