Bug 234503

Summary: Copy-and-paste entire sheet gives error
Product: [Fedora] Fedora Reporter: Christopher Beland <beland>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED WONTFIX QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 6   
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2007-03-29 18:49:54 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Christopher Beland 2007-03-29 18:12:36 UTC 
I have two sheets which I wish to merge.  I select all cells in the first one by
clicking on the box in the upper-left-hand corner, between the row labels and
column labels.  I hit Ctrl-c.  Then I select a cell in the second sheet and hit
Ctrl-v.  I get the error: "There is not enough space on the sheet to insert here."

This does not make sense; there are only a few rows and columns in the first
sheet.  If I explicitly select the rows and columns I need (all of those that
actually have data, not including the seemingly infinite number of empty cells)
by dragging from one corner of the data to its diagonal opposite, I can
cut-and-paste without any problem.

I think this operation should just work without any questions, perhaps unless
there's a question about whether or not the "empty" cells at the fringes of the
copied should erase data in the one being pasted into.

A more helpful error message would also be an improvement.

This is with openoffice.org-calc-2.0.4-5.5.17.
Comment 1 Caolan McNamara 2007-03-29 18:49:54 UTC 
See: http://qa.openoffice.org/issues/show_bug.cgi?id=74545  basically the empty
rows and columns do matter, excel does this as well. You could raise a
suggestion upstream to select only the cells with content in them when clicking
the currently "select all" top left corner button. Or some other way of handling
the paste, but for the moment this is how it works by design.
Comment 2 Christopher Beland 2007-03-29 19:21:53 UTC 
Well, my point is that the behavior is not very user-friendly, whether or not it
was intentional or is just as unfriendly as other applications.

In any case, I have taken your suggestion and opened a new request at
http://qa.openoffice.org/issues/show_bug.cgi?id=75880