Bug 82387 - CALC: Paste from another spreadsheet Results in Duplicate Rows If Paste Region Larger on Calc than Data Region EXCEL/Calc, LO hang/crash
Summary: CALC: Paste from another spreadsheet Results in Duplicate Rows If Paste Regi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.3.0.4 release
Hardware: Other Windows (All)
: medium major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-09 12:44 UTC by Doug
Modified: 2014-09-05 14:25 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
screenshot of copy region from excel (3.23 KB, image/png)
2014-08-09 12:44 UTC, Doug 		Details
screenshot of paste region in calc (copy origin in prior screenshot) - full calc columns selected (13.31 KB, image/png)
2014-08-09 12:45 UTC, Doug 		Details
calc paste area - larger area but not full columns selected (9.46 KB, image/png)
2014-08-09 12:46 UTC, Doug 		Details
View All

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.