Bug 36466

Summary: Copying Visible Cells Only
Product: LibreOffice Reporter: Lito Macatunao <lito.macatunao>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: gbpacheco, immanacled, libreoffice, libreoffice, miniopl, quikee, ugostray
Version: 3.3.0 release   
Hardware: Other   
OS: All   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=53182
Whiteboard: EasyHack feature
i915 platform: i915 features:

Description Lito Macatunao 2011-04-21 09:27:13 UTC
Please create a functionality wherein we can just select and copy the visible cells only just like in MS Office wherein you just have to:  EDIT==> GO TO==>  SPECIAL==>  VISIBLE CELLS ONLY

Please fix this, thanks!
Comment 1 Muthu 2011-05-04 23:15:44 UTC
One for kohei? -> requirements.

Also a candidate for easyhacks.

Starting point: ScViewFunc::CopyToClip(...) in viewfun3.cxx
Comment 2 Kohei Yoshida (inactive) 2011-05-05 07:23:17 UTC
(In reply to comment #1)
> One for kohei? -> requirements.
> 
> Also a candidate for easyhacks.
> 
> Starting point: ScViewFunc::CopyToClip(...) in viewfun3.cxx

Well, not exactly.  This feature request calls for *selecting* only visible range, so we shouldn't modify the copy behavior directly but provide a means to select specific cell range.  FWIW Excel's "go to" functions (not just this one) are something we are missing entirely, so that's something we should consider as new features.
Comment 3 Gustavo Pacheco 2011-09-07 17:26:22 UTC
@Lito Macatunao

You can try the 'Copy only visible cells' extension as a *workaround*:
http://extensions-test.libreoffice.org/extension-center/copy-only-visible-cells

It is *not a definitive solution* but may helps you. Any comments, contact me at the extension webpage (for example, to add your language in the extension).
Comment 4 Björn Michaelsen 2011-12-23 12:02:36 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 5 Björn Michaelsen 2011-12-23 12:57:24 UTC
An EasyHack should have been checked by developers and thus is confirmed regardless of age. Moving back to NEW from NEEDINFO again. Sorry for the hassle.
Comment 6 Florian Reisinger 2012-05-18 09:44:42 UTC
Deleted "Easyhack" from summary.
Comment 7 Mirosław Zalewski 2013-08-16 21:16:29 UTC
I have added link to "canonical" bug report on AOO bugzilla in "See Also"; so, in case they make this change first, it might be easier to track patch and backport it to LO.

Also, as you can see, it has been almost ten years since people first requested this feature for OOo.
Comment 8 Björn Michaelsen 2013-10-04 18:47:01 UTC
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility.

see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
Comment 9 Kevin Suo 2014-04-25 15:22:07 UTC
*** Bug 71518 has been marked as a duplicate of this bug. ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.