Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Select visible cells only button|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||gbpacheco, issues, kpalagin, mailinglists|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description mcanedo 2005-08-10 18:09:31 UTC
Hi: Calc should have a select only visible cells as excel does. I know that it's doable if the hidden cells come from a filter. But that is not enought. That option should be extended to scheamas and manual hidden. Regards, Miguel
Comment 1 frank 2005-08-11 08:08:06 UTC
Hi Miguel, please be more precise. I've checked it with manual hiden rows and columns and was not able to select these cell with the cursor or the mouse. Please describe step by step what you want to do. Thanks Frank
Comment 2 mcanedo 2005-08-11 19:01:47 UTC
Hi Frank: Excel has a button, wich certainly is not by default in the toolbars, but that can be added to any toolbar, it's called "Select Visible Cells". This button selects only the visible cells no matter ohow they have been hidden, then you can copy, delete, or whatever action, with those cells only. Thanks Miguel
Comment 3 mcanedo 2005-08-11 19:11:49 UTC
Created attachment 28671 [details] Screenshot Showing button in excel
Comment 4 frank 2005-08-12 08:39:37 UTC
one for the requirements team
Comment 5 kpalagin 2007-02-10 06:08:52 UTC
*** Issue 67851 has been marked as a duplicate of this issue. ***
Comment 6 kpalagin 2007-02-10 06:13:36 UTC
Additional information - the feature in Excel that selects only visible cells is called via Edit > Go To. Click Special. Click Visible Cells Only. Click OK. Dear developers please consider such feature as it would make certain tasks much easier.
Comment 7 johnmheinzel 2008-05-22 18:48:49 UTC
Simply selecting visible cells will not be enough. The ability to copy those visible cells, or cut them, or move them is what makes Select Visible useful. Currently the copy function cannot be used with multiple selections. For instance, a subtotal is done, the groups are collapsed so only the totals show, then Select Visible is used to select just the totals, then these are copied and pasted onto another sheet.
Comment 8 taras7t 2008-06-16 09:15:38 UTC
The "OOo Later" target milestone has me worried that the weight of this feature is undervalued. If it had not been for the lack of this feature I would have trashed Excel long ago. The lack of this is all that's holding me back. Real world problems: Report Subtotaled from hundreds of values and your boss only cares about the totals. He wants them in an email. Subtotals of measurement collections need to be transferred to another sheet for further processing. Examples are from previous and current work experience. This feature is Highly essential.
Comment 9 algaspb 2008-12-04 07:46:24 UTC
join , question very important
Comment 10 kpalagin 2008-12-15 07:44:20 UTC
*** Issue 26630 has been marked as a duplicate of this issue. ***
Comment 11 katbyrne 2010-07-06 01:49:38 UTC
This previous commenter said it perfectly. "If it had not been for the lack of this feature I would have trashed Excel long ago. The lack of this is all that's holding me back." "Real world problems: Report Subtotaled from hundreds of values and your boss only cares about the totals. He wants them in an email." I need the visible data from subtotals!!! I need visible data from manually selected rows or columns. Please fix this so Excel can die!