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.)
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.
The selected text should paste without changing the formatting of the
cell pasted into.
User Profile Reset: No
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, 184.108.40.206.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
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
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:
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
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 220.127.116.11.
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.