Bug 68970

Summary: EDITING: Full column paste annoyance
Product: LibreOffice Reporter: Robert <spamtrap>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: enhancement CC: jbfaure, spamtrap
Priority: medium    
Version: 4.1.1.2 release   
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Robert 2013-09-05 09:38:08 UTC
When copy & paste'ing a full column from row 1 of a sheet to row 2 of another, a pop-up appears telling me "There is not enough space on the sheet to insert here."

Strictly speaking this is correct, but given the fact that the last million+ cells in the copied column are empty, it would be a lot more "Anwenderfreundlich" if LO only spat out this message when data would actually be lost, similar to the message "Filled cells cannot be shifted beyond the sheet.", that appears when one tries to insert a cell/row and there is data on row 1048576.
Comment 1 Jean-Baptiste Faure 2013-12-14 13:03:18 UTC
I do not understand what you mean by copy-pasting a column from a row (line ?) to another.

Please, explain step by step what should be done to reproduce the problem you encounter.

Best regards. JBF
Comment 2 Robert 2014-03-10 22:35:39 UTC
Steps to recreate this annoyance:

1) Open Calc, creating Untitled1
2) Type anything in cell A1
3) Select column A
4) Copy column A
5) Add a new sheet
6) Place the cursor in cell A2
7) Paste

Result:

Pop-up with

"There is not enough space on the sheet to insert here."

Which is, strictly speaking, true, but given that CTRL-END will go to the cell at the intersection of the last row and column that actually contain data, Cut or Paste also should be smart enough to realize that the cut column A is empty enough to actually be pasted.
Comment 3 Jean-Baptiste Faure 2014-07-20 17:59:41 UTC
Not a bug: the copy&paste function acts on cells whatever their contents is, with data or empty. You will have the same error message if you copy the whole column A and try to paste it in B2. Doing that means you want a column with 1048576 + 1 row which is not possible. The correct procedure is to copy only the cells with the needed data.

Best regards. JBF
Comment 4 Robert 2014-07-20 18:04:36 UTC
The word is Anwenderfreundlichkeit. The LibreOffice team is obviously not interested in it.