[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #11 from [email protected] --- If I recall correctly, when I encountered this ( https://bugs.documentfoundation.org/show_bug.cgi?id=166089#c3 ), the indicated code called libcairo. Since it appears that the bug is sensitive to the environment, maybe the bug is actually in libcairo or a related library. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #10 from dhagen --- (In reply to ady from comment #9) > For those having this problem, just wondering... > > A._ Are there any clipboard managers in your OS/DE (perhaps included as part > of some other tool within the OS/DE)? > > B._ How exactly are you copying the range to the clipboard? > B.1._ By [CTRL]+[C] > B.2._ By [CTRL]+[INSERT] > B.3._ By menu Edit > Copy > B.4._ By context menu > Copy > > Please test with each of the alternatives. > > > C._ Have you tried performing the "copy" action twice consecutively? > That is, for example, pressing [CTRL]+[C] twice (not once), before pasting. > > Please test with each of the alternatives. > > D._ After pasting, have you tried scrolling down/up the worksheet (at least > 2 pages down and then up), so as to trigger some screen refresh? > > E._ How exactly are you pasting the range from the clipboard? > E.1._ By [CTRL]+[V] > E.2._ By [SHIFT]+[INSERT] > E.3._ By menu Edit > Paste > E.4._ By context menu > Paste > E.5._ By mouse middle button > > Please test with each of the alternatives. > > > Please report back all your findings. Here is my report: A. I did not have any clipboard managers installed in my Debian 13 installation (the problematic one). I verified this through a search in Synaptic which found a number of clipboard managers (such as CopyQ, GPaste, and Diodon), none of which were installed. It occurred to me that installing a clipboard manager might provide a workaround to my problem, and so after all else failed I installed CopyQ. This does in fact provide a partial solution by using the clipboard manager as an intermediary. Here is how CopyQ provides a workaround: - I installed and ran CopyQ. - I opened LibreOffice Calc 26.2.2.2 and copied 1500 rows of data; the data is sent to the clipboard and is recognized by CopyQ (but not by Calc, which insists that the clipboard is empty--all paste options are grayed out). - The 1500 rows of data can then be pasted directly in Calc, but ONLY by using the middle mouse button. None of the other paste functions work. Moreover, the middle mouse button did NOT work before installing CopyQ. -the data can also be pasted by opening CopyQ and clicking on the Activate Item button (when the copied data is selected). All paste functions in Calc then work as expected, and the full 1500 rows can be pasted using CTRl-C or the various paste menus, none of which are grayed out. But this approach involves extra steps, as I have to open CopyQ, and the data from CopyQ is treated as unformatted text, so the Text Input dialog has to be used to format the data. I also tried Diodon, but the middle-mouse-button shortcut did not work; I had to open Diodon and activate the clipped data to paste it back into Calc. CopyQ provides the superior workaround. B. I tried all of your listed approaches to copying the data. None of them worked (when the number of rows exceeds 1212), regardless of the Paste method used. In each case Calc seems to think that the clipboard is empty, because all of the Paste menus are grayed out. But the clipboard is NOT empty (as demonstrated by my experiment with CopyQ). C. Copying twice did not solve the issue. The Paste menus are still grayed out, none of the the keyboard shortcuts work, and the middle mouse button does not work (unless I install and run CopyQ, as explained above in A). D. Scrolling up and down does not work. It does not seem to be a display issue. Calc seems to think that the clipboard is empty, so it will not activate the paste function. There is nothing to see because nothing was pasted. E. None of the listed paste methods work UNLESS I install and run CopyQ, in which case the middle-mouse-button works (but none of the other paste methods work). Alternatively, as explained above, if I activate the data from within the CopyQ program ALL of the paste methods work, but the data from CopyQ is treated as unformatted text, so the Text Input dialog is activated. As I stated in a previous post, NONE of the above applies when using the EXACT SAME BUILD of LibreOffice in Ubuntu 24.04 (with Xfce/X11 in both cases). Copy and paste works exactly as it should in Ubuntu. Copy and paste also works exactly as it should in my Debian 13.4 installation IF the number of rows does not exceed 1212, or if I use an older version of LibreOffice Calc when the number of rows exceeds 1212. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #9 from ady --- For those having this problem, just wondering... A._ Are there any clipboard managers in your OS/DE (perhaps included as part of some other tool within the OS/DE)? B._ How exactly are you copying the range to the clipboard? B.1._ By [CTRL]+[C] B.2._ By [CTRL]+[INSERT] B.3._ By menu Edit > Copy B.4._ By context menu > Copy Please test with each of the alternatives. C._ Have you tried performing the "copy" action twice consecutively? That is, for example, pressing [CTRL]+[C] twice (not once), before pasting. Please test with each of the alternatives. D._ After pasting, have you tried scrolling down/up the worksheet (at least 2 pages down and then up), so as to trigger some screen refresh? E._ How exactly are you pasting the range from the clipboard? E.1._ By [CTRL]+[V] E.2._ By [SHIFT]+[INSERT] E.3._ By menu Edit > Paste E.4._ By context menu > Paste E.5._ By mouse middle button Please test with each of the alternatives. Please report back all your findings. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #8 from dhagen --- (In reply to Mateusz Wlazłowski from comment #7) > (In reply to dhagen from comment #6) > > I was able to reproduce this bug in 26.2.2.2 (Linux), including in SAFE > > MODE. The only difference is that I am limited 1212 rows. Here are the > > version details: > > > > Version: 26.2.2.2 (X86_64) > > Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5 > > CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3 > > Locale: en-US (en_US.UTF-8); UI: en-US > > Calc: threaded > > > > Here are some other details about my system: > > Machine Type : Desktop > > Processor : AMD Ryzen 7 5800XT > > Memory : 32793MB > > Operating System : Debian GNU/Linux 13.4 > > > > I was also able to reproduce the bug in 24.2.7.2. > > The bug did NOT exist in 7.4.7.2, so it seems to have been introduced > > somewhere between these two versions. > > Could you bibisect the bug ? Thanks > > https://wiki.documentfoundation.org/QA/Bibisect I have not yet figured out how to bibisect the bug, but in trying different versions I have found a very surprising result: Using EXACTLY the same build of LibreOffice I have found that the bug exists in Debian 13 but NOT in Ubuntu 24.04 (in both cases on the same computer). To keep the LibreOffice installations as similar as possible I installed the same flatpak version in both cases. Here are the version details: (1) DEBIAN 13.4 Stable (Xfce) LibreOffice Version: 26.2.2.2 (X86_64) Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5 CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded RESULT: The bug is reproduced. I am limited to 1212 rows. (2) UBUNTU 24.04.4 LTS (Xfce) LibreOffice Version: 26.2.2.2 (X86_64) Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5 CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded RESULT: The bug is NOT reproduced. I can copy and paste tens of thousands of rows. Note that the LibreOffice build IDs are identical, the ONLY difference being the Linux version. In short, 26.2.2.2 works fine in Ubuntu 24.04, but not in Debian 13.4. In addition, I have tried various other versions installed from deb files. The pattern is the same, as summarized below: - With Ubuntu 24.04.4, the bug does NOT exist with ANY tested version of Libreoffice, new or old. I can copy and paste a very large number of rows. - With Debian 13.4, the bug DOES exist for all RECENT builds I tested (flatpak and .deb). I am limited to 1212 rows. However the bug does NOT exist when I install 7.4.7.2. With the older version I can copy and paste a very large number of rows. So there is nothing in my Debian installation that prevents me from copying and pasting large amounts of data. The problem only occurs with recent versions of LibreOffice, including versions that work perfectly fine in Ubuntu! Again, all of these tests were run on the same hardware (detailed in my earlier post). -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 Mateusz Wlazłowski changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #7 from Mateusz Wlazłowski --- (In reply to dhagen from comment #6) > I was able to reproduce this bug in 26.2.2.2 (Linux), including in SAFE > MODE. The only difference is that I am limited 1212 rows. Here are the > version details: > > Version: 26.2.2.2 (X86_64) > Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5 > CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3 > Locale: en-US (en_US.UTF-8); UI: en-US > Calc: threaded > > Here are some other details about my system: > Machine Type : Desktop > Processor : AMD Ryzen 7 5800XT > Memory : 32793MB > Operating System : Debian GNU/Linux 13.4 > > I was also able to reproduce the bug in 24.2.7.2. > The bug did NOT exist in 7.4.7.2, so it seems to have been introduced > somewhere between these two versions. Could you bibisect the bug ? Thanks https://wiki.documentfoundation.org/QA/Bibisect -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 dhagen changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #6 from dhagen --- I was able to reproduce this bug in 26.2.2.2 (Linux), including in SAFE MODE. The only difference is that I am limited 1212 rows. Here are the version details: Version: 26.2.2.2 (X86_64) Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5 CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Here are some other details about my system: Machine Type : Desktop Processor : AMD Ryzen 7 5800XT Memory : 32793MB Operating System : Debian GNU/Linux 13.4 I was also able to reproduce the bug in 24.2.7.2. The bug did NOT exist in 7.4.7.2, so it seems to have been introduced somewhere between these two versions. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #5 from [email protected] --- (In reply to tame.sand4331 from comment #3) > I encountered a similar problem, but with a different number of rows. The I was not able to reproduce this on Version: 25.2.6.2 (X86_64) / LibreOffice Community Build ID: 520(Build:2) CPU threads: 12; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #4 from QA Administrators --- Dear Ruud Mantingh, 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 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 --- Comment #3 from [email protected] --- I encountered a similar problem, but with a different number of rows. The first time it was with about 270 rows and a warning similar to this was printed to standard error: warn:vcl:1096026:1096026:vcl/headless/svpvd.cxx:111: surface of size 85 by 34133 creation failed with status of: invalid value (typically too big) for the size of the input (surface, pattern, etc.) The numbers looked like pixels to me. The rows in my spreadsheet were pretty tall. I found that I can open an empty sheet, select A1:A2000, and the copy will fail. My default rows are 0.18 inches tall and my screen has 96 DPI, so that would be about 34,560 pixels. Coping 1900 rows succeeds, so a 16 bit signed integer is probably being overflowed. This was originally on Version: 24.8.7.2 (X86_64) / LibreOffice Community Build ID: 480(Build:2) CPU threads: 12; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded The same happens on Version: 25.2.3.2 (X86_64) / LibreOffice Community Build ID: 520(Build:2) CPU threads: 12; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded except the warning is not printed on standard error. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 opp changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||[email protected] Ever confirmed|0 |1 --- Comment #2 from opp --- Could not reproduce. Could you try again in in safe mode ? (Help -> Restart in Safe Mode) If it resolves your issue, then a permanent fix would be to reset your user profile. Try to find the steps if this issue happens again Version: 24.8.6.2 (X86_64) / LibreOffice Community Build ID: 6d98ba145e9a8a39fc57bcc76981d1fb1316c60c CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 166089] Cannot copy and paste more than 1271 rows of data
https://bugs.documentfoundation.org/show_bug.cgi?id=166089 Jessica changed: What|Removed |Added CC||[email protected] --- Comment #1 from Jessica --- Thank you for reporting the bug. I can not reproduce the bug in Version: 25.2.2.2 (X86_64) / LibreOffice Community Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: threaded also not in Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 22ef238e820955f6f8ac84781289b8a1d8e477b9 CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded I can copy all the rows in the sample doc and also paste it. -- You are receiving this mail because: You are the assignee for the bug.
