Description: Undo of deleting a row exceptional slow compared to (insert/delete/ or reject delete row) Steps to Reproduce: 1. Open attachment 161647 [details] 2. Copy column A-C 3. Paste it always next the other, so DEF GHI KLM NOP (needed to feel the performance degradation; so create more if you want to wait longer.. less if you want to wait sorter.. 4. Insert a row -> 3 seconds -> create more columns; not really difference 5. Delete the row -> 7 seconds -> This tends to decrease with more columns 6. Undo the delete of a column -> 10 seconds -> This tends to decrease with more columns 7. Now repeat step 4/5 with tracking changes * Inserting 2 seconds (faster?) * Deleting 5 seconds (faster) * Manage track changes reject -> 6 seconds Note replace rows for columns.. and the idea is the same Actual Results: delete and undo slow compared to insertion and in comparison with tracking changes enabled Expected Results: Equal to tracking changes enabled..and maybe even optimize tracking changes delete/reject (also showing the 'same' speed decrease trend. Does needs a double the amount of column to be annoying; again some quadratic decrease.. only starting with a lower number?) Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.0.0.alpha0+ (x64) Build ID: aadcd6f90916bd2b9734ae793141d0c77cc5b46c CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL and in 4.0.0.3 (4.2 and 4.4.7.2).. Did check 5.0 - 7.1.
Interesting .. no delay when inserting/deleting a row in Linux with 4.2 (started with 4.3)
Created attachment 162406 [details] Bibisect log Bisected to telesto@telesto-VirtualBox:~/bibisect-43max$ git bisect good 592049de352d2fd0fe256fe499a2edd175c2bb0b is the first bad commit commit 592049de352d2fd0fe256fe499a2edd175c2bb0b Author: Matthew Francis <mjay.francis@gmail.com> Date: Thu May 28 19:46:09 2015 +0800 source-hash-f32df2d590d0ee14f09664934457ba9e8de8cbe6 commit f32df2d590d0ee14f09664934457ba9e8de8cbe6 Author: Kohei Yoshida <kohei.yoshida@collabora.com> AuthorDate: Fri Feb 28 21:25:01 2014 -0500 Commit: Kohei Yoshida <kohei.yoshida@collabora.com> CommitDate: Fri Feb 28 21:28:57 2014 -0500 fdo#75053: Adjust reference update on shift for formula groups. This is similar to my earlier fix for reference update on moving of cells. Change-Id: I592599507bfcab12f611eeae7b56c99da6c31919
Moving 4/5 to a separate bug 134301
*** Bug 134301 has been marked as a duplicate of this bug. ***
(In reply to Telesto from comment #0) > Description: > Undo of deleting a row exceptional slow compared to (insert/delete/ or > reject delete row) > > Steps to Reproduce: > 1. Open attachment 161647 [details] > 2. Copy column A-C > 3. Paste it always next the other, so DEF GHI KLM NOP (needed to feel the > performance degradation; so create more if you want to wait longer.. less if > you want to wait sorter.. > 4. Insert a row -> 3 seconds -> create more columns; not really difference Insert a row where? top? middle? bottom?
Dear Telesto, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Telesto, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp
(In reply to Xisco Faulí from comment #5) > Insert a row where? top? middle? bottom? Doesn't matter, some in the middle
Hi Telesto, Could you please try again in a master build after https://cgit.freedesktop.org/libreoffice/core/commit/?id=b9921adae997579915b4600c688719620f9adaf6 ?
Undo is still slow Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 385808a2dff7300ec0120fdd5e8acfad8f86e50d CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL I would say bug 134301 got fixed, but not this one
(In reply to Telesto from comment #10) > Undo is still slow > Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: 385808a2dff7300ec0120fdd5e8acfad8f86e50d > CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win > Locale: nl-NL (nl_NL); UI: en-US > Calc: CL > > I would say bug 134301 got fixed, but not this one Actually everything still the same as comment 0
Undo took 8 secs Rejecting took 2,5 secs I deleted a random row, not the one that I inserted. Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 04f9a8957c04b8c5abaa58140328d2c83381f4ff CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded Jumbo
Dear Telesto, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug