Issue 57412 - Calc loops trying to import spreadsheetML Excel spreadsheet
Summary: Calc loops trying to import spreadsheetML Excel spreadsheet
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 680m142
Hardware: PC Linux, all
: P2 Trivial (vote)
Target Milestone: ---
Assignee: svante.schubert
QA Contact: issues@sc
URL:
Keywords: crash, oooqa
Depends on:
Blocks:
 
Reported: 2005-11-06 00:31 UTC by dezurik
Modified: 2013-08-07 15:14 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
flat Calc OpenDocument (9.76 KB, text/xml)
2005-12-13 15:36 UTC, svante.schubert 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dezurik 2005-11-06 00:31:26 UTC 
I have a spreadsheet saved in spreadsheetML format called 'ss.xls'.  If I move
it to a Windows box, I double click it (the icon) and it opens, as expected, in
Excel  2003 (v 11.6355.6408 SP1), but will crash Calc (Open Office 2.0) when I
do this:

1. Open blank Calc instance

2. File -> Open, Select 'ss.xls', change File Type to 'Microsoft Excel 2003 XML
(*.xml)', and click 'Open'.

It sits processing for a bit, then up pops a window titled, "OOo has crashed!:
Paste this text into your bugreport".

So below is that text. Below that is the XML from the .xls file.

===================
0xbdb028: /usr/lib/openoffice.org2.0/program/libuno_sal.so.3 + 0x1e028
0xbdb7ee: /usr/lib/openoffice.org2.0/program/libuno_sal.so.3 + 0x1e7ee
0x625420:  + 0x420 (__kernel_sigreturn + 0x0)
0x4b4888: /lib/libc.so.6 + 0x29888 (abort + 0xf8)
0xb3450a49: /usr/lib/libgcj.so.6 + 0x701a49 (_Jv_Throw + 0x51)
0xb34452e6: /usr/lib/libgcj.so.6 + 0x6f62e6 (_Jv_NewPrimArray + 0x0)
0xb3443fa8: /usr/lib/libgcj.so.6 + 0x6f4fa8
0x4dd74e9: /usr/lib/openoffice.org2.0/program/libsc680li.so + 0x5324e9
0x2fadf59: /usr/lib/openoffice.org2.0/program/libxo680li.so + 0x6cf59
(SvXMLImport::endElement(rtl::OUString const&) + 0x4f)
0x39b184e: /usr/lib/openoffice.org2.0/program/libxsltfilter680li.so + 0x384e
0x130902f: /usr/lib/openoffice.org2.0/program/sax.uno.so + 0x902f
0x3a2efd2: /usr/lib/libexpat.so.0 + 0x8fd2
0x3a2fc6d: /usr/lib/libexpat.so.0 + 0x9c6d
0x3a2dab2: /usr/lib/libexpat.so.0 + 0x7ab2
0x3a2e73d: /usr/lib/libexpat.so.0 + 0x873d
0x3a287e9: /usr/lib/libexpat.so.0 + 0x27e9 (XML_ParseBuffer + 0x75)
0x3a2ad9b: /usr/lib/libexpat.so.0 + 0x4d9b (XML_Parse + 0x143)
0x1309467: /usr/lib/openoffice.org2.0/program/sax.uno.so + 0x9467
0x1309cef: /usr/lib/openoffice.org2.0/program/sax.uno.so + 0x9cef
0x39b2eaf: /usr/lib/openoffice.org2.0/program/libxsltfilter680li.so + 0x4eaf
0x60937de: /usr/lib/openoffice.org2.0/program/libxmlfa680li.so + 0x57de
0x60939cb: /usr/lib/openoffice.org2.0/program/libxmlfa680li.so + 0x59cb
0x3333457: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x12d457
(SfxObjectShell::ImportFrom(SfxMedium&) + 0x5fb)
0x33342f3: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x12e2f3
(SfxObjectShell::DoLoad(SfxMedium*) + 0x6b1)
0x3363079: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x15d079
(SfxBaseModel::load(com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue>
const&) + 0x2f9)
0x337ed47: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x178d47
0x282f31b: /usr/lib/openoffice.org2.0/program/libfwk680li.so + 0xe931b
0x282f4d9: /usr/lib/openoffice.org2.0/program/libfwk680li.so + 0xe94d9
0x2788a21: /usr/lib/openoffice.org2.0/program/libfwk680li.so + 0x42a21
0x2788683: /usr/lib/openoffice.org2.0/program/libfwk680li.so + 0x42683
0x32b0b0d: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xaab0d
0x32b5b10: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xafb10
0x33aca46: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1a6a46
0x33abe2a: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1a5e2a
0x33ac13f: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1a613f
0x33ac1e2: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1a61e2
0x32ad06e: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0xa706e
0x33c51dd: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1bf1dd
0x33c5098: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1bf098
0x33c51f2: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1bf1f2
0x33c5084: /usr/lib/openoffice.org2.0/program/libsfx680li.so + 0x1bf084
0x236300: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x82300
0x38a740: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x1d6740
0x1027cdc: /usr/lib/openoffice.org2.0/program/libvclplug_gen680li.so + 0x1ecdc
0x104d9e8: /usr/lib/openoffice.org2.0/program/libvclplug_gen680li.so + 0x449e8
(SalDisplay::DispatchInternalEvent() + 0xb0)
0xe14fa9: /usr/lib/openoffice.org2.0/program/libvclplug_gtk680li.so + 0x18fa9
0xfa5730: /usr/lib/libglib-2.0.so.0 + 0x25730
0xfa34ce: /usr/lib/libglib-2.0.so.0 + 0x234ce (g_main_context_dispatch + 0x1dc)
0xfa64d6: /usr/lib/libglib-2.0.so.0 + 0x264d6
0xfa69b8: /usr/lib/libglib-2.0.so.0 + 0x269b8 (g_main_context_iteration + 0x66)
0xe14bcf: /usr/lib/openoffice.org2.0/program/libvclplug_gtk680li.so + 0x18bcf
0x104eafa: /usr/lib/openoffice.org2.0/program/libvclplug_gen680li.so + 0x45afa
(X11SalInstance::Yield(unsigned char) + 0x28)
0x23c594: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x88594
(Application::Yield() + 0x48)
0x23c5ca: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x885ca
(Application::Execute() + 0x26)
0x26aac73: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x21c73
(desktop::Desktop::Main() + 0x15ab)
0x24199f: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8d99f
0x241a4f: /usr/lib/openoffice.org2.0/program/libvcl680li.so + 0x8da4f (SVMain()
+ 0x29)
0x26a5ad7: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x1cad7 (sal_main
+ 0x57)
0x26a5b23: /usr/lib/openoffice.org2.0/program/libsoffice.so + 0x1cb23 (main + 0x27)
0x49fd5f: /lib/libc.so.6 + 0x14d5f (__libc_start_main + 0xdf)
0x80484e1: /usr/lib/openoffice.org2.0/program/scalc.bin + 0x4e1

===================


The Excel XML file
===================
<?xml version="1.0" encoding="UTF-8"?>
			<?mso-application progid="Excel.Sheet"?>
			<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
			xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
				<Worksheet ss:Name="Evaluation">
					<ss:Table>

			<ss:Row><ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><B>
			Altered name :: Evaluation : 11/05/2005 06:01:35 pm
			</B></ss:Data></ss:Cell></ss:Row>
		 <ss:Row><ss:Cell><ss:Data ss:Type="String"> Another trip (2005-11-18)
</ss:Data></ss:Cell></ss:Row>  <ss:Row>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Name </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Emal </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Overasion </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Prls </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Oretails </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Uaff </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Translatides
</U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Hoanglers </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
ment </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Hors </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Meals </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Mealer </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Meamping </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Thinkack </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Frienfo </U></ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"
xmlns="http://www.w3.org/TR/REC-html40"><U> Traere </U></ss:Data></ss:Cell> 
<ss:Cell><ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><U>
Comments </U></ss:Data></ss:Cell>  </ss:Row>  <ss:Row>  <ss:Cell><ss:Data
ss:Type="String"> DeZurik, Damien </ss:Data></ss:Cell>  <ss:Cell><ss:Data
ss:Type="String"> boo1@domain.com </ss:Data></ss:Cell>  <ss:Cell><ss:Data
ss:Type="String"> 1 </ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> 2
</ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> 3 </ss:Data></ss:Cell>
 <ss:Cell><ss:Data ss:Type="String"> 4 </ss:Data></ss:Cell>  <ss:Cell><ss:Data
