Bug 140698 - calc paste not working between sheets with Klipper history size set to 1 (steps in comment 12)
Summary: calc paste not working between sheets with Klipper history size set to 1 (ste...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-27 12:53 UTC by Pascal
Modified: 2023-04-08 19:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
klipper options (2.78 KB, text/plain)
2021-02-27 12:56 UTC, Pascal
Details
sample document (14.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-03-10 13:52 UTC, Pascal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pascal 2021-02-27 12:53:54 UTC
Description:
On Kubuntu, if klipper (kde's copy/paste manager) is set to max history count = 1  then I am unable to paste any multicells content from one sheet to another.

With this setting, I am still able to copy from calc and paste to another application (writer or kate for ex) but I can never copy from one sheet to paste to another in calc.

With this setting I can copy then paste between sheets, only if I copy ONE cell at a time and if I copy by doing ctrl-C TWICE.


Steps to Reproduce:
Preliminary
on KDE, right click on klipper tray icon to configure it and set clipboard max history size to 1

1.open calc new doc
2.add another sheet
3.on first sheet enter data in 4 cells for example
4.select these 4 cells
5. copy with ctrl-c
6. go to the second sheet
7. select a cell
8. paste with ctrl-v


Actual Results:
nothing is pasted

Expected Results:
the 4 cells from the first sheet should be pasted on the second sheet


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Ubuntu package version: 1:7.0.3-0ubuntu0.20.10.1
Calc: threaded
Comment 1 Pascal 2021-02-27 12:56:03 UTC
Created attachment 170114 [details]
klipper options
Comment 2 Pascal 2021-02-27 12:57:45 UTC
the other applications have no problems with this klipper option.

setting klipper max history to a count > 1 solve the problem.

But to use klipper safely with password managers I have to set this count to 1.
Comment 3 Xisco Faulí 2021-03-01 12:37:10 UTC
What happens if you set the max history count to 2 and you copy/paste 2 cells ?
Comment 4 Pascal 2021-03-01 14:52:58 UTC
If I do what you suggest, it works OK, either copying horizontal or vertical set of 2 cells in another sheet.
Comment 5 QA Administrators 2021-03-02 03:49:27 UTC Comment hidden (obsolete)
Comment 6 Michael Weghorn 2021-03-08 15:06:47 UTC
Could not reproduce this in a quick test with self-built master debug build as of

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: c7b898df4d452746399621f6adc8e7da088f0f3a
CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

on Debian testing and the klipper history size set to 1.
Comment 7 Xisco Faulí 2021-03-09 15:02:30 UTC
Is it related to bug 130715 ?
Comment 8 Pascal 2021-03-10 01:12:31 UTC
(In reply to Xisco Faulí from comment #7)
> Is it related to bug 130715 ?

It is the same symptoms, but my bug is only triggered when klipper history count is exactly 1
On bug 130715, I don't see the history count used by the reporter.
Comment 9 Michael Weghorn 2021-03-10 05:27:28 UTC
In case this may depend on what data is entered in step 3 (i.e. exact clipboard content): Can you attach a sample document and say what cells are copied to the other sheet in step 7 (and to what cells), or alternatively, attach a screencast?
Comment 10 Pascal 2021-03-10 13:52:15 UTC
Created attachment 170392 [details]
sample document


have klipper history count set to 1

A* open the attached doc
B* go to synthese sheet
C* select all B2 to F2 included
D* ctrl-c to copy

What works :
- click on cell B14
- ctrl-v to paste  (is OK)

What does not work :
- repeat steps C+D
- select sheet eee
- click on cell B14
- ctrl-v  (nothing is pasted)
Comment 11 QA Administrators 2021-03-11 04:49:48 UTC Comment hidden (obsolete)
Comment 12 Michael Weghorn 2021-03-15 06:13:11 UTC
(In reply to Pascal from comment #10)
> Created attachment 170392 [details]
> sample document
> 
> 
> have klipper history count set to 1
> 
> A* open the attached doc
> B* go to synthese sheet
> C* select all B2 to F2 included
> D* ctrl-c to copy
> 
> What works :
> - click on cell B14
> - ctrl-v to paste  (is OK)
> 
> What does not work :
> - repeat steps C+D
> - select sheet eee
> - click on cell B14
> - ctrl-v  (nothing is pasted)

Thanks, I can now reproduce using these steps and it happens with all of the VCL plugins on Linux). Doesn't happen when using a klipper history size of 2 instead. This might require taking a closer look at what Klipper does, and whether it's an issue in LO or klipper.

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 96388e5e809a48573970df9b6b2649517a08447f
CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: kf5
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 96388e5e809a48573970df9b6b2649517a08447f
CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 96388e5e809a48573970df9b6b2649517a08447f
CPU threads: 12; OS: Linux 5.10; UI render: default; VCL: x11
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 13 QA Administrators 2023-03-16 03:28:32 UTC Comment hidden (obsolete)
Comment 14 Pascal 2023-04-08 19:16:16 UTC
No more problem with version 7.4.6.2
on kubuntu 22.10