Bug 269476

Summary:	Selecting an auto-filtered range also selects any hidden, filtered-out cells in the range
Product:	[Applications] calligrasheets	Reporter:	mikrephine
Component:	usability	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	CONFIRMED ---
Severity:	normal	CC:	mecirt, mikrephine
Priority:	NOR
Version First Reported In:	Git
Target Milestone:	---
Platform:	Compiled Sources
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

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!