Bug 278373

Summary: calligra-tables fails to correctly import external data from clipboard/csv file
Product: [Applications] calligrasheets Reporter: Barrie Backhurst <barrie.backhurst>
Component: generalAssignee: Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status: RESOLVED FIXED    
Severity: major CC: sebsauer, soloturn
Priority: NOR    
Version: Git   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: Version Fixed In:
Attachments: screenshot after inserting test2.csv from bug 167107

Description Barrie Backhurst 2011-07-24 06:58:27 UTC
Created attachment 62128 [details]
screenshot after inserting test2.csv from bug 167107

Version:           2.4-snapshots (using KDE 4.6.4) 
OS:                Linux

I am actually using KDE-4.6.5(no option in bugzilla) and Calligra-2.3.73

I use freenx and copy data to and from the nxclient. When copying a range of cells from an Libreoffice spreadsheet I am unable to successfully paste them into Calligra-tables. If I try to right click and paste directly into cell A1, no csv import option is given, instead the first row of data is inserted into the cell and the remaining data lost. If I use
Insert > External data > From Clipboard
The import csv wizard is launched and previews the data correctly, however only the first item of the first row is inserted into cell A1. Saving the clipboard to a csv file and using
Insert > External data > From file
yields the same result

Conversely if I open the file directly, it opens correctly via the wizard

Bug 167107 appears related, although marked resolved/fixed the attached test2.csv exhibits the problems above.

This bug was also present in previous installs of Kspread

Reproducible: Always

Steps to Reproduce:
Insert > External data > From Clipboard
or
Insert > External data > From file

Actual Results:  
only first item of first row inserted into cell A1

Expected Results:  
all data to be inserted into appropriate cells

ideally a direct paste into the spreadsheet, launching the import wizard would be preferred(as per Libreoffice)
Comment 1 Sebastian Sauer 2011-07-26 17:07:36 UTC
Confirmed. Seems it's a regression introduced since Stefan fixed it in bug 167107 :-/
Comment 2 Sebastian Sauer 2011-07-26 17:20:17 UTC
*** Bug 276888 has been marked as a duplicate of this bug. ***
Comment 3 Sebastian Sauer 2011-07-26 17:21:32 UTC
Mark major cause it means copy+paste doesn't work any longer as soon as more then one cell is selected.
Comment 4 Sebastian Sauer 2011-07-29 21:59:39 UTC
Fixed with d8697f437d15914fbf94d97d4f38ee1f6ec44095