Bug 82387

Summary: CALC: Paste from another spreadsheet Results in Duplicate Rows If Paste Region Larger on Calc than Data Region EXCEL/Calc, LO hang/crash
Product: LibreOffice Reporter: Doug <dougt901-2012>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: raal
Version: 4.3.0.4 release   
Hardware: Other   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: screenshot of copy region from excel
screenshot of paste region in calc (copy origin in prior screenshot) - full calc columns selected
calc paste area - larger area but not full columns selected

Description Doug 2014-08-09 12:44:55 UTC
Created attachment 104342 [details]
screenshot of copy region from excel

1.  Create EXCEL spreadsheet, add data
2.  Select region for copying, copy to clipboard
3.  Click on CALC spreadsheet
4.  Select paste region of larger size.
5.  Paste

UNEXPECTED RESULT:  Blank or non-existent rows in clipboard from EXCEL spreadsheet filled in with DUPLICATE/repetitive rows of data on CALC spreadsheet.

Desired result:  no duplicate rows on paste.

See screenshots.
Comment 1 Doug 2014-08-09 12:45:43 UTC
Created attachment 104343 [details]
screenshot of paste region in calc (copy origin in prior screenshot) - full calc columns selected
Comment 2 Doug 2014-08-09 12:46:25 UTC
Created attachment 104344 [details]
calc paste area - larger area but not full columns selected
Comment 3 Doug 2014-08-10 00:26:17 UTC
if the CALC paste region is the whole sheet, CALC will stop responding while it tries to paste duplicate data to all 1048576 rows and 1024 columns.  This requires forced restart of all LibreOffice applications open, loss of data.
Comment 4 Doug 2014-08-10 01:38:04 UTC
Pasting from one LO CALC spreadsheet to another LO CALC spreadsheet also triggers this same problem, triggers application hang/CRASH when full column selected as target for paste.
Comment 5 raal 2014-09-05 14:25:26 UTC
Hello,
I can reproduce the crash on Win 7, LO  4.3.1.2 ( crash while it tries to paste duplicate data to all 1048576 rows and 1024 columns from Calc to Calc)
Error message: LO 4.3 fatal error
bad allocation

I can reproduce the crash with Version: 4.3.2.0.0+
Build ID: 5c1b508b172f0047d86e1acde92239ebf3438251
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-08-27_06:11:49
( crash while it tries to paste duplicate data to all 1048576 rows and 1024 columns from Calc to Calc)

I can reproduce "duplicate rows" with Version: 4.3.2.0.0+
Build ID: a5fedcf7fe56a56475dea484a78971c504e52272
TinderBox: Win-x86@42, Branch:libreoffice-4-3, Time: 2014-08-29_10:16:48
(Blank or non-existent rows in clipboard from EXCEL spreadsheet filled in with DUPLICATE/repetitive rows of data on CALC spreadsheet when copy from Calc to Calc)


I can not reproduce  "duplicate rows" with Version: 4.3.2.0.0+
Build ID: 5c1b508b172f0047d86e1acde92239ebf3438251
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-08-27_06:11:49



Setting as new, this should be two bugs -  crash and filling empty rows.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.