Bug 92125 - Copy of filtered data pastes non-visible data too
Summary: Copy of filtered data pastes non-visible data too
Status: RESOLVED DUPLICATE of bug 45958
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: x86 (IA32) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Clipboard
  Show dependency treegraph
 
Reported: 2015-06-16 22:35 UTC by Joe Nahmias
Modified: 2018-07-10 17:46 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
spreadsheet to demonstrate problem (5.80 KB, application/vnd.openxmlformats-officedoc)
2015-06-16 22:36 UTC, Joe Nahmias
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Joe Nahmias 2015-06-16 22:35:03 UTC
When you have a spreadsheet with filtered data in multiple columns and you try to copy and paste data from non-consecutive columns, Calc pastes in all the data -- even the non-visible / filtered data.
Comment 1 Joe Nahmias 2015-06-16 22:36:20 UTC
Created attachment 116596 [details]
spreadsheet to demonstrate problem
Comment 2 Joe Nahmias 2015-06-16 22:40:14 UTC
Steps to reproduce:

1 - Open the attached spreadsheet bug92125-Test_Case.xlsx
2 - Filter column A so that only rows with Good are showing
3 - Highlight columns A & C (excluding B) using ctrl-click on the column headers
4 - Copy
5 - Open new worksheet (or workbook for that matter)
6 - Paste
7 - notice that the BAD rows that were filtered out / invisible on the original sheet have magically appeared on the new sheet
Comment 3 Joe Nahmias 2015-06-16 22:45:26 UTC
Note that in the example if you include column B (Junk), then Calc will correctly only copy/paste the visible (selected for) rows.
Comment 4 Buovjaga 2015-06-17 09:14:36 UTC
Reproduced.

Lowered severity as workaround exists https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: 80ec99db4325a439a8a3f1d420d0a80f8bf9c439
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-06-16_00:00:20
Locale: fi-FI (fi_FI)
Comment 5 Terrence Enger 2015-06-17 17:30:24 UTC
----
I see the reported behavior in the dbgutil bibisect version 2015-06-16 ...
    Version: 5.1.0.0.alpha1+
    Build ID: 80ec99db4325a439a8a3f1d420d0a80f8bf9c439
    Locale: en-CA (en_CA.UTF-8)
so am setting O/S=All

I also see the problem in
    LibreOffice 3.5.4.2 
    Build ID: 350m1(Build:2)
so am setting version=3.5.4 release
Comment 6 m_a_riosv 2017-04-22 14:24:53 UTC
*** Bug 107348 has been marked as a duplicate of this bug. ***
Comment 7 m_a_riosv 2017-04-22 14:31:34 UTC
There is an extension to do it.
https://extensions.libreoffice.org/extensions/copy-only-visible-cells

But doesn't work with paste special transpose.
Comment 8 Timur 2018-02-21 12:42:22 UTC

*** This bug has been marked as a duplicate of bug 45958 ***