Issue 54064 - Empty cells shouldn't be copied when a complete column is selected
Summary: Empty cells shouldn't be copied when a complete column is selected
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-08-31 22:07 UTC by the_redburn
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description the_redburn 2005-08-31 22:07:14 UTC
Steps to reproduce:
1. Select a full column by clicking on its header
2. Copy the selection

The full column (65536 rows) is copied

Expected result:
Only the first rows are copied (until the last rows which isn't empty)
This is the Excel's behavior
Comment 1 frank 2005-09-22 11:51:10 UTC

IMHO Calc works in the logical way. The User decided to copy all Rows in the
column to the clipboard by clicking on the column header. So no need for
changing this. BTW whats about having five empty cells above the filled one and
you want to copy also these 5 empty cells ? Using your approach you're not able
to do so.

Nevertheless re-assigned to requirements for final decission.

Comment 2 the_redburn 2005-09-22 12:09:34 UTC
Actually, I'm not sure, but the first cells are perhaps copied.
But it would be even better to have a small popup menu appearing in the
spreadsheet near the selection and asking us to choose how we want OOo to handle
this action (like there is in Office 2003 when by example we extend some cells
to other cells by clicking on the corner (after having selected them) (with OOo,
there is a dialog which appear when we delete cells, but the popup for the copy
shouldn't be a dialog, it should be optional to choose an action)).
Comment 3 ace_dent 2008-05-16 01:42:20 UTC 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:
or consider trying the new OOo 3 BETA (still in testing):
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:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 4 fsamuels 2010-01-08 16:54:56 UTC
This is still an annoyance in version 3.1.1. My use case is I get a lot of
single column lists in XLS format. I would like to select the whole column to
copy it to a text file but it copies all 65,536 rows currently. To get around it
I have to manually scroll down to the last row of data to select just the non
empty rows. Excel does not copy empty rows in this case. If there are empty rows
between valid data, they should still be copied. The number of rows available is
an arbitrary technical limit. This will be more problematic when spreadsheets
grow even larger and have more empty rows to get copied.
Comment 5 sycer 2013-08-05 10:24:50 UTC
Problem is still existing and annoying.
Same problem bug as: Bug 90569