User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0 Build Identifier: 416eb656da5ecf82e4386bbffc7c843f6d065b3f Freeze when doing Crtl + Z on large spreadsheet with concatenation Reproducible: Always Steps to Reproduce: 1. Open attachment 121732 [details] 2. Right-click on the header of column B. 3. In the pop-up menu select "Insert Columns Left". 4. Type Crtl + Z Actual Results: Libreoffice freezes and the app needs to be killed Expected Results: Action is performed eventually Adding keyword 'wantBacktrace' Reset User Profile?No
Repro, but I am unable to get a bt. It crashes on some Java thing, if run with --backtrace and if I try to attach gdb to it later, it somehow does not work. Arch Linux 64-bit, KDE Plasma 5 Version: 5.3.0.0.alpha0+ Build ID: ff2a399b61f34f7920e594e8cbb6c19045b24956 CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on October 7th 2016
Created attachment 128118 [details] Backtrace of hang with WinDbg Here's a backtrace, taken with WinDbg. Version: 5.3.0.0.alpha0+ Build ID: ab03287ae182c4fadebe257aa5da5257bd5b7c2e CPU Threads: 4; OS Version: Windows 6.1; UI Render: GL; Locale: hu-HU (hu_HU); Calc: group
Created attachment 128133 [details] Another backtrace with WinDbg showing sclo.dll on fileopen
Created attachment 128134 [details] Another backtrace from procdump on column insert
This file is abnormally slow, it has dumps even before freeze. I tried to run Dr.Memory but ran out of memory. Valgrind? Aron: "OS (WOW64 kernel32) symbols are WRONG. Please fix symbols to do analysis."
@Kohei: you might be interested in this.. the cause seems to be that on Undo for each and every formula cell the whole range (entire column) is ungrouped and then regrouped just to be ungrouped and regrouped for the next cell.. eventually this might even succeed after a day or so.
Also in Versie: 4.1.0.4 Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace2 but not in Versie 4.0.0.3 (Bouw-id: 7545bee9c2a0782548772a21bc84a9dcc583b89)
Curious as to why this is suddenly critical; ? =)
(In reply to Michael Meeks from comment #8) > Curious as to why this is suddenly critical; ? =) "since 2016" is not suddenly :) It is critical because of the effect "Libreoffice freezes and the app needs to be killed". That is what severity describes, the badness of the effect. Priority was left as medium because this is a rarer workflow.
Bibisected on Ubuntu 14.04 with 43all to range https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=923312f67fbf120158f01c2c0e588af38fc22364...a2c34b3d9ac2d7e43e52846308cc63447fd51f23 Might be from this extensive commit and the ones related to it: https://cgit.freedesktop.org/libreoffice/core/commit/?id=59f38babd074cc0b835a5d2a1c81af013dba0deb Remove broadcaster from ScBaseCell, remove ScNoteCell and CELLTYPE_NOTE... and Calc is now officially broken. Let's start fixing this bit by bit...
Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/a3fb726f4972c5a869e778353c8c1c19f149c5ea%5E%21 optimize expensive EndListener() calls (tdf#102364) It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/169a1b542165f3444791fd6e672d56d3fe48bd66%5E%21 avoid possible expensive repetitive formula group changes (tdf#102364) It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This should be fixed now.
Verified in Version: 6.3.0.0.alpha0+ Build ID: 78073ecfdc50e78e3ce094c1259779b7c3b88bc4 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Luboš Luňák, thanks for fixing this!! Should it be cherry-picked to 6-2 branch ???