Bug 95391 - Multi line paste of tab separated data from a terminal misses first 2 lines
Summary: Multi line paste of tab separated data from a terminal misses first 2 lines
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-28 10:19 UTC by Martin Houston
Modified: 2016-03-26 07:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Houston 2015-10-28 10:19:06 UTC 
When pasting multi line tab separated output from a terminal into the spreadsheet the first 2 lines are missing.

They are visible in the paste dialog but never make it into the sheet!

It is possible to paste these two lines one at a time but not together.

Problem is trivial to reproduce:

echo -e "First\tLine\nSecond\tLine\nThird\tLine\n"

run that and paste the output into a new sheet. Choose tab as input sep.

You will see all 3 lines in that dialog box but only "Third Line" makes it to the sheet.

Expect this is trivial off by 2 error somewhere....
Comment 1 raal 2015-10-29 16:12:34 UTC 
I can not confirm with version 5.0.2.2, linux

Please test with version 5.0.2.2, http://www.libreoffice.org/download/libreoffice-fresh/
Comment 2 Martin Houston 2015-10-29 17:03:24 UTC 
Yes I confirm that this has been corrected in the latest stable version.
Comment 3 Lee Studley 2016-03-24 20:56:06 UTC 
I am having this problem with version 5.0.5.2


If I paste all below this line, as space separated, the first 2 lines are lost: 
T 685 540 10 0 3 __6221_PFI_14_P2_6
T 685 550 10 0 3 __6221_PFI_12_P2_4
T 685 560 10 0 3 __6221_PFI_9_P2_1
T 685 580 10 0 3 __6221_PFI_6_P1_6
T 685 590 10 0 3 __6221_PFI_5_P1_5
T 685 610 10 0 3 __6221_P5VDC
T 685 630 10 0 3 __6221_PFI_1_P1_1
T 685 640 10 0 3 __6221_PFI_0_P1_0
T 685 670 10 0 3 __6221_P5VDC
T 685 690 10 0 3 __6221_P0_6
T 685 700 10 0 3 __6221_P0_1
T 685 720 10 0 3 __6221_P0_4
T 615 770 10 0 3 __6221_AI_GND
T 615 780 10 0 3 __6221_AI_6_AI_6_P
T 615 860 10 0 3 __6221_AI_1_AI_1_P
T 615 840 10 0 3 __6221_AI_10_AI_2_N
T 615 830 10 0 3 __6221_AI_3_AI_3_P
T 615 810 10 0 3 __6221_AI_4_AI_4_P
T 250 790 10 0 3 __6221_AI_5_AI_5_P
T 615 760 10 0 3 __6221_AI_15_AI_7_N
T 615 870 10 0 3 __6221_AI_8_AI_0_N
T 685 750 10 0 3 __6221_AO_0
T 685 740 10 0 3 __6221_AO_1
T 280 810 10 0 3 __6221_AI_SENSE
T 300 780 10 0 3 __6221_AI_GND
T 240 770 10 0 3 __6221_AI_14_AI_6_N
T 240 800 10 0 3 __6221_AI_12_AI_4_N
T 300 750 10 0 3 __6221_AI_GND
T 305 740 10 0 3 __6221_AO_GND
T 305 730 10 0 3 __6221_AO_GND
T 250 760 10 0 3 __6221_AI_7_AI_7_P
T 315 720 10 0 3 __6221_D_GND
T 315 690 10 0 3 __6221_D_GND
T 315 630 10 0 3 __6221_D_GND
T 315 550 10 0 3 __6221_D_GND
T 335 710 10 0 3 __6221_P00
T 335 700 10 0 3 __6221_P05
T 335 680 10 0 3 __6221_P02
T 335 670 10 0 3 __6221_P07
T 335 660 10 0 3 __6221_P03
T 265 650 10 0 3 __6221_PFI_11_P23
T 265 640 10 0 3 __6221_PFI_10_P22
T 275 620 10 0 3 __6221_PFI_2_P12
T 275 610 10 0 3 __6221_PFI_3_P13
T 275 600 10 0 3 __6221_PFI_4_P14
T 265 590 10 0 3 __6221_PFI_13_P25
T 265 580 10 0 3 __6221_PFI_15_P27
T 275 570 10 0 3 __6221_PFI_7_P17
T 275 560 10 0 3 __6221_PFI_8_P20
T 615 850 10 0 3 __6221_AI_GND
T 615 820 10 0 3 __6221_AI_GND
T 615 800 10 0 3 __6221_AI_GND
T 685 710 10 0 3 __6221_D_GND
T 685 680 10 0 3 __6221_D_GND
T 685 660 10 0 3 __6221_D_GND
T 685 650 10 0 3 __6221_D_GND
T 685 620 10 0 3 __6221_D_GND
T 685 600 10 0 3 __6221_D_GND
T 685 570 10 0 3 __6221_D_GND
T 315 540 10 0 3 __6221_D_GND
T 675 730 10 0 3 __6221_NC_xxxx
T 250 850 10 0 3 __6221_AI_9_AI_1_N
T 240 820 10 0 3 __6221_AI_11_AI_3_N
T 250 840 10 0 3 __6221_AI_2_AI_2_P
T 300 830 10 0 3 __6221_AI_GND
T 615 790 10 0 3 __6221_AI_13_AI_5_N
T 300 860 10 0 3 __6221_AI_GND
T 250 870 10 0 3 __6221_AI_0_AI_0_P
Comment 4 raal 2016-03-25 06:12:27 UTC 
(In reply to Lee Studley from comment #3)
> I am having this problem with version 5.0.5.2
> 
> 
> If I paste all below this line, as space separated, the first 2 lines are
> lost: 

Hello, I have not problem with your example. Are you sure that in import dialog you have value "From row" = 1? It's third field from the top.
Comment 5 raal 2016-03-25 06:13:50 UTC 
Lee, see the comment 4
Comment 6 Lee Studley 2016-03-26 00:09:24 UTC 
(In reply to raal from comment #5)
> Lee, see the comment 4

Hi Raal, You are correct I missed that it had defaulted in this case to line=3
When I did it a second time the line was line=1 and when restarted, scalc.exe the line was persistent at line=1 now. Not sure why it went to line=3

Now I that I'm paying attention not to overlook that feature, it's working as expected. Thanks you for the correction. Best Regards, Lee Studley