Created attachment 77202 [details] an example spreadsheet Problem description: bug initially reported in the ArchLinux bugtracker: https://bugs.archlinux.org/task/34498 if I try to expand a cell with "Err:520", calc crashes I'm on Arch Linux x86_64 with libreoffice-4.0.1.2 BUT with libreoffice-4.0.1.2 in Windows XP (32bit) everything work: cells not showing me "Err:520" but the right result since the cells contain the right formula. Steps to reproduce: 1. open the attached file 2. try to expand a cell showing "Err:520" e.g.: F15 3. calc crashes with the above output Operating System: Linux (Other) Version: 4.0.1.2 release
I found that if I try to expand any cell calc crashes with the same error!
libreoffice is becoming a fiend: 1. open calc 2. start to write a formula (namely type '=') in any cell and calc crashes
On pc Debian x86-64 with master sources updated today, I opened the attached Calc file, there were no Err:520 cell. Then I increased row height and column witdh, no crash. mattia.b89: Could you rename your LO directory profile and give it a new try? (https://wiki.documentfoundation.org/UserProfile) Do you reproduce this on a brand new file?
Due to hardware failure i can't test it. When my PC will be ok, I'll test it.
with 4.0.2 I have the issue; removing my $HOME/.config/libreoffice I have the issue;
with latest release 4.0.3.3 there is a little enhancement: now cells show me correctly the values of formulas, that is it doesn't show me "Err:520" but if I try to expand it I get the same crash
with latest release 4.0.3.3 there is a little improvement: now cells show me correctly the values of formulas, that is it doesn't show me "Err:520" but if I try to expand it I get the same crash
Joren: would you have some time to give it a try? I hadn't been able to reproduce, perhaps you'll be more lucky :-)
(In reply to comment #8) > Joren: would you have some time to give it a try? I hadn't been able to > reproduce, perhaps you'll be more lucky :-) tell me what I can do
mattia.b89: since I don't reproduce this, I wanted to know if I miss something obvious or not ; so I asked to Joren (who's doing a lot of QA) BTW, when you say "expand", you mean increase row height or column width or something else?
(In reply to comment #10) > mattia.b89: since I don't reproduce this, I wanted to know if I miss > something obvious or not ; so I asked to Joren (who's doing a lot of QA) > BTW, when you say "expand", you mean increase row height or column width or > something else? no, with "expand" I mean double click on the cell for editing the formula to be more precise: -PREVIOUSLY expanding a cell do LO to crash -NOW first time I expand a cell LO make me edit the formula (LO works). the second time I try to expand a cell (the previous expanded OR any other cell in the sheet) LO crashes
Hi, (In reply to comment #2) > libreoffice is becoming a fiend: > > 1. open calc > 2. start to write a formula (namely type '=') in any cell and calc crashes Mmh, looks very familiar too me. There are recently a lot of errors with that. Not due LibreOffice itself, but due extensions attached to LibreOffice You have some extensions installed? If yes, can you please disable them? If still reproducible, please reset (rename) your user profile (guide: https://wiki.documentfoundation.org/UserProfile#Resetting_the_user_profile). If the user rename resolved the problem (or didn't), is it possible to zip your user profile and send it to me? In that case 1) I'll try to determine which thing crashes LibreOffice. I fail to reproduce this behavior by myself (tested using Linux Mint 14 x64 with LibreOffice 4.0.3.3 and master version (5441e509f87c96ca36913bd443152adbb8ad2c9)) kind regards, Joren
(In reply to comment #12) > Hi, > > (In reply to comment #2) > > libreoffice is becoming a fiend: > > > > 1. open calc > > 2. start to write a formula (namely type '=') in any cell and calc crashes > > Mmh, looks very familiar too me. There are recently a lot of errors with > that. Not due LibreOffice itself, but due extensions attached to LibreOffice > You have some extensions installed? If yes, can you please disable them? If > still reproducible, please reset (rename) your user profile (guide: > https://wiki.documentfoundation.org/UserProfile#Resetting_the_user_profile). > > If the user rename resolved the problem (or didn't), is it possible to zip > your user profile and send it to me? In that case 1) I'll try to determine > which thing crashes LibreOffice. > > I fail to reproduce this behavior by myself (tested using Linux Mint 14 x64 > with LibreOffice 4.0.3.3 and master version > (5441e509f87c96ca36913bd443152adbb8ad2c9)) > > kind regards, > Joren how can I disable the extensions???
(In reply to comment #13) > how can I disable the extensions??? Please do not quote my whole answer. That creates a lot of unnecessary noise and makes your reply really long. I'm sorry I didn't provide steps. My bad. * Open LibreOffice * Tools > Extension Manager ... But I think you only can delete non-default extensions there (so the default extensions can't be deleted in that way). But I recommend to reset your user profile right away. It isn't likely that you installed an extension if you don't know where you can manage them (don't understand me wrong :-) ). So, can you please reset your user profile (https://wiki.documentfoundation.org/UserProfile#Resetting_the_user_profile)? Thanks, Joren
removed these extensions: libreoffice-extension-presentation-minimizer libreoffice-extension-nlpsolver with no luck! renamed profile directory no luck, too! I attach the compressed folders
Created attachment 79139 [details] profile directory
Thanks for your extra information. I still fail to reproduce your behavior, even with your user profile. Therefore it's 99% sure this is LibreOffice related (in combination with your OS). Is it possible for you to upgrade to the latest 4.0.3.3 which you can download here: http://www.libreoffice.org/download and a guide to install it: http://www.libreoffice.org/get-help/installation/linux/ ? Kind regards, Joren
I have already the latest stable version (4.0.3.3) installed through archlinux package manager (pacman) how to see what do LO to crash ???
Mattia: just follow https://wiki.documentfoundation.org/BugReport#How_to_get_a_backtrace_on_Linux
ok, I do: soffice --backtrace gdbtrace.log attached and soffice --strace strace.log compressed and attached
Created attachment 79163 [details] gdbtrace log
Created attachment 79164 [details] strace compressed log
ok, I do: gdbtrace.log attached and strace.log compressed and attached both with the following actions: soffice --backtrace click on down arrow beside "open..." button click on the first item of the list (the attached .xlsx file) click on E14 cell double click on E14 cell press enter double click on E14 cell LO crashes the same with soffice --strace
mattia: What's the version of the extension NumberText? You'll find 0.9.5 here http://extensions.libreoffice.org/extension-center/numbertext-1
I have 0.9.4 version; I'll report to archlinux bugtracker and when they update the package I'll test again the issue
mattia: for the test, you can uninstall NumberText 0.9.4 and install 0.9.5. Whatever the result, you'll have extra information to provide for your Arch bugtracker.
with latest official release 4.0.3.3 (which provides the latest numbertext version, too) THE BUG WAS SOLVED I'm not sure if it was definitively a numbertext problem or other... thank you for the support!
(In reply to comment #27) > I'm not sure if it was definitively a numbertext problem or other... > > thank you for the support! You're welcome :). Thank you for your feedback. Let's mark this bug as RESOLVED WORKSFORME then :)