Ask Your Question

Using Standard Filter Destroys Data in Unselected Columns [closed]

asked 2018-10-08 02:37:18 +0200

fcp2000 gravatar image

updated 2020-08-06 20:28:52 +0200

Alex Kemp gravatar image

image description image description image description

Why is the standard filter doing this? I am totally unable to do any kind of filtering on column H which I have named "Returns" without losing massive amounts of unrelated data on my spreadsheet.

The pictures show a progression of what happens as I attempt to search for data in between my upper and lower values for Standard Deviation. I can't even use the COUNT function to measure my total results because using the filter just deletes everything until I undo it. It isn't simply these parameters, pretty much none of the filter choices work the way they are supposed to. I have also tried highlighting only portions of data in H which has the same result.

Am I missing something here? I am running Version: on Linux if that makes any difference. I can't really figure out why its struggling to filter one column, im hoping its something small that differs from Excel that I overlooked and not an actual bug. Thank you in advance for any help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by fcp2000
close date 2018-10-08 02:56:25.017954

1 Answer

Sort by » oldest newest most voted

answered 2018-10-08 02:43:28 +0200

Well, if you try and look closer, you would see that the rows are hidden (row heights become 0), not destroyed. That's why there are that strange sequence of row numbers there (1,2,6,13,16,17,...)

Filtering is just hiding rows.

edit flag offensive delete link more


ah i see, so it lacks the ability to spare later rows, well at least thats easy enough to workaround, thanks

fcp2000 gravatar imagefcp2000 ( 2018-10-08 02:52:49 +0200 )edit

Question Tools

1 follower


Asked: 2018-10-08 02:37:18 +0200

Seen: 65 times

Last updated: Oct 08 '18