Issue 53182 - Select visible cells only button
Summary: Select visible cells only button
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m122
Hardware: All All
: P3 Trivial with 32 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: usability
: 26630 67851 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-08-10 18:09 UTC by mcanedo
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Screenshot Showing button in excel (31.41 KB, image/png)
2005-08-11 19:11 UTC, mcanedo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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!