Bug 40585 - "Format->Cells" crashes Calc
Summary: "Format->Cells" crashes Calc
Status: CLOSED DUPLICATE of bug 40359
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: x86 (IA32) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-02 10:59 UTC by Kriton Kyrimis
Modified: 2012-04-21 11:06 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
GDB log file (4.87 KB, text/x-log)
2011-09-27 18:42 UTC, Simon Yuan
Details
MacOS X log file generated on crash when accessing Format>Cell...>Font a 2nd time (52.54 KB, text/plain)
2012-04-17 07:35 UTC, Roman Eisele
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kriton Kyrimis 2011-09-02 10:59:42 UTC
Start Calc and select Format-Cells from the menu. Calc will crash.

The same thing happens if I try to format a non-empty cell in an existing spreadsheet.
Comment 1 digital ant 2011-09-02 11:53:21 UTC
LibO 3.4.3 release, MacOSX 10.6.8, Apple Java, EN US, Core i7

I cannot confirm on my system. Format Cells does take almost a full second the first time I open it (after that it is pretty instant) - but it does not crash. Maybe Java related? (guess)
Comment 2 Kriton Kyrimis 2011-09-02 16:08:07 UTC
I see you tried this on a Mac. I'm using Windows XP, and I've seen this problem on two different machines. Perhaps the Mac version is not affected.
Comment 3 digital ant 2011-09-06 14:17:46 UTC
I finally upgraded my Windows XP sp3 (32 bit) to 3.4.3. My Java is JRE 6u26. I removed my App Data\LibO profile before installing. When I performed the steps mentioned Calc did freeze for a good 5 seconds, but did not crash. FYI ... Soffice.bin jumped to >50% CPU when clicking format/cells - NOT scalc.

After the initial 5 second delay the first time I tried the steps, format/cells does not produce a delay anymore, even after closing and re-opening calc - but the CPU utilization of soffice.bin still jumps to > 30%
Comment 4 Kriton Kyrimis 2011-09-14 06:37:14 UTC
This is somehow related to bug #40359: If I delete the "bundled" and "shared" subfolders of the "extensions" folder in my profile, the problem disappears until I exit LibreOffice. If I start LibreOffice after having exited, the bug reappears.
Comment 5 Simon Yuan 2011-09-27 18:41:35 UTC
I'm also experiencing this bug on Arch Linux i686 with LibreOffice 3.4.3. I'm attaching a debug log, but since I don't have debugging symbols turned on, this might not be very helpful, but should at least give some hint as to where the bug might be occurring.
Comment 6 Simon Yuan 2011-09-27 18:42:45 UTC
Created attachment 51696 [details]
GDB log file

Debugging output, although, without debugging symbol.
Comment 7 Markus Mohrhard 2011-10-05 22:02:37 UTC
@Simon: where did you get your libreoffice package from? It might be that if you took your systems package they miss some of our icu patches
Comment 8 Kriton Kyrimis 2011-10-06 02:42:10 UTC
(In reply to comment #7)
> It might be that if
> you took your systems package they miss some of our icu patches

Original reporter here:

If ICU is somehow involved in this, this may confirm that the problem could be related to bug #40359, which is language-related.

Since I'm seeing the problem under Windows XP, could I be missing or need to reinstall some language-related package? (Any idea what that might be?)
Comment 9 Kriton Kyrimis 2011-10-28 11:50:42 UTC
The bug persists in 3.4.4 RC1: The first time I ran calc after upgrading, Format-Cells worked. From the second time onwards, Format->cells crashes again consistently.
Comment 10 Kriton Kyrimis 2011-11-04 16:24:40 UTC
The bug persists in 3.4.4 RC2.
Comment 11 Simon Yuan 2011-11-04 21:33:51 UTC
(In reply to comment #7)
> @Simon: where did you get your libreoffice package from? It might be that if
> you took your systems package they miss some of our icu patches

I installed the Arch Linux provided package. Since I upgraded icu last week, I can no longer reproduce the crash. Thanks.
Comment 12 Rainer Bielefeld Retired 2011-11-13 08:07:12 UTC
Also NOT reproducible with "LibreOffice 3.4.4  - WIN7 Home Premium (64bit)
Greek UI  [OOO340m1 (Build:402)]".

@kyrimis@alumni.princeton.edu:
Does the problem remain when you use English UI? And with new User profile?
Comment 13 Kriton Kyrimis 2011-11-14 00:52:11 UTC
I have been using the English UI all the time; I've never used the Greek UI.

Yes, I've tried with a clean profile (remove profile, eradicate LibO with Revo Uninstaller and CCleaner, reinstall). The problem remains.
Comment 14 Kriton Kyrimis 2011-12-26 11:22:35 UTC
Bug persists with both 3.4.5rc1 and 3.5.0beta2.
Comment 15 Eike Rathke 2012-01-03 03:59:26 UTC
I presume this has the same root cause as bug 40359 that has more details on the affected systems. Closing this one here.

*** This bug has been marked as a duplicate of bug 40359 ***
Comment 16 Roman Eisele 2012-04-17 07:32:44 UTC
[REPRODUCED] this (or a very similar bug) on MacOS X 10.6.8 German with the
current master build: LOmaster 3.6.0alpha0+, Build ID: 55823d3 (installation
file: master~2012-04-14_05.23.05_LibO-Dev_3.6.0alpha0_MacOS_x86_install_en-US.dmg).

All circumstances are very similar to bug 40359, and the report created by MacOS X for the crash (I will attach it) is nearly identical to the one created for bug 40359.

What I did:
1) Download the current master build (see above) and the US English langpack.
2) Delete any previous LibreOffice/LOdev installation.
3) Install the current release and, immediately after that, install the US
English langpack.
   NB: Do NOT install any additional dictionaries, extensions, etc.
