Apache OpenOffice (AOO) Bugzilla – Issue 84411
Copy while whole column selected should trim trailing cells
Last modified: 2014-11-23 22:44:59 UTC
Sub: Copy while whole column selected should trim trailing cells When user select whole column and do a copy (I used Ctrl+C) Calc now copy 65537 lines to clipboard, even though all the cells after first few rows are empty. MS-Excel (tested on Excel 2003) will stop copy after last "non-empty row + 1" This difference in behavior is also there when we do whole row select. Current OOo Calc behavior is dangerous, if user do Edit > Paste Special > Unformated text Can we make Calc behave like the Excel way? Also I want to mention, when all the cells in current selection are either in single row or in single column MS-Excel do this trimming. I dont know whether that is good. As it is different from the way MS-Excel do copy when an area with cells from multiple column and multiple row is selected. ie, an area selection in MS-Excel copies all cells including empty cells. Steps:- ** On MS-Excel 1. Open MS-Excel 2. Fill A1:B10 with some text 3. Select whole column A and B 4. copy using ctrl+c 5. Go to Notepad 6. Do Paste 7. See result with 11 lines 8. Open MS-Word 9. Do Paste 10. See result with a table with 11 lines ** On OOo Calc ** repeat same by 1. Open OOo Calc 2. Fill A1:B10 with some text 3. Select whole column A and B 4. copy using ctrl+c 5. Go to Notepad 6. Do Paste 7. See pasted contents with 65537 lines 8. Open OOo Writer 9. Do Paste Special > UnFormatted Text 10. See system HANGS!!!, ie, waiting for converting 65537 lines
There is a similar issue for copy/paste special as "Formatted text (RTF)" into Writer. In this case, OOo did not crash, but it took almost an hour to finish the paste, producing a table with >65000 empty cells and a >1300 page document. Not a very good experience. I agree with the suggestion that OOo should truncate the selection to exclude empty cells from the "tail" of the selection. Alternatively, there should be some way to cancel the paste operation, or (least desirable) a warning that the clipboard contains a lot of data and may take a long time to finish.
Confirmed on Linux (official OOo 2.3.1 version under Ubuntu 6.06). Took only 20s to paste the 65000 rows however (as Calc object with standard CTRL+C / CTRL+V paste action). BTW, result of the paste action is a very thin line. It need to be enlarged to see that's a single column 65000 rows height.
Agree, the trailing cells/rows should be trimmed, or there should be a way of doing it easily after the fact. I tried it manually,,, would take hours manually. Even selecting all doesn't work, or selecting as long a range as possible.
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)
May be same as Issue 53526
This is a critical issue. Added myself to the cc-list. There was also a discussion on the OASIS TC list regarding an application dependent "Table Grid Size" element and my alternative suggestion for the actual spreadsheet size. I believe that the alternative is much more elegant and useful, especially for this particular issue, see: http://lists.oasis-open.org/archives/office-comment/200811/msg00006.html
*** Issue 109365 has been marked as a duplicate of this issue. ***
this is confirmed, right?
*** Issue 53526 has been marked as a duplicate of this issue. ***
This is still an issue in the latest.