Description: LibreOffice hangs when pasting a large 'Ctrl-c' selected cell range into formula. The paste is interpreted as text and not a cell range. Steps to Reproduce: 1. Fill a column with lots of data. Autofill a column with 1 2 3 4 ... 10000 works. 2. Select all the cells, and copy them with Ctrl+C 3. Select a new cell, and write "=sum(" then do a 'Ctrl+v'. Actual Results: Hangs forever at 100% CPU. Expected Results: Cell should either contain "=sum(A1:A10000", return an error, warn that this operation will be bad, function like now but be interruptible. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 149606 [details] screenshot pasting data into sum formula can not reproduce thsi with: Version: 6.1.5.2 (x64) Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc:
Created attachment 149652 [details] screenshot pre pasting data into sum formula in a cell
Created attachment 149653 [details] screenshot post pasting data into sum formula in a cell
Updated to version 6.1.5.2 and the bug can still be found. However it is context sensitive depending on cursor location when the paste is performed. If the paste is performed with the cursor in the input line at the top no excessive time is spent, matching the result in attachment 149606 [details]. However, if a cell is active with the cursor inside the time spent seems O(N²) or worse. Screenshot before pasting attachment 149652 [details], and after pasting 300 numbers attachment 149653 [details]. A selection of 300 numbers hangs for 10+ seconds, and 500 hangs for 1+ minutes, 1000 hangs forever. Version: 6.1.5.2 Build ID: 1:6.1.5~rc2-0ubuntu0.16.04.1~lo3 CPU threads: 12; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group threaded
Clarification: With cursor I mean the text cursor or caret, not the mouse poiner.
not reproducible for me, after pasting data, formula cell changes to Err:509 immediatelly, linux only?
To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
I have reset my user profile (renamed the folder). The bug did not change. User Profile Reset: Yes Version: 6.1.5.2 Build ID: 1:6.1.5~rc2-0ubuntu0.16.04.1~lo3 CPU threads: 12; OS: Linux 4.15; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group threaded Sorry had to make a new account.
No repro with Version: 6.3.0.0.alpha0+ Build ID: 83abdf803a023067ebc207fd82dde987df233754 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Err:512
I do repro in Linux and I don't in Windows. As noted, Linux hangs while Windows gives Err:512. But there might be another approach to this: not to paste at all in formula if clipboard format not appropriate. That's how MSO works.
Dear hisfy1nfgi2uf2v, 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://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
Dear hisfy1nfgi2uf2v, 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