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.
@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).
[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
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. http://extensions.libreoffice.org/extension-center/copy-only-visible-cells 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 ) [NinjaEdit]
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.
*** Bug 125731 has been marked as a duplicate of this bug. ***
I agree with Timur (comment 17), I also think that the select of visible cell is a better option. Thanks
Changing priority back to 'medium' since the number of duplicates is lower than 5
*** Bug 130052 has been marked as a duplicate of this bug. ***
(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
I'd like to add my vote for it.
Fixed for the cells for the hidden rows by the new option Edit->Select->Select Visible Cells Only I suggest to separate handling of hidden rows and hidden columns via the following menu options: Select Visible Rows Only Select Visible Columns Only Select Visible Cells Only
(In reply to László Németh from comment #24) > Fixed for the cells for the hidden rows by the new option > Edit->Select->Select Visible Cells Only > > I suggest to separate handling of hidden rows and > hidden columns via the following menu options: > > Select Visible Rows Only > Select Visible Columns Only > Select Visible Cells Only Tünde has reported, that it's not possible to select the combination. So it's better to use only Select Cells of Visible Rows Select Cells of Visible Columns or adding only the more frequent first one, as originally implemented by Tünde.
Hi. Any solution would be an improvement but I don't understand this that combination cannot be selected. I tested Gustavo extension and it seems to handle all cells in a range with both rows and columns hidden.
for me we got a very strange implementation : 1. It just doesn't work for me now. 2. I would prefer only ONE menu item "Copy only visible cell" at once without any intermediate actions.
Roman, I don't get it. I asked for Select not Copy because of cut. And it should be in Edit-Select. I guess it's still not implemented so I tested with extension.
The problem is not that it is not possible to select but that it is not possible to copy. For example: - go into Calc and make a multi row and column selection - from that selection remove one column in the middle and one row in the middle This is the exact situations you get when you have hidden rows and columns. If you try to copy that you will get a pop-up dialog "This function cannot be used with multiple selections." I guess it is a fundamental limitation in Calc and not that easy to solve. OTOH... it is not "Select Visible Cells Only" problem that copying doesn't work. For example if we run any other action on the selection like "clear content", "delete" or change the background color, it works as expected. BTW. I modified the code to do the selection of cols too... I will attach the diff.
Created attachment 169967 [details] Diff to enable selecting columns too
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6ab08b3b1026a582352ea018b9d59e91d3e86d92 tdf#36466 sc UI: add new options to deselect hidden cells It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
With thanks, I'd still like to see an explanation how Gustavo extension can copy visible cells from an area with both hidden row and column (situation from comment 29), in a single command.
With thanks, I'd still like to see an explanation how Gustavo extension can copy visible cells from an area with both hidden row and column (situation from comment 29), in a single command. Fix makes 2 commands from Comment 25. If we have 3x3 cells with middle column abd row hidden, simply copy will make 3x3 cells, extension 2x2 cells and those two commands 2x3 or 3x2 cells.
The extension copies the selection into a new sheet, then deletes the hidden rows and columns, then copies that. I'm sure there are cases this would fail dramatically with certain formulas... It is possible to have only one command as I described previously, because the problem is not with selection - selection can work fine for either rows or columns, but any attempt to copy or cut a selection range that has holes in columns AND rows would fail with an error message. That's just the limitation of copying in LibreOffice (which could be solved at some point - or at least solved for some cases). IMHO splitting this into 2 separate commands wasn't a solution I prefer.
Verified in: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 72841008bf422dfd8553240b3a78f0474d03523c CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded Jumbo
The status bar keeps tracking the number of rows selected _before_ you click Edit->Select->Select Visible Rows Only Clicking that button should update the number of selected rows reported in the status bar, IMHO
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3453f2f8fce9e69cd9f2a2c6f3d7171b6e59f674 tdf#36466 sc: update status bar at Select Visible Rows It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Added to the release notes: https://wiki.documentfoundation.org/index.php?title=ReleaseNotes/7.2&diff=376201&oldid=376070 Tünde: I've noticed that the status bar does update when using this new function, but it doesn't show anything in my case. (Instead of showing the updated number of rows and columns.) Is that known?
@Tünde Tóth: Congratulations and celebrations. This must have been tricky to do. Thanks a lot! Usage seems to be as follows: 1. Highlight the area which contains hidden rows (e.g. after grouping and hiding group levels) 2. Edit->Select->Select Visible Rows Only. Note that the Status bar now shows only the number of visible cells 3. Hit Ctrl+C to copy the visible cells 4. Paste where needed
The help pages do not reflect this new feature yet: https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellcopy.html?DbPAR=CALC#bm_id3150440 I'll try to send a fix.
(In reply to Dietrich Schulten from comment #40) > The help pages do not reflect this new feature yet: > https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellcopy. > html?DbPAR=CALC#bm_id3150440 > > I'll try to send a fix. Ideally you create a new ticket against documentation with a reference to this issue first. Great that you want to submit a patch yourself!
I have created https://gerrit.libreoffice.org/c/help/+/135541 and published the changes. Anything missing?
Dietrich Schulten committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/2f46574a53e1d22e302dc343218ea3ed1ba610b8 Relates tdf#36466 - Update help about copying visible cells only
Dietrich Schulten committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/help/commit/b54a984fc6467e74ef705162c7f112aa87e8ce4e Relates tdf#36466 - Update help about copying visible cells only