Bug 82315 - Paste Special within Cell Loses Focus
Summary: Paste Special within Cell Loses Focus
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Paste-Special
  Show dependency treegraph
Reported: 2014-08-08 03:25 UTC by Tom Colley
Modified: 2019-03-01 07:19 UTC (History)
3 users (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 Tom Colley 2014-08-08 03:25:31 UTC
When editing a cell and using the Paste Special function, the paste works but the focus is then removed from the cell being edited. This requires the user to manually return the focus to that cell for further editing. I mention this as it may be easily fixed in the next round of work for the Paste Special function.
Comment 1 Algot Runeman 2014-08-08 15:46:48 UTC
Test System:
Kubuntu 14.04 (KDE 4.13.2)


Working with a single Calc cell, I was able to use Edit -> Paste Special with NO LOSS of focus. Visually, the cell, which had been merely outlined, also gained a temporary cell highlight color (hex value #cfeaf9) in addition to the cell being outlined.

Can you give a sample spreadsheet in which the problem is easy to demonstrate and include the value/text you pasted?

Comment 2 Tom Colley 2014-08-08 23:01:43 UTC
Thanks Algot. On further investigation, I realise that the loss of focus is related to having another application window open that is set as "Always On Top". This setting is designed to ensure that even when other windows occupying the same part of the screen gain the focus, this window remains fully visible. This facility is very useful for working across multiple applications at the same time.

After the Paste Special operation, I am finding that the window with the "Always On Top" setting gains the focus, rather than Calc. I have tried this setting using both VLC and Zotero with Calc. With Calc, I have confirmed it using a new spreadsheet from the Libreoffice template.
Comment 3 Buovjaga 2014-11-26 13:03:51 UTC Comment hidden (obsolete)
Comment 4 Tom Colley 2014-11-28 07:30:26 UTC
(In reply to Beluga from comment #3)
> Tom: what distro & desktop environment are you using?

Hi Beluga. I'm using Ubuntu 14.04 LTS with the standard Unity desktop.
Comment 5 Buovjaga 2014-11-28 08:05:36 UTC
Ok I tried with VLC and always on top. For some reason, VLC doesn't stay on top with this option. In any case, the focus is not lost on paste special.


Ubuntu 14.10 64-bit Version:
Build ID: 6b219f012edbe069c461f4e0746898e33fa1dd49
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-25_21:56:46
Comment 6 raal 2014-11-28 15:40:34 UTC
Ubuntu 14.10, Unity desktop
I can confirm with Version:
Build ID: 9e57326acebde972df22ea4368b5ce4822d51330
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-11-27_12:21:59

 - open calc, 
 - open terminal, set as "always on top"
 - click to calc into the  cell, paste special (or paste)
 - write something -> observe that you write into terminal window

The same behaviour with paste and paste special. With Gedit focus stay after paste in the Gedit, so looks like a bug in LO. Setting as NEW.
Comment 7 Buovjaga 2014-11-28 19:44:07 UTC
(In reply to raal from comment #6)
>  - open calc, 
>  - open terminal, set as "always on top"
>  - click to calc into the  cell, paste special (or paste)
>  - write something -> observe that you write into terminal window

Ok, I could confirm with terminal being always on top, but it took a second paste special for it to start stealing focus. Same build as in my comment 5.