Bug 129890 - FORMATTING: Paste into a cell using the middle mouse button destroys the pasted cell's textual formatting
Summary: FORMATTING: Paste into a cell using the middle mouse button destroys the past...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Keywords: notBibisectable, regression
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2020-01-08 19:00 UTC by Karl O. Pinc
Modified: 2020-05-03 09:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Karl O. Pinc 2020-01-08 19:00:20 UTC

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,

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

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:
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.
Comment 1 Karl O. Pinc 2020-01-18 02:39:16 UTC
Just re-tested with

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.
Comment 2 Buovjaga 2020-05-02 16:55:08 UTC Comment hidden (off-topic)
Comment 3 Karl O. Pinc 2020-05-02 18:00:04 UTC Comment hidden (off-topic)
Comment 4 Buovjaga 2020-05-02 20:08:42 UTC
(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.
Comment 5 Buovjaga 2020-05-02 20:34:21 UTC
Not yet observed in 5.4.2, but already in 6.0.0. Might try to bisect this tomorrow.
Comment 6 Buovjaga 2020-05-03 09:48:18 UTC
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.