Apache OpenOffice (AOO) Bugzilla – Issue 88648
PXL import filter seems to be broken
Last modified: 2013-01-29 21:45:55 UTC
I can save a pocket excel file from oo but having saved it I can't open it. If I try, first I get asked which application to use and then oo tries to open it as a text file. If I try to open it from oo and give it the file type, I get a blank sheet.
Created attachment 53140 [details] This is a file saved with oo. Can't open it with oo though.
Should have said that pocket excel can open the file, just not oo.
I can confirm this issue in OOo2.4.0 1. Creat a clac document and save it as PXL format 2. Open this PXL file with clac. //OOo requires a character set 3. After a choice, the document is opened with writer. 4. Choose PXL in the filter and open the PXL file. 5. An empty calc document appears
I have a PC running Fedora 7 with the Sun JRE installed plus OpenOffice 2.3.0 installed using the Fedora-supplied RPMs: >>> $ rpm -qa | grep openoffice openoffice.org-langpack-en-2.3.0-6.9.fc7 openoffice.org-graphicfilter-2.3.0-6.9.fc7 openoffice.org-calc-2.3.0-6.9.fc7 openoffice.org-writer-2.3.0-6.9.fc7 openoffice.org-xsltfilter-2.3.0-6.9.fc7 openoffice.org-math-2.3.0-6.9.fc7 openoffice.org-draw-2.3.0-6.9.fc7 openoffice.org-javafilter-2.3.0-6.9.fc7 openoffice.org-core-2.3.0-6.9.fc7 openoffice.org-impress-2.3.0-6.9.fc7 <<< Using this installation of OpenOffice, I was able to open the attached file (attachment #53140 [details]) when I manually selected the correct file type in the file open dialog. All the text just appears as squares (that must be a separate issue) but I can see plenty of numbers; there is content up to row 23 and column F. I started OpenOffice from the command line by running 'ooffice' and can confirm that no errors appear in the console. I installed OpenOffice 2.3.0 and 2.4.2 using RPMs generated (as far as I can tell) by openoffice.org - not Fedora. I installed the RPMs using a separate RPM databases under /opt so that they could all co-exist. When I tried to use either of these versions to open the attached .pxl file, a .pxl file I generated myself using Pocket Excel on Pocket PC 2002, or a .psw file I generated myself using Pocket Word on Pocket PC 2002, I always got a blank spreadsheet/document. In all cases, the following error message appeared on the console: >>> Exception in OfficeDocument.write():java.io.IOException: java.io.IOException: No appropriate API (JAXP/Xerces) to serialize XML document: com.sun.org.apache.xerces.internal.dom.DocumentImpl <<< I have another PC running Fedora 10 without the Sun JRE installed. It has OpenOffice 3.0.0 installed using the Fedora RPMs: >>> $ rpm -qa | grep openoffice openoffice.org-draw-core-3.0.0-9.10.fc10.i386 openoffice.org-writer-3.0.0-9.10.fc10.i386 openoffice.org-draw-3.0.0-9.10.fc10.i386 openoffice.org-graphicfilter-3.0.0-9.10.fc10.i386 openoffice.org-writer-core-3.0.0-9.10.fc10.i386 openoffice.org-impress-core-3.0.0-9.10.fc10.i386 openoffice.org-calc-core-3.0.0-9.10.fc10.i386 openoffice.org-calc-3.0.0-9.10.fc10.i386 openoffice.org-langpack-en-3.0.0-9.10.fc10.i386 openoffice.org-ure-3.0.0-9.10.fc10.i386 openoffice.org-brand-3.0.0-9.10.fc10.i386 openoffice.org-math-3.0.0-9.10.fc10.i386 openoffice.org-javafilter-3.0.0-9.10.fc10.i386 openoffice.org-presenter-screen-3.0.0-9.10.fc10.i386 openoffice.org-math-core-3.0.0-9.10.fc10.i386 openoffice.org-xsltfilter-3.0.0-9.10.fc10.i386 openoffice.org-pdfimport-3.0.0-9.10.fc10.i386 openoffice.org-core-3.0.0-9.10.fc10.i386 openoffice.org-impress-3.0.0-9.10.fc10.i386 <<< I get the same behaviour as above (blank spreadsheet/document and the same error message on the console) when I try to open the .pxl/.psw files using this version of OpenOffice in this environment. As above, I installed the openoffice.org-generated RPMs for a number of versions of OpenOffice (2.3.0, 2.4.2 and 3.0.1) on this Fedora 10 PC and saw the same behaviour with all of them. It seems most interesting that OpenOffice 2.3.0 behaves differently on the same PC depending on whether it is distributed by openoffice.org or Fedora. I note that Fedora seem to use quite a few patches to the distribution. This is a stab in the dark, but I note that http://cvs.fedoraproject.org/viewvc/rpms/openoffice.org/F-7/openoffice.org.spec?revision=1.1209&view=markup includes: >>> %configure --with-build-version=%{name}-%{version}-%{release} --with-unix-wrapper=%{name} --disable-ldap --disable-crashdump --disable-epm --disable-qadevooo --disable-fontooo --disable-mathmldtd --disable-pasf --disable-Xaw --with-ant-home=/usr/share/ant %{jdkflags} --enable-gstreamer --enable-symbols --enable-lockdown --enable-evolution2 --enable-cairo --enable-vba --enable-dbus --with-system-libs --with-system-vigra --with-system-hunspell --with-system-python --with-system-mozilla=firefox --with-system-boost --with-system-libwpd --with-system-icu --with-system-odbc-headers --with-system-sane-header --with-system-xrender-headers --with-system-libxslt --with-system-hsqldb --with-system-beanshell --with-system-db --with-system-xml-apis --with-system-xerces --with-system-xalan --without-system-mspack --without-system-xt --without-system-neon --without-fonts --without-nas --without-gpc --without-agg --without-ppds --without-afms %{stlflags} --with-lang="%{langpack_langs}" --with-poor-help-localizations="$POORHELPS" <<< Since the error message references "com.sun.org.apache.xerces.internal.dom.DocumentImpl" I wonder if the use of --with-system-xerces causes the Fedora-packaged OpenOffice 2.3.0 to use a different class. The Fedora-packaged OpenOffice 3.0.0 doesn't seem to include this flag (I may not have checked properly). I see at http://svn.services.openoffice.org/opengrok/xref/Current (trunk)/xmerge/source/xmerge/java/org/openoffice/xmerge/converter/dom/DOMDocument.java (which seems to be the source file generating the error message) that if the class in use were "org.apache.xerces.dom.DocumentImpl" it looks like there would be no error, and perhaps that is the class that is used if --with-system-xerces is in use? I have not investigated that far yet.
On my same PC running Fedora 10 without the Sun JRE installed, I now have newer Fedora-supplied OpenOffice RPMs: >>> $ rpm -qa | grep openoffice openoffice.org-math-core-3.0.1-15.6.fc10.i386 openoffice.org-writer-3.0.1-15.6.fc10.i386 openoffice.org-core-3.0.1-15.6.fc10.i386 openoffice.org-draw-core-3.0.1-15.6.fc10.i386 openoffice.org-impress-3.0.1-15.6.fc10.i386 openoffice.org-langpack-en-3.0.1-15.6.fc10.i386 openoffice.org-presenter-screen-3.0.1-15.6.fc10.i386 openoffice.org-draw-3.0.1-15.6.fc10.i386 openoffice.org-graphicfilter-3.0.1-15.6.fc10.i386 openoffice.org-math-3.0.1-15.6.fc10.i386 openoffice.org-calc-core-3.0.1-15.6.fc10.i386 openoffice.org-calc-3.0.1-15.6.fc10.i386 openoffice.org-javafilter-3.0.1-15.6.fc10.i386 openoffice.org-ure-3.0.1-15.6.fc10.i386 openoffice.org-brand-3.0.1-15.6.fc10.i386 openoffice.org-xsltfilter-3.0.1-15.6.fc10.i386 openoffice.org-impress-core-3.0.1-15.6.fc10.i386 openoffice.org-pdfimport-3.0.1-15.6.fc10.i386 openoffice.org-writer-core-3.0.1-15.6.fc10.i386 <<< When I try to open the same .pxl/.psw files using this version of OpenOffice in this environment, they seem to be opened with at least some of the data there; in the case of the .psw file, there was at least one sentence missing from the end of the document; I haven't done a more detailed comparison of either document. I got this error message on the console when opening the first file (the .pxl file): >>> [Java framework]sunjavaplugin.so could not load Java runtime library: file:///usr/java/jre1.6.0_11/lib/i386/client/libjvm.so. <<< I have not investigated that error message further; since the files are loaded, I assume it doesn't matter.
Hello. My name is Lilian i saw your proffle here and admire it i think we can make it together, therefore i would like you to contact me back throug my email address thus: lilianfrank44@yahoo.com i will tell you more about myself and i will also send you my photo as soon as you contact me back. Hopping to hear from you soonest, UNDERSTAND THAT LOVE IS ONE, Lilian WITH LOVE AND TRUST Love & Kiss. lilianfrank44@yahoo.com