xls file causing crash

Jack11 · July 4, 2011, 9:32am

Hi all,
I have a file (saved in the xls format) that crashes LibO 3.3.2. It's
a fairly straightforward file, only has 4 data points and a chart. MS
Office 2007 opens it just fine. Could anyone comment whether they can
open this file or not? I'm curious to find out whether the issue
causing this crash has been resolved in the 3.4.x branch (or maybe
3.3.3). I've uploaded the file, it's available here:
http://www.2shared.com/document/3WwWglyX/Non_contiguous.html

This is just a dummy file which I created to test for another bug
(https://bugs.freedesktop.org/show_bug.cgi?id=38734 and
https://bugs.freedesktop.org/show_bug.cgi?id=38746). Unfortunately, I
can't remember the exact steps I used to create the file, so I can't
easily narrow down to what causes the crash.

Regards
Stephan

Sigrid_Carrera · July 4, 2011, 10:07am

Hi Stephan,

Hi all,
I have a file (saved in the xls format) that crashes LibO 3.3.2. It's
a fairly straightforward file, only has 4 data points and a chart. MS
Office 2007 opens it just fine. Could anyone comment whether they can
open this file or not? I'm curious to find out whether the issue
causing this crash has been resolved in the 3.4.x branch (or maybe
3.3.3). I've uploaded the file, it's available here:
http://www.2shared.com/document/3WwWglyX/Non_contiguous.html

I can open it with:
LibreOffice 3.3.2
OOO330m19 (Build:202)
Ver: 3.3.2.2-14.mga1

whereas
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.2.2
crashes repeatedly.

Does this help you in any way?

Sigrid

David_Griffiths · July 4, 2011, 10:25am

Sigrid Carrera wrote:

Hi Stephan,

Hi all,
I have a file (saved in the xls format) that crashes LibO 3.3.2. It's
a fairly straightforward file, only has 4 data points and a chart. MS
Office 2007 opens it just fine. Could anyone comment whether they can
open this file or not? I'm curious to find out whether the issue
causing this crash has been resolved in the 3.4.x branch (or maybe
3.3.3). I've uploaded the file, it's available here:
http://www.2shared.com/document/3WwWglyX/Non_contiguous.html

I can open it with:
LibreOffice 3.3.2
OOO330m19 (Build:202)
Ver: 3.3.2.2-14.mga1

whereas
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.2.2
crashes repeatedly.

Does this help you in any way?

Sigrid

Hi Stephan.

I just tried and found no problem opening the file.

I run openSUSE 11.4 64 bit with:
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1

Best regards
Dave

Michael_D_Setzer_II · July 4, 2011, 10:42am

Date sent: Mon, 04 Jul 2011 11:24:44 +0100
Send reply to: users@global.libreoffice.org

Sigrid Carrera wrote:

> Hi Stephan,
>
>
>> Hi all,
>> I have a file (saved in the xls format) that crashes LibO 3.3.2. It's
>> a fairly straightforward file, only has 4 data points and a chart. MS
>> Office 2007 opens it just fine. Could anyone comment whether they can
>> open this file or not? I'm curious to find out whether the issue
>> causing this crash has been resolved in the 3.4.x branch (or maybe
>> 3.3.3). I've uploaded the file, it's available here:
>> http://www.2shared.com/document/3WwWglyX/Non_contiguous.html
>
> I can open it with:
> LibreOffice 3.3.2
> OOO330m19 (Build:202)
> Ver: 3.3.2.2-14.mga1
>
> whereas
> LibreOffice 3.3.3
> OOO330m19 (Build:301)
> tag libreoffice-3.3.2.2
> crashes repeatedly.
>
> Does this help you in any way?
>
> Sigrid

Hi Stephan.

I just tried and found no problem opening the file.

I run openSUSE 11.4 64 bit with:
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1

Best regards
Dave

I opened it in 3.3.3 and 3.4.1 on Fedora 14 64bit and no crash.
The graph is displayed, but it has no points maked on either.
Clicking on the chart doesn't seem to show it as a chart, but an
object?
I can highlight A1:A5 and make a chart and it shows just fine?

Tom_Davies · July 4, 2011, 1:15pm

Hi
It opened fine in LibreOffice 3.3.2 in Ubuntu 10.04 but i didn't see the
data-points in the chart. Probably because i didn't look along the axis
Regards from
Tom

elcico · July 4, 2011, 2:45pm

________________________________
Da: Stephan Zietsman <sziets@gmail.com>
A: users@global.libreoffice.org
Inviato: Lun 4 luglio 2011, 11:32:26
Oggetto: [libreoffice-users] xls file causing crash

Hi all,
I have a file (saved in the xls format) that crashes LibO 3.3.2. It's

- - -

Hello,
I can open the file and see data and chart.

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5

Namastè!

planas · July 4, 2011, 6:21pm

Hi

To: users@global.libreoffice.org
From: Dave Griffiths <dave.griffiths62@gmail.com>
Subject: [libreoffice-users] Re: xls file causing crash
Date sent: Mon, 04 Jul 2011 11:24:44 +0100
Send reply to: users@global.libreoffice.org

> Sigrid Carrera wrote:
>
> > Hi Stephan,
> >
> >
> >> Hi all,
> >> I have a file (saved in the xls format) that crashes LibO 3.3.2. It's
> >> a fairly straightforward file, only has 4 data points and a chart. MS
> >> Office 2007 opens it just fine. Could anyone comment whether they can
> >> open this file or not? I'm curious to find out whether the issue
> >> causing this crash has been resolved in the 3.4.x branch (or maybe
> >> 3.3.3). I've uploaded the file, it's available here:
> >> http://www.2shared.com/document/3WwWglyX/Non_contiguous.html
> >
> > I can open it with:
> > LibreOffice 3.3.2
> > OOO330m19 (Build:202)
> > Ver: 3.3.2.2-14.mga1
> >
> > whereas
> > LibreOffice 3.3.3
> > OOO330m19 (Build:301)
> > tag libreoffice-3.3.2.2
> > crashes repeatedly.
> >
> > Does this help you in any way?
> >
> > Sigrid
>
> Hi Stephan.
>
> I just tried and found no problem opening the file.
>
> I run openSUSE 11.4 64 bit with:
> LibreOffice 3.3.3
> OOO330m19 (Build:301)
> tag libreoffice-3.3.3.1
>
> Best regards
> Dave

I opened it in 3.3.3 and 3.4.1 on Fedora 14 64bit and no crash.
The graph is displayed, but it has no points maked on either.
Clicking on the chart doesn't seem to show it as a chart, but an
object?
I can highlight A1:A5 and make a chart and it shows just fine?

>
>
>
> --
> Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
> In case of problems unsubscribing, write to postmaster@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>

+----------------------------------------------------------+
  Michael D. Setzer II - Computer Science Instructor
  Guam Community College Computer Center
  mailto:mikes@kuentos.guam.net
  mailto:msetzerii@gmail.com
  http://www.guam.net/home/mikes
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned: 19,471
Processing time: 32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
SETI 10955724.653275 | EINSTEIN 6125020.940851
ROSETTA 3331309.334431 | ABC 6699348.880691

I can open it with 3.4.1 Ubuntu/Pinguy 11.04 64 bit. I also do see any
data points.

Steve_Edmonds · July 4, 2011, 6:56pm

Hi. I can open it with 3.4.1, the chart shows as a bar chart but there are no data series defined.
How have you defined the data series in your original file, as a data range A1:A5 or as a named range.
steve

Jack11 · July 5, 2011, 8:11am

Steve Edmonds wrote:

How have you defined the data series in your original file, as a data range
A1:A5 or as a named range.

I defined it as a data range, however it is non-contiguous. As far as
I remember, it should be "sheet1.A1:A3, sheet1.A5" (without quotes).

Regards
Stephan

Steve_Edmonds · July 5, 2011, 9:44am

If I take your file, edit the chart data series (which appears blank in LO3.4.1) and add

sheet1.A1:A3, sheet1.A5

I get the correct chart.
My assumption is that there is a bug in the import filter for the .xls file and the chart is importing blank data series. A bug could be filed.
steve

Jack11 · July 5, 2011, 10:54am

Steve Edmonds wrote:

If I take your file, edit the chart data series (which appears blank in
LO3.4.1) and add

sheet1.A1:A3, sheet1.A5

I get the correct chart.
My assumption is that there is a bug in the import filter for the .xls file
and the chart is importing blank data series. A bug could be filed.

A report has already been filed for that particular bug
(https://bugs.freedesktop.org/show_bug.cgi?id=38746). But what I'm
experiencing is LibO crashing when trying to open the file, for which
there is no bug (that I'm aware of).

Regards
Stephan

Jack11 · July 5, 2011, 11:15am

Sigrid Carrera wrote:

I can open it with:
LibreOffice 3.3.2
OOO330m19 (Build:202)
Ver: 3.3.2.2-14.mga1

whereas
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.2.2
crashes repeatedly.

Dave Griffiths wrote:

I just tried and found no problem opening the file.

I run openSUSE 11.4 64 bit with:
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1

El Cico wrote:

I can open the file and see data and chart.

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5

Thanks for all your replies. It seems that the responses are pretty
varied, and not really consistent. For instance, it crashed my LibO
3.3.2 in Win7, and Sigrid Carrera's LibO 3.3.3 (not sure what OS).
But it worked on El Cico's LibO 3.3.2 and Dave Griffiths' LibO 3.3.3.
I've tested it again today, and I found it working in both OOo 3.2.0
and LibO 3.3.2 (which didn't work yesterday).

Also, I notice that sometimes it maintains the chart data, but other
times it loses it (my own case, OOo 3.2.0 maintained the data, LibO
3.3.2 lost it).

I was hoping that I could narrow down the possibilities to file a
proper bug report, but I can make no sense of this.

Regards
Stephan

Tom_Davies · July 5, 2011, 11:53am

________________________________
From: Stephan Zietsman <sziets@gmail.com>
To: users@global.libreoffice.org
Sent: Tue, 5 July, 2011 12:14:59
Subject: Re: [libreoffice-users] xls file causing crash

Sigrid Carrera wrote:

I can open it with:
LibreOffice 3.3.2
OOO330m19 (Build:202)
Ver: 3.3.2.2-14.mga1

whereas
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.2.2
crashes repeatedly.

Dave Griffiths wrote:

I just tried and found no problem opening the file.

I run openSUSE 11.4 64 bit with:
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1

El Cico wrote:

I can open the file and see data and chart.

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5

Thanks for all your replies. It seems that the responses are pretty
varied, and not really consistent. For instance, it crashed my LibO
3.3.2 in Win7, and Sigrid Carrera's LibO 3.3.3 (not sure what OS).
But it worked on El Cico's LibO 3.3.2 and Dave Griffiths' LibO 3.3.3.
I've tested it again today, and I found it working in both OOo 3.2.0
and LibO 3.3.2 (which didn't work yesterday).

Also, I notice that sometimes it maintains the chart data, but other
times it loses it (my own case, OOo 3.2.0 maintained the data, LibO
3.3.2 lost it).

I was hoping that I could narrow down the possibilities to file a
proper bug report, but I can make no sense of this.

Regards
Stephan

Hi
I think it's best to just post the bug-report with the info you do have. The
triagers should be able to help you pin-down exactly where the problem is.
Regards from
Tom

Hladuvka_Jiri · July 5, 2011, 3:02pm

It crashed on LibO 3.3.3 on WIN XP/Home SP2

Regards,
Jiri

Dne 5.7.2011 13:14, Stephan Zietsman napsal(a):

cornouws · July 7, 2011, 10:37am

Hi Stephan,

Stephan Zietsman wrote (05-07-11 13:14)

Sigrid Carrera wrote:

I can open it with:
LibreOffice 3.3.2
OOO330m19 (Build:202)
Ver: 3.3.2.2-14.mga1

whereas
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.2.2
crashes repeatedly.

Dave Griffiths wrote:

I just tried and found no problem opening the file.

I run openSUSE 11.4 64 bit with:
LibreOffice 3.3.3
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1

El Cico wrote:

I can open the file and see data and chart.

LibreOffice 3.3.2
OOO330m19 (Build:202)
tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5

Thanks for all your replies. It seems that the responses are pretty
varied, and not really consistent. For instance, it crashed my LibO
3.3.2 in Win7, and Sigrid Carrera's LibO 3.3.3 (not sure what OS).
But it worked on El Cico's LibO 3.3.2 and Dave Griffiths' LibO 3.3.3.
I've tested it again today, and I found it working in both OOo 3.2.0
and LibO 3.3.2 (which didn't work yesterday).

Also, I notice that sometimes it maintains the chart data, but other
times it loses it (my own case, OOo 3.2.0 maintained the data, LibO
3.3.2 lost it).

To add some more: crashes on opening in 3.3.2 and 3.3.3 on Ubuntu.
Does not crash in 3.4.1. Can change data / chart there too.

I was hoping that I could narrow down the possibilities to file a
proper bug report, but I can make no sense of this.

Well, pls do. Since a developer with a debug-environment can prolly find out what the problem is.

Jack11 · July 7, 2011, 12:20pm

Cor Nouws wrote:

Stephan wrote:

I was hoping that I could narrow down the possibilities to file a
proper bug report, but I can make no sense of this.

Well, pls do. Since a developer with a debug-environment can prolly find out
what the problem is.

I've created a bug report
(https://bugs.freedesktop.org/show_bug.cgi?id=39032). If anyone has
something useful to contribute, please do so.

The report does reference this discussion thread, so you don't have to
repeat everything you've posted here. However, I think it would be
useful to add a comment to the bug report stating your Operating
System and LibreOffice version (and whether or not the file crashes).

Regards
Stephan

cornouws · July 7, 2011, 12:31pm

Stephan Zietsman wrote (07-07-11 14:19)

I've created a bug report
(https://bugs.freedesktop.org/show_bug.cgi?id=39032). If anyone has
something useful to contribute, please do so.

The report does reference this discussion thread, so you don't have to
repeat everything you've posted here. However, I think it would be
useful to add a comment to the bug report stating your Operating
System and LibreOffice version (and whether or not the file crashes).

Done. Thanks!