Bug 36466 - Add option to Select Visible Cells Only (to be copied from or copied to)
Summary: Add option to Select Visible Cells Only (to be copied from or copied to)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: high enhancement
Assignee: Not Assigned
URL: https://help.libreoffice.org/Calc/Onl...
Whiteboard: feature
: 71518 115889 125185 125731 130052 (view as bug list)
Depends on:
Blocks: Calc-Enhancements Calc-Cells Cut-Copy
  Show dependency treegraph
Reported: 2011-04-21 09:27 UTC by Lito Macatunao
Modified: 2020-02-13 10:22 UTC (History)
18 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
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 Comment hidden (obsolete)
Comment 2 Kohei Yoshida 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*:

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 Comment hidden (obsolete)
Comment 5 Björn Michaelsen 2011-12-23 12:57:24 UTC Comment hidden (obsolete)
Comment 6 Florian Reisinger 2012-05-18 09:44:42 UTC Comment hidden (obsolete)
Comment 7 Mirosław Zalewski 2013-08-16 21:16:29 UTC Comment hidden (obsolete)
Comment 8 Björn Michaelsen 2013-10-04 18:47:01 UTC Comment hidden (obsolete)
Comment 9 Kevin Suo 2014-04-25 15:22:07 UTC
*** Bug 71518 has been marked as a duplicate of this bug. ***
Comment 10 Gerry 2015-07-21 07:35:19 UTC
From my observations of LO Calc users, copying VISIBLE CELLS ONLY is a basic feature for a spreadsheet, which many people really miss. 

Therefore, I would like to ask the developer team, whether it is possible to include the extension "Copy only visible cells" in the core LibreOffice software.


I think this inclusion of this small feature is justified, because users perceive this as core functionality and even don't get the idea themselves that this small feature might be supplied by an extension. Thanks!
Comment 11 Robinson Tryon (qubit) 2015-12-14 07:01:31 UTC Comment hidden (obsolete)
Comment 12 Eike Rathke 2016-01-26 17:37:33 UTC
This is not an EasyHack, removing keyword.
Comment 13 Dietrich Schulten 2017-04-01 10:59:36 UTC Comment hidden (obsolete)
Comment 14 Roman Kuznetsov 2017-10-22 17:50:49 UTC
(In reply to Dietrich Schulten from comment #13)
> Since LO 5.2 the CopyVisibleCells extension no longer works for subtotals,
> it copies the formulas, not the formula results, and when pasting the copy,
> the formulas are broken.
> Please consider to make this a native feature.

Gustavo fixed this problem and made extension version 2.0. It works fine now. But would't be cool if developers will include this functional in LibreOffice
Comment 15 Timur 2018-04-02 09:08:43 UTC
*** Bug 115889 has been marked as a duplicate of this bug. ***
Comment 16 Timur 2019-05-13 13:09:20 UTC
*** Bug 125185 has been marked as a duplicate of this bug. ***
Comment 17 Timur 2019-05-13 13:14:01 UTC
I changed the title for an option from "Copying Visible Cells Only" to "Select Visible Cells Only". Similar to comment 2. 
Gustavo's extension is nice and useful but I thing wrong in that it copies and not selects. Sometimes we need visible range as a destination. Paste should always be same and selecting doubles the usefulness. So I hope to have version 3 of the extension.
Comment 18 Roman Kuznetsov 2019-06-06 19:22:58 UTC
*** Bug 125731 has been marked as a duplicate of this bug. ***
Comment 19 kabilo 2019-06-06 20:14:41 UTC
I agree with Timur (comment 17), I also think that the select of visible cell is a better option. Thanks
Comment 20 Xisco Faulí 2019-11-29 13:29:26 UTC Comment hidden (obsolete)
Comment 21 Timur 2020-01-17 14:29:02 UTC
*** Bug 130052 has been marked as a duplicate of this bug. ***
Comment 22 Axel Braun 2020-01-17 16:01:02 UTC
(In reply to Xisco Faulí from comment #20)
> Changing priority back to 'medium' since the number of duplicates is lower
> than 5

Now it is 5....and the issue is 9 (!) years old
Comment 23 thatho 2020-02-13 10:22:04 UTC
I'd like to add my vote for it.