Description: A spreadsheet with alternating blank rows makes many column and area mark operations slow. Steps to Reproduce: New spreadsheet Create solid block of A from A1 to N32000 Place "A" in A1. Select A1. Copy to clipboard. Mark A1:N32000, paste, yes to overwrite. Note the fast paste. Select each column individually A then B then C.. to N. Note the fast response. Fast response is expected behavior. Close all, new spreadsheet. Create block of A from A1 to N32000 with all even lines blank. Place "A" in A1, leave A2 blank. Select A1-A2, copy to clipboard. Select A1:N32000, paste, yes to overwrite. Note slow paste. Mark each column as before. Note slow response. Slow response is unexpected behavior. Close all, new spreadsheet. Create solid block of A from A1 to N32000 Change column A so it is blank every other row. Mark column A is slow. Marking all other columns is fast. Actual Results: See above. Expected Results: See above. Reproducible: Always User Profile Reset: No. It happens on multiple computers. Additional Info: This is likely to affect blank every other column but that has not been tested. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:55.0) Gecko/20100101 Firefox/55.0
(In reply to Chris Severance from comment #0) > Change column A so it is blank every other row. How do I do this automatically?
The 3rd test is a combination of the first two. The instructions for the second test can blank every other row in the entire block or just the first column. The idea is to show that only the columns with every other row blank are slow. Nearby full columns are fast. ... Change column A so it is blank every other row. Delete the value in A2 Select A1-A2, copy to clipboard. Select A1:A32000, paste, yes to overwrite.
Ok, sorry, I was tired.. I do repro the second case, but in the 3rd case, clicking the column name results in it being selected just as fast in A. Interestingly, it is a regression as in 3.6 the pasting is fast. Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha0+ Build ID: a27eb931c22313d4dd5c73b35358c0532d20b79e CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on September 8th 2017 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
In 5.4.1.2.0 (5.4.1-1) the slow column marking for test 2 and 3 have been fixed. The slow paste continues.
For testers like me, who are not Calc power users: selecting the big block is easy by just typing/pasting A1:N32000 into the cell name box (above the row/column corner in the left).
Regression introduced in range https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=c7bdee8dbd1cf260a8513a0d31b36f90daa70f1c..4c99a427ee4adaeddb2682c192384bad21d9d09b
** Please read this message in its entirety before responding ** 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 http://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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
slow pasting two values (one cell with value and another cell is empty) in to range A1:O32000 still repro in Version: 6.1.1.2 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: ru-RU (ru_RU); Calc: CL
Looks like the root cause for this and tdf#120558 seems the same. I'm looking into this.
Another variant of a testcase is following the instructions, but setting A2 to "ABC" instead of leaving it empty. Internally different and a bit harder to fix.
Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/5d5e308331e7166726264c43545798b5fb833c8a%5E%21 cache mdds positions also in CopyTextAttrsFromClipHandler (tdf#112000) 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/+/b81004e95638da19cbcaa7a61f9edd094a9eac31%5E%21 cache mdds positions during ScDocument::CopyBlockFromClip() (tdf#112000) 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.
*** Bug 120558 has been marked as a duplicate of this bug. ***
Verified in Version: 6.3.0.0.alpha1+ Build ID: 9c7fac47aacb0877c7d212217089a680400c1377 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 issue!!