Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Empty cells shouldn't be copied when a complete column is selected | ||
---|---|---|---|
Product: | Calc | Reporter: | the_redburn <tbertels+bugzilla> |
Component: | ui | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | forrest, issues, sycer |
Version: | OOO 2.0 Beta2 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
the_redburn
2005-08-31 22:07:14 UTC
Hi, 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. Frank 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)). OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html 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. |