OpenOffice crashes when importing csv file into calc

[Ken Speakman]

Binary package hint: openoffice.org

The csv file is an address book exported from Outlook Express. The import process into calc works perfectly, but after a few seconds, it crashes and immediately recovers the file. The crash-recover sequence appears to be endless. If, however, I start OpenOffice writer first, I can import the file into calc, edit it and save it with complete success. In fact, once OpenOffice writer has been run, calc no longer crashes! This is with Ubuntu Gutsy Gibbon, which is kept up to date at all times. The cpu is Pentium 4 1.7GHz 512M ram on an Aopen motherboard

[gripped (lee-r-harris)]

I can confirm this bug.
Any csv file I can remember opening crashes openoffice as described.

Thanks for the writer workaround. this is working for me as well.

gutsy
AMD Barton
ABIT NF7S (from memory) mobo

[Chris Cheney (ccheney)]

I am running openoffice.org 1:2.3.0-1ubuntu5.3 from gutsy-updates. I created a test csv file and was able to open it fine with calc when writer wasn't running. I also tried removing ~/.openoffice.org2 dir and it still was able to open the file just fine. Can you please attach a simple test case file that exhibits the problem?

Thanks,

Chris Cheney

[Ken Speakman (ken-speakman)]

Hi Chris,
  the file that caused the problem was an address book exported from Outlook Express. I don't want to send a file with personal information in it, so when I get a chance, perhaps on Sunday, I'll try to produce a file that exhibits the problem.
  Regards,
  Ken Speakman

Chris Cheney <email address hidden> wrote:
  I am running openoffice.org 1:2.3.0-1ubuntu5.3 from gutsy-updates. I
created a test csv file and was able to open it fine with calc when
writer wasn't running. I also tried removing ~/.openoffice.org2 dir and
it still was able to open the file just fine. Can you please attach a
simple test case file that exhibits the problem?

Thanks,

Chris Cheney

** Changed in: openoffice.org (Ubuntu)
Assignee: (unassigned) => Chris Cheney (ccheney)
Status: New => Incomplete

--
OpenOffice crashes when importing csv file into calc
https://bugs.launchpad.net/bugs/184887
You received this bug notification because you are a direct subscriber
of the bug.

---------------------------------
 Sent from Yahoo! &#45; a smarter inbox.

[Chris Cheney (ccheney)]

Ken,

That will be fine, actually the smaller the file that shows the problem the better.

Thanks,

Chris

[Ken Speakman (ken-speakman)]

Hi Chris,
apologies for not sending the .csv file any sooner. I can't set up a file that produces the problem without including email addresses - if I edit the .csv file, the import works OK, but on a csv file created by an email client, the problem shows itself reliably. Rather than send you an extract from my address book, could I suggest you export some addresses from your own (I use Thunderbird) as a .csv. If this doesn't show the problem, I'll send a small address book to you.
Regards,
Ken Speakman

Chris Cheney <email address hidden> wrote: Ken,

That will be fine, actually the smaller the file that shows the problem
the better.

Thanks,

Chris

--
OpenOffice crashes when importing csv file into calc
https://bugs.launchpad.net/bugs/184887
You received this bug notification because you are a direct subscriber
of the bug.

---------------------------------
Sent from Yahoo! Mail.
A Smarter Inbox.

[Chris Cheney (ccheney)]

My email client, evolution, does export as csv it only exports as vcards. I used to use thunderbird until its sorting became completely broken for imap and then switched off of it, since upstream didn't seem to think they were ever going to be able to fix it. If you mangle the usernames in the address book does it still crash? That way you could attach the file without it giving away the users real email addresses.

[Chris Cheney (ccheney)]

I meant to say it does not export as csv it only exports as vcards.

[Ken Speakman (ken-speakman)]

Hi Chris,
I've found something else that produces a similar effect - it's a powerpoint and it's quite small. It doesn't produce the never-ending loop, but it does crash openoffice.

Chris Cheney <email address hidden> wrote: I meant to say it does not export as csv it only exports as vcards.

--
OpenOffice crashes when importing csv file into calc
https://bugs.launchpad.net/bugs/184887
You received this bug notification because you are a direct subscriber
of the bug.

---------------------------------
Sent from Yahoo! Mail.
The World &#39;s Favourite Email.

[Chris Cheney (ccheney)]

I believe that this bug has been corrected in Ubuntu hardy openoffice.org 1:2.4.0~rc2-1ubuntu3 so I am marking it as Fix Released. If after upgrading you continue to have problems with this issue then feel free to reopen this bug.

Thanks,

Chris Cheney

[Chris Cheney (ccheney)]

Apparently this crash happens on amd64 but not on i386 on hardy, will test on my amd64 box in a few minutes.

[Chris Cheney (ccheney)]

Bug 201524 apparently has a crash report once it is no longer marked private

[Chris Cheney (ccheney)]

Hmm the powerpoint file doesn't crash my hardy amd64 either. So I am marking this back as FIx Released. I will look into the other bug once it is longer private and find out why it affects the other person (maybe they aren't on up to date hardy).

Thanks,

Chris Cheney