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!
One for kohei? -> requirements.
Also a candidate for easyhacks.
Starting point: ScViewFunc::CopyToClip(...) in viewfun3.cxx
(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.
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).
[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:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
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.
Deleted "Easyhack" from summary.
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.
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
*** Bug 71518 has been marked as a duplicate of this bug. ***
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!
Migrating Whiteboard tags to Keywords: (EasyHack )
This is not an EasyHack, removing keyword.
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.
(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
*** Bug 115889 has been marked as a duplicate of this bug. ***
*** Bug 125185 has been marked as a duplicate of this bug. ***
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.