Apache OpenOffice (AOO) Bugzilla – Issue 53526
Copying whole spreadsheet column copies all rows
Last modified: 2013-08-07 15:12:27 UTC
I tried this, that didn't work out as expected. It might not be a serious bug, merely a usability issue. If you select on or more columns in oocalc by clicking on a column caption (e.g. A,B,D,...) you select the whole column(s). If you copy the column to the clipboard (e.g. Ctrl-C) and paste it in some other non-OO text editor, 32000 rows are copied. I would prefer that only rows spanning actual content would be copied.
Tested on a Windows XP SP2 machine with build 1.9.125 and on an Apple PowerBook running OS 10.3 OpenOffice Build 1.1.2 and NeoOffice/j 1.1 Here is a set of steps to replicate the issue 1) Create a new spreadsheet 2) Enter a few values into a few rows of column A 3) Select the column header and copy it (use Crl+c (apple key + c on Mac) or Edit->Copy) 4) Paste into notepad or any other plain text editor You’ll notice that many blank lines have just been inserted into the document, now on the Mac OpenOffice 1.1.2 doesn’t paste any values into the text editor and causes Microsoft Word to spit out an out of memory error. The issue also a similar affect happens when you select a row and copy it like the steps mentioned above. This problem is consistent across platforms and is definitely a nuisance in the user interface. This problem also has the possibility of occurring more often then other minor issues, since it’s a simple select and copy process that affects irrelevant cells/data. Steve Wu and Jacek Leowski
Hi, not a defect but an enhancement request. IMHO Calc works as expected. You've decided to copy the whole column into the clipboard making it possible to paste a table with such big amount of rows into e.g. Writer. So this is what you have decided to do. Nevertheless a decision has to made by the requirements team. Frank
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 2+ years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
I'll close this one since Issue 84411 has a vote. *** This issue has been marked as a duplicate of 84411 ***
closing a duplicate.