Bug 69436 - EDITING: cut 1 cell -- paste into many cells -- does not work ...
Summary: EDITING: cut 1 cell -- paste into many cells -- does not work ...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-16 19:15 UTC by Mike Bianchi
Modified: 2015-02-11 19:59 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
tar file of the two example ODS files (50.00 KB, application/x-tar)
2013-09-16 19:15 UTC, Mike Bianchi
Details
1st of 9 (128.43 KB, image/png)
2014-05-17 19:42 UTC, Mike Bianchi
Details
2nd of 9 (116.39 KB, image/png)
2014-05-17 19:43 UTC, Mike Bianchi
Details
3rd (123.54 KB, image/png)
2014-05-17 19:43 UTC, Mike Bianchi
Details
4th (132.90 KB, image/png)
2014-05-17 19:44 UTC, Mike Bianchi
Details
5th (134.67 KB, image/png)
2014-05-17 19:44 UTC, Mike Bianchi
Details
6th (142.40 KB, image/png)
2014-05-17 19:45 UTC, Mike Bianchi
Details
7th (124.24 KB, image/png)
2014-05-17 19:46 UTC, Mike Bianchi
Details
8th (141.99 KB, image/png)
2014-05-17 19:46 UTC, Mike Bianchi
Details
9th (134.06 KB, image/png)
2014-05-17 19:47 UTC, Mike Bianchi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Bianchi 2013-09-16 19:15:04 UTC
Created attachment 85935 [details]
tar file of the two example ODS files

see http://ask.libreoffice.org/en/question/1926/paste-loses-cell-format-in-calc-and-other-pasting-issues/

  libreoffice --version
LibreOffice 4.1.0.4 410m0(Build:4)
installed on Debian Wheezy

see attached file  multiline_paste_fails.ods

The following sequence works:
   click line 17
   Right mouse   select  Copy
           line 17 is highlight and has the marching ants animation
   put the mouse cursor on cell A19
   Right mouse   select  Paste

the line is copied into A19:BK19

Copy line 17 again.
Paste it into line 20.
   line 20 highlights, but show no data     this used to work

Copy line 17 again
Select cells A21:A22   Paste
  Text Import window show up     OK   does nothing
          Text Import is the wrong.  It should paste 2 copies of the line.


see attached file  multiline_paste_fails_2.ods

I also tried this with a New spreadsheet, and the multi-line Paste
does not work there either.




Operating System: Debian
Version: 4.1.0.4 release
Comment 1 Jean-Baptiste Faure 2013-09-27 10:08:09 UTC
I do not reproduce with LO 4.1.3.0.0+ under Ubuntu 13.04 x86-64
Please, could you upgrade your LO version to the current one and try again?

Best regards. JBF
Comment 2 QA Administrators 2014-05-17 00:34:16 UTC
Dear Bug Submitter,

Please read the entire message before proceeding.

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 3 Mike Bianchi 2014-05-17 19:42:46 UTC
Created attachment 99237 [details]
1st of 9
Comment 4 Mike Bianchi 2014-05-17 19:43:18 UTC
Created attachment 99238 [details]
2nd of 9
Comment 5 Mike Bianchi 2014-05-17 19:43:57 UTC
Created attachment 99239 [details]
3rd
Comment 6 Mike Bianchi 2014-05-17 19:44:23 UTC
Created attachment 99240 [details]
4th
Comment 7 Mike Bianchi 2014-05-17 19:44:56 UTC
Created attachment 99241 [details]
5th
Comment 8 Mike Bianchi 2014-05-17 19:45:39 UTC
Created attachment 99242 [details]
6th
Comment 9 Mike Bianchi 2014-05-17 19:46:23 UTC
Created attachment 99243 [details]
7th
Comment 10 Mike Bianchi 2014-05-17 19:46:47 UTC
Created attachment 99244 [details]
8th
Comment 11 Mike Bianchi 2014-05-17 19:47:06 UTC
Created attachment 99245 [details]
9th
Comment 12 Mike Bianchi 2014-05-17 19:48:13 UTC
images
Comment 13 Mike Bianchi 2014-05-17 19:50:42 UTC
Sorry I left this hanging for so long.

The problem proved to be incompatibility between KDE's klipper and Libre.

Without /usr/bin/klipper running, Libre cut and paste works as expected.
Selecting a range of lines (by sweeping the line numbers)
and pasting to a line number copies the entire selection.
libre_klipper_bug_0.png
libre_klipper_bug_1.png
libre_klipper_bug_2.png
libre_klipper_bug_3.png

With clipper running, the paste does nothing, without complaint.
libre_klipper_bug_4.png
libre_klipper_bug_5.png
libre_klipper_bug_6.png

But copying a single line and pasting to >> the first cell << of a line works.
libre_klipper_bug_7.png
libre_klipper_bug_8.png
Comment 14 Mike Bianchi 2014-05-17 19:53:38 UTC
I got confused by the bug submission process.
The file names
libre_klipper_bug_0.png
libre_klipper_bug_1.png
libre_klipper_bug_2.png
libre_klipper_bug_3.png
libre_klipper_bug_4.png
libre_klipper_bug_5.png
libre_klipper_bug_6.png
libre_klipper_bug_7.png
libre_klipper_bug_8.png

refer to the attachments "1st of 9", etc.
Comment 15 Mike Bianchi 2014-05-17 19:54:58 UTC
(In reply to comment #13)
> Sorry I left this hanging for so long.
> 
> The problem proved to be incompatibility between KDE's klipper and Libre.
> 
> Without /usr/bin/klipper running, Libre cut and paste works as expected.
> Selecting a range of lines (by sweeping the line numbers)
> and pasting to a line number copies the entire selection.
> libre_klipper_bug_0.png
> libre_klipper_bug_1.png
> libre_klipper_bug_2.png
> libre_klipper_bug_3.png
> 
> With clipper running, the paste does nothing, without complaint.
> libre_klipper_bug_4.png
> libre_klipper_bug_5.png
> libre_klipper_bug_6.png
> 
> But copying a single line and pasting to >> the first cell << of a line
> works.
> libre_klipper_bug_7.png
> libre_klipper_bug_8.png

"clipper" should be "klipper"
Comment 16 Joel Madero 2014-05-21 04:20:13 UTC
Ah yes - we had a similar one and I'm relatively sure it's KDE's bug but I'm requesting dev input to verify. Thanks for the update
Comment 17 Mike Bianchi 2014-05-21 12:16:09 UTC
Is there a simple way to cross-post this bug to KDE?
Comment 18 Joel Madero 2014-05-21 14:58:08 UTC
No - you just have to head to their infra and report the same problem.
Comment 19 Robinson Tryon (qubit) 2014-07-03 21:34:00 UTC
(Whiteboard: Removing 'NeedAdvice' as this does seem like a KDE issue at this time)

Mike -- Is there a bug reported in the KDE tracker yet?  I took a quick look, but didn't find anything. Please provide a link and then feel free to change status back to 'UNCONFIRMED'.
Comment 20 QA Administrators 2015-02-11 19:59:58 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided):

a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. 

Please do not:
a) respond via email 
b) update the version field in the bug or any of the other details on the top section of FDO
Message generated on: 2015-02-11