Bug 269476 - Selecting an auto-filtered range also selects any hidden, filtered-out cells in the range
Summary: Selecting an auto-filtered range also selects any hidden, filtered-out cells ...
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: usability (show other bugs)
Version: Git
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-26 18:04 UTC by mikrephine
Modified: 2022-12-14 22:10 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description mikrephine 2011-03-26 18:04:10 UTC
Version:           svn (using KDE 4.6.1) 
OS:                Linux

When drag-selecting a range of Auto-Filtered cells, hidden (filtered-out) cells are also selected.

Reproducible: Always

Steps to Reproduce:
1. Create an empty spreadsheet.

2. In Column A, add the following cell data: 1, 2, 2, 3

3. Select all of Column A and hit the `Data->Filter->Auto Filter' menu item.

4. A drop-down appears at the top of Column A. Click it and filter the data so that 2's are hidden.

5. Select the entire column and copy it (Ctrl+C).

6. Paste the data in another spreadsheet.

Actual Results:  
The 2's are copied along with the other data, even though the 2's were filtered out and hidden.

Expected Results:  
The 2's should not be in the copied data. They should be part of the selection, because they were hidden.

Workaround: select each filtered cell manually by Ctrl+Clicking on it. But this is impractical for anything but the smallest spreadsheets.

Related bug: https://bugs.kde.org/show_bug.cgi?id=223639
Comment 1 Andrew Crouthamel 2018-11-05 03:16:25 UTC
Dear Bug Submitter,

This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond.

Thank you for helping us make KDE software even better for everyone!
Comment 2 Andrew Crouthamel 2018-11-17 04:52:14 UTC
Dear Bug Submitter,

This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand.

Thank you for helping us make KDE software even better for everyone!
Comment 3 Justin Zobel 2022-12-14 03:09:20 UTC
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version?

If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!