Bug 36466 - Copying Visible Cells Only
Summary: Copying Visible Cells Only
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL: https://help.libreoffice.org/Calc/Onl...
Whiteboard: feature
: 71518 115889 (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: 2018-07-10 18:07 UTC (History)
10 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. ***