Bug 234503 - Copy-and-paste entire sheet gives error
Copy-and-paste entire sheet gives error
Product: Fedora
Classification: Fedora
Component: openoffice.org (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Caolan McNamara
Depends On:
  Show dependency treegraph
Reported: 2007-03-29 14:12 EDT by Christopher Beland
Modified: 2007-11-30 17:12 EST (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2007-03-29 14:49:54 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

External Trackers
Tracker ID Priority Status Summary Last Updated
OpenOffice.org 74545 None None None Never

  None (edit)
Description Christopher Beland 2007-03-29 14:12:36 EDT
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 14:49:54 EDT
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 15:21:53 EDT
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

Note You need to log in before you can comment on or make changes to this bug.