Apache OpenOffice (AOO) Bugzilla – Issue 100324
Import Excel 2003 XML - 'Could not compile stylesheet'
Last modified: 2013-08-07 15:13:10 UTC
When opening a trivial Excel 2003 XML file I get a 'Could not compile stylesheet' error. It appears to save to the format ok at least for the trivial case. Compiler warnings: file:///usr/lib/openoffice/basis3.0/share/xslt/import/spreadsheetml/spreadsheetml2ooo.xsl: line 4536: Attribute 'style:family' outside of element. ERROR: 'Error checking type of the expression 'funcall(count, [+(cast(ParentLocationPath(step("child", 74), step("child", 75)), real), funcall(number, [variable-ref(spannedRows/result-tree)]))])'.' FATAL ERROR: 'Could not compile stylesheet'
Created attachment 61019 [details] Simple Excel 2003 XML file
That should say when attempting to open, as the fatal error kept it from opening.
I have no problems opening the file. I use German OOo3.1.0_m5 on WinXP. Which version do you use exactly? Which OS do you use? Which filter do you have chosen?
Using OOo 3.0.1 as noted in the original report on Ubuntu Linux and the filter is obviously the Excel 2003 one, I didn't have to select the filter to attempt to open the file. There are no known go-oo patches that touch this area so it does not appear to be a go-oo related issue. I'm still
I'm still looking into the issue to see if I can see what is causing the issue to show up for Ubuntu and not the official build.
It appears to have been caused by using system saxon instead of internal saxon. There needs to either be a big configure warning not to use system saxon until the OOo patches are integrated upstream or to convert the xsl stylesheets to XSLT 2.0 which looks like it would solve this problem as well.
OOo 3.2 is in show-stopper stage. If this issue is critical for such release, please re-target it back. Otherwise this issue will be targeted to OOo 3.x.
probably saxon-he or similar which has at least two specific problems *** This issue has been marked as a duplicate of 110136 ***
close as dup