ss:Type="String"> 5 </ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> -1
</ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> 1 </ss:Data></ss:Cell>
 <ss:Cell><ss:Data ss:Type="String"> 2 </ss:Data></ss:Cell>  <ss:Cell><ss:Data
ss:Type="String"> 3 </ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> 4
</ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> 5 </ss:Data></ss:Cell>
 <ss:Cell><ss:Data ss:Type="String"> considerably exceeded </ss:Data></ss:Cell>
 <ss:Cell><ss:Data ss:Type="String"> Yes, you know who they are, don't you?
</ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> Yes, anywhere.
</ss:Data></ss:Cell>  <ss:Cell><ss:Data ss:Type="String"> Keep on
</ss:Data></ss:Cell>  </ss:Row>
					</ss:Table>
				</Worksheet>
			</Workbook>
===================


- Damien DeZurik
Comment 1 aziem 2005-12-03 16:21:50 UTC 
I confirm crash on OpenOffice.org 2.0.0rc1 (m142) from official Linux RPMs.  I
sent a crash report using the tool with my QA email address.

Set to P2 per guidelines "Crashs or freezes during normal operations of the
application"
Comment 2 svante.schubert 2005-12-13 15:32:24 UTC 
On Windows the problem is reduced to a general input/output exception.
It is NOT a problem of the (xslt) filter (therefore no dublication of i56495) as
the transformation works fine (result attached).
Therefore the XML filter framework (just inherited by myself) or underlying
mechanism trigger this problem.

Going to invest this.
Comment 3 svante.schubert 2005-12-13 15:36:18 UTC 
Created attachment 32347 [details]
flat Calc OpenDocument
Comment 4 svante.schubert 2005-12-14 10:13:32 UTC 
The reason was the XSLT filter, producing an invalid XML attibute 
table:number-columns-repeated="0"
causing the application to loop.

SUS->FST: 
This are two issues, could you pls write another for the Calc application?

issue 1) This is a scenario without column elements, where the spreadsheetml
produces invalid XSLT (IMHO target most likely pp2 as easy workaround)

issue 2) Calc which loops under Unix, when confronted with invalid ODF (IMHO due
to calc priorites most likely OOolater)

BTW please reconsider the issue keywords under Unix it is a loop not a crash.
Comment 5 svante.schubert 2005-12-14 10:26:43 UTC 
Set target to OOo 2.0.3 and changed title as in the latest builds it loops under
Unix, but not crash anymore.
Comment 6 svante.schubert 2006-03-17 14:47:42 UTC 
fixed in CWS latex
Comment 7 svante.schubert 2006-04-07 12:43:44 UTC 
Please verify that the fix works with the Office patch of CWS latex

re-open issue and reassign to oc@openoffice.org
Comment 8 svante.schubert 2006-04-07 12:43:54 UTC 
reassign to oc@openoffice.org
Comment 9 svante.schubert 2006-04-07 12:43:58 UTC 
reset resolution to FIXED
Comment 10 oc 2006-04-11 11:12:19 UTC 
verified in internal build cws_latex
Comment 11 oc 2006-06-28 14:56:07 UTC 
reopened because fix was deleted from cws
Comment 12 oc 2006-06-28 14:56:52 UTC 
reassigned to sus
Comment 13 svante.schubert 2006-07-31 20:42:32 UTC 
accepted..
Comment 14 svante.schubert 2006-08-01 12:41:32 UTC 
Already fixed in the master since m177, therefore fixed..
Comment 15 svante.schubert 2006-08-01 12:42:56 UTC 
closed