Windows 7 64 bits LO 3.6.3.2 and LO 3.6.4.0+ (Build ID: 08ca08d) I have a spreadsheet and when i have change a cel the calculation in LO is +/- 1 min 10s. When i use Excel the calculation is 1 sec! The sheet isn't used for public.
I have check on windows 7 64 bits LO 3.5.7 There is the calculation normal with 1 sec.
Can you attach a sample file? First please remember delete any confidential information, it will have public access.
I attach a file and you do the next for see the issue: Go to cel "EN 1993_1_1" D80 and delete the value, than the calculation is slow. Or change the cel "EN 1993_1_1" B87 too value 2000 and is too slow.
Created attachment 69980 [details] File where the calculation is slow in 3.6.3.2
Confirmed Win 7x64 Ultimate Version 3.6.3.2 (Build ID: 58f22d5) Version 3.7.0.0.alpha0+ (Build ID: 52a7a8) MinGW Removing all conditional formatting, seems to eliminate the problem. I have not could find out if a specific condition is the source of the problem. Maybe a problem similar to my bug report: https://bugs.freedesktop.org/show_bug.cgi?id=49764 [EDITING] Conditional formatting make very slow introduce data in cells with conditional formatting. (RESOLVED FIXED) But now, EN 1993_1_1.D80 has no conditional formatting.
Win 7x64 Ultimate I3-4GB LibreOffice Version 3.6.3.2 (Build ID: 58f22d5) Steps: - Opening attached file. - Recalc | hard recalc: 2 seconds. - Delete cell EN_1993_1_1.D80: 140 seconds. - Recalc | hard recalc: 2 seconds. - Enter -10 in cell EN_1993_1_1.D80: 135 seconds. - Delete cell EN_1993_1_1.D80: 1 seconds. - Recalc | hard recalc: 2 seconds. - Enter -10 in cell EN_1993_1_1.D80: 135 seconds. - Deleting all conditional format in EN_1193_1_1. - Recalc | hard recalc: 2 seconds. - Delete cell EN_1993_1_1.D80: 1 seconds. - Recalc | hard recalc: 2 seconds. - Enter -10 in cell EN_1993_1_1.D80: 1 seconds. The issue is not there with LibreOffice 3.3.4.
The issue is not there with LibreOffice 3.5.7.2 The issue is also there with LO master 4.0.0.0 alfa0.
(In reply to comment #5) > Confirmed > Win 7x64 Ultimate > Version 3.6.3.2 (Build ID: 58f22d5) > Version 3.7.0.0.alpha0+ (Build ID: 52a7a8) MinGW > > Removing all conditional formatting, seems to eliminate the problem. > > I have not could find out if a specific condition is the source of the > problem. > > Maybe a problem similar to my bug report: > https://bugs.freedesktop.org/show_bug.cgi?id=49764 > [EDITING] Conditional formatting make very slow introduce data in cells with > conditional formatting. (RESOLVED FIXED) > > But now, EN 1993_1_1.D80 has no conditional formatting. In the sheet there is much conditional formatting in other cells. Is this the problem and how it is solve the problem?
" Markus Mohrhard changed bug 57028 What Removed Added Keywords regression You are receiving this mail because: You are on the CC list for the bug. " Please, could you explain why the key "regression" was deleted?. As @vlb has indicated: The issue is not there with LibreOffice 3.5.7.2 The issue is there with LibreOffice 3.6.3.2 The issue is there with LO master 3.7.0.0 alfa0. And as I have verified: The issue is there with LibreOffice 3.6.4.1 The issue is there with LO master 4.0.0.0 alfa1.
Because it is a performance issue which we (the calc team) track with the pref keyword. This makes it possible for us to keep track of different bugs.
I can confirm this issue in LO Versie 4.0.0.0.beta1 (Bouw-id: 87906242e87d3ddb2ba9827818f2d1416d80cc7)on windows 7 64 bits.
4.0 beta1 (sorry, not yet installed beta2) on Linux freezes.. @markus: When openend in 3.5.7, I see there are a lot of excel_condit_formatting# styles. Could be related ? (Preformance issues are bad - so I take the freedom to promote to major..)
http://cgit.freedesktop.org/libreoffice/core/commit/?id=7c528f40e0aea9386d175b007974c02d265f96c6 fixes the problem now. *** This bug has been marked as a duplicate of bug 57896 ***
I observed similar behavior after an upgrade from 3.5.7 to 3.6.4.3 (Dutch) and posted a bug report: https://bugs.freedesktop.org/show_bug.cgi?id=58835. It turns out this is another duplicate of this same bug. Version 4.0.0.0.beta2 had the same issue. My question is if you can incorporate the above solution in version 3.6.4.4 or 3.6.5? It is quite an annoying bug and withholds me from upgrading. Thanks in advance.
(In reply to comment #14) > I observed similar behavior after an upgrade from 3.5.7 to 3.6.4.3 (Dutch) > and posted a bug report: https://bugs.freedesktop.org/show_bug.cgi?id=58835. > It turns out this is another duplicate of this same bug. Version > 4.0.0.0.beta2 had the same issue. See issue 57896 is solved later than versie 4.0 beta 2, i have check in the nightly builds http://dev-builds.libreoffice.org/daily/ and there it is solved the bug. > My question is if you can incorporate the above solution in version 3.6.4.4 > or 3.6.5? It is quite an annoying bug and withholds me from upgrading. > Thanks in advance. I hope too that this issue solve for 3.6.5, do not upgrade to 3.6.4 it is bad!
*** Bug 58835 has been marked as a duplicate of this bug. ***
Migrating Whiteboard tags to Keywords: (perf) [NinjaEdit]