Description: Hello, Pasting into a libreoffice-calc cell with the middle mouse button on Unix ruins the cell's formatting. Steps to Reproduce: 0) Start libreoffice. 1) Open a new libreoffice calc window by clicking on "Calc Spreadsheet" in the "pane" that's down the left hand side of the window. 2) Type something in a cell. Note that the cell's font, and all cell's fonts, are "Liberation Sans" with point size "10". This according to the little boxes in the left of the menus across the top of the screen. 3) In the "input line" across the top of the screen use the mouse to hilight/select the text in the cell. (Hold down left hand mouse button while moving mouse pointer over the text. The selected text should appear in reverse video.) 4) Use mouse to paste the selected text into another cell. (Move mouse pointer over the cell and click on the middle mouse button.) Actual Results: The pasted text shows up in teeny-weeny font. The font name shown in the "font box" in the left hand side of the menus says, in italics: Segoe UI;Tahoma;Arial Unicode MS;Lucida Sans Unicode;DejaVuSans;Albany AMT;Albany;Arial;Nimbus Sans L;InterfaceUser;Geneva;Dialog;Lucida;Helvetica;Helmet;Interface System;Sans Seri The neighboring "font size" box says 4.6. Hovering over the font box with the mouse pointer says: Font Name: The current font is not available and will be substituted. The font formatting (and I don't know what else) becomes a permanent attribute of the cell. Undo (using ctrl-Z) does not revert the formatting, although it does empty the cell of the pasted text. Expected Results: The selected text should paste without changing the formatting of the cell pasted into. Reproducible: Always User Profile Reset: No Additional Info: The problem did not occur in libreoffice 5.2.7 (1:5.2.7-1+deb9u11) on Debian stretch (9, and subsequent point releases) using the stock debian packages and a stock debian system. The problem does occur on Debian buster (10.2) using the stock debian libreoffice 6.1.5 (1:6.1.5-3+deb10u5). (And of course with the reported libreoffice version, 6.4.0.0.beta1.) If, while typing into the "input line" (the text cursor is in the input line) you move the mouse over the cell you are typing into and hilight/select with the mouse and then paste with the mouse into another cell, the problem does not occur. If you first click on the cell you want to paste into and then paste (with the mouse) into the "input line" of that cell, the problem does not occur. There does not seem to be a problem when mouse-pasting text selected from other applications, the terminal, firefox, etc. (Pasting from firefox bring with it some text formatting into the pasted cell. This seems sane.) More information: OS: Debian buster (10.2) Kernel: Linux box 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2+deb10u2 (2019-11-11) x86_64 GNU/Linux Desktop: xfce4 (v4.12.5) Libreoffce "about" info: Version: 6.4.0.0.beta1 Build ID: 4d7e5b0c40ed843384704eca3ce21981d4e98920 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: x11; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded I did not try resetting my user profile but I did all testing in a fresh install in a debootstrap chroot using an empty home directory. So if there is a user profile problem then it is one that happens with a new install. I don't know if openGL is enabled. I would guess that it is not. Thanks for the help.
Just re-tested with 6.4.0.2. Problem still exists. However, now undo undoes the change in formatting and appears to restore the pasted-into cell to its original state. So that part of the problem is gone.
See bug 107699. It is possible the terminal you use is pasting as html instead of plain text. Please check the docs & configuration of your terminal.
@Buovjaga I don't understand your comment. There is no terminal involved. All cutting and pasting is done from within LibreOffice Calc. But it is nice to see someone paying attention. Thanks for that.
(In reply to Karl O. Pinc from comment #3) > @Buovjaga I don't understand your comment. There is no terminal involved. > All cutting and pasting is done from within LibreOffice Calc. > > But it is nice to see someone paying attention. Thanks for that. Sorry about that, it seems I skimmed this report too hastily. I can reproduce the problem.
Not yet observed in 5.4.2, but already in 6.0.0. Might try to bisect this tomorrow.
Ok, sadly this is not bibisectable due to this: bug 110988 That particular bug hides the formatting regression which appeared during the 6.0 development cycle. The formatting bug is not seen in any minor version of 5.4.
Dear Karl O. Pinc, 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
Bug still present in: LibreOffice 7.3.2.2 49f2b1bff42cfccbd8f788c8dc32c1c309559be0 Environment: CPU threads: 4; OS: Linux 5.10 User Interface: UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Misc: Calc: threaded Debian bullseye (v 11.3)
*** Bug 150933 has been marked as a duplicate of this bug. ***
The bug still exists in: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fb39ae1bc7e4b1cbfc3108efca52ec310faf7363 CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded loiah and https://wiki.documentfoundation.org/Installing_in_parallel/Linux made it much easier to test this time. FWIW, this is a regression. See thread above.