Calc crashes on editing cell names (v 4.2.0.4) [closed]

asked 2014-02-09 11:38:29 +0200

Msebas gravatar image

updated 2015-09-07 20:51:26 +0200

Alex Kemp gravatar image

Whenever I try to edit a cell name via the range indicator, libreoffice automatically crashes. I also tried using the name menu (ctrl+f3), but again, the program crashes when I press "ok".

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-21 12:39:56.391676

Comments

Hi @Msebas, I can't reproduce the issue, this happen also with a file from scratch?, in this case please try resetting the user profile. https://wiki.documentfoundation.org/UserProfile

m.a.riosv gravatar imagem.a.riosv ( 2014-02-09 18:46:20 +0200 )edit

Hi. No, it's quite a complex file in fact, but it's the first time it happened. I try resetting the user profile and keep having the same problem. I'm using Ubuntu 12.04 if it helps noting.

EDIT: I have two user folders (libreoffice> 3 and 4). I had backuped and deleted the user folder on the "4" folder. Now I repeated the user profile reset procedure on BOTH folders, and the problem seems to be solved.

Msebas gravatar imageMsebas ( 2014-02-09 20:21:56 +0200 )edit

I had the same problem with a complex workbook. It makes substantial use of conditional formatting (I switched from LibreOffice 4.1 to 4.2 because conditional formatting is quite broken in the latter). Resetting my profile, i.e., renaming the 'user' directory to 'user.bkup' while no LibreOffice processes are running, seems to have solved the problem.

Hugh gravatar imageHugh ( 2014-02-13 18:16:08 +0200 )edit

Please could you report the issue in https://www.libreoffice.org/get-help/bug/ , add a sample file would be very useful.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-13 22:47:50 +0200 )edit

I'm getting this bug as well; it seems like a regression of https://bugs.freedesktop.org/show_bug.cgi?id=40909

jorgeegomez gravatar imagejorgeegomez ( 2014-03-04 07:45:48 +0200 )edit

Same problem for me on two different computers with two different versions of Ubuntu (12.04 and 13.10) and LibreOffice 4.2.0.4.
The issue does not occur when I create a new calc file and define a set of cell names. However when I save the file and reopen it for editing I cannot manage cell names any longer. For instance, if I move a named cell to a new position the name remains linked to the old cell (this didn't happen in previous versions of Calc I used). Then if I try to use the "manage" command to reconnect the name with the new cell, Calc crashes as described in the previous comments. I've tried to rename the 'user' directories but the problem survives.

massimo m gravatar imagemassimo m ( 2014-03-31 09:16:28 +0200 )edit

Same issue, Linux version 4.2.3.2. I have a complex spreadsheet in which any use of "Manage Names" now crashes the spreadsheet. Restting the ~/.config/libreoffice/4/user folder did not prevent the crashes in my case, unfortunately.

drs305 gravatar imagedrs305 ( 2014-04-06 14:09:38 +0200 )edit

Sorry to chime in just to say "me too", but I'm registering the same issue on LO 4.2.2.1 on Mac OS X 10.6.8. Resetting my profile didn't change anything, unfortunately.

Allanon gravatar imageAllanon ( 2014-04-27 10:56:26 +0200 )edit

Seems as fdo#75741 is related to, that has been resolved a couple of weeks ago.

m.a.riosv gravatar imagem.a.riosv ( 2014-04-27 12:07:46 +0200 )edit