4) Delete any LibreOffice related stuff (settings etc.) in
~/Library/Application Support/LOdev/ (the complete folder) and in
~/Libray/Preferences/ (I found two files with names starting with
org.libreoffice...).
5) Start LOdev.app
6) In the Start centre, select 'Spreadsheet'.
7) An empty spreadsheet appears; select cell A1.
8) Select 'Format > Cell ...'
9) The dialog appears; all dialog panes are accessible, everything seems OK.
10) Click 'OK' (without changing anything).
11) Quit LOdev. Note that the folder at ~/Library/Application Support/LOdev/ is
created again.
12) Start LOdev.app, the 2nd time now.
13) In the Start centre, select 'Spreadsheet' again.
14) An empty spreadsheet appears; select cell A1.
15) Select 'Format > Cell ...', the 2nd time now.
16) Expeced: eveything should be like in Step 9.
    Result: Depending on the fact which pane was open when you closed the dialog the last time, LOdev will either crash immediately (if you had selected the 2nd pane, 'Font'), or it will CRASH as soon as you click on 'Font' to open the 2nd pane of the dialog.

I can repeat steps 4 to 12 again and again:
Everytime I delete the complete folder at ~/Library/Application Support/LOdev/
first, LOdev will show the 'Font' pane of the Format Cell dialog again, but if then I quit and restart LOdev and try to access the 'Font' pane of the Format Cell dialog once more, LOdev crashes again.

From the similarity with bug 40359, I conclude that the problem is not within the font selection controls on the 'Font' pane, but in the 'Language' popup menu at the bottom of the 'Font' pane: this popup menu is involved both in bug 40359 and in this present bug.

This is either the same or a new, but very similar bug. I did not notice this
behaviour before with LibreOffice on MacOS X. Either there has something
changed in Master (then this would be a new, but very similar bug), or the
reason may be related to the fact that this time I have only installed the US
English help pack, no German or other help pack, and that the Language of the
user interface is still US English, while the OS language is German ...
Comment 17 Roman Eisele 2012-04-17 07:35:59 UTC
Created attachment 60170 [details]
MacOS X log file generated on crash when accessing Format>Cell...>Font a 2nd time
Comment 18 Roman Eisele 2012-04-17 07:42:19 UTC
To avoid misunderstandings: in comment #16, I talked about the 'panes' of a dialog window, but a more appropriate term would be 'tab' (according to http://en.wikipedia.org/wiki/Tab_%28GUI%29). Sorry for my incomplete knowledge of English GUI terms!
Comment 19 Roman Eisele 2012-04-21 11:06:18 UTC
When I wrote about how I reproduced this bug with a Master build (comment #16), I had the hope that the crash I got by the given steps was not another bug newly introduced into Master, but that some change in the codebase had made it easier to reproduce this bug for me and that the MacOS X log file for the crash I attached to this bug report would be of some help to track down this annoying bug.

But now I have tested this issue again with a newer Master build: LOdev 3.6.0alpha0+, Build ID: 503c8fd (installation file: master~2012-04-20_00.38.41_LibO-Dev_3.6.0alpha0_MacOS_x86_install_en-US.dmg), again on MacOS X 10.6.8. And -- the bug is gone for me: I don't get a crash anymore, I can view and change the Language Settings as expected again. The same is true for bug 40359, which is identical with (or related to) the present bug.

So I think that probably the crash I could reproduce so easily in the Master build dated 2012-04-14 was not the long standing issue this report is talking about, even if everything looked the same way and all circumstances were identical, but that I just triggered some new instability which raised in the Master codebase and now has gone away again. On the one hand, this is good (because Master builds are now much more easy to use and test again for me), on the other hand, this is bad, because I may have distracted your attention from more important problems. I am sorry for any inconvenience this may have cause to you.