I checked with LibreOffice 3.3.0 - WIN XP DE [OOO330m9 (Build:1 - build 18.104.22.168)]
I have been used to unfilter clicking menu 'Data -> Filter -> Remove Filter'
Now I find this menu item always greyed out
Steps to reproduce:
1. download and open attached "sample.ods"
2. Click filter button for column 2
3. Filter for "2"
all rows with "2" will be shown
3. Menu 'Data -> Filter -> Remove Filter'
Expected: option possible
Actual: greyed out
Same with my "Remove Filter" button in task bar.
Works fine for Standard Filter
Works fine with "Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [OOo330m10 (Build 9533)]"!
Created attachment 39482 [details]
Isn't this now Data->Filter->Auto Filter (since this is now a checkbox?)
Click on it again to remove the autofilter.
Please let us know if that is what you are looking for. Thank you!
I can't see the problem to find out what my needs are.
I do not want to remove the auto filter, I do want to see all data without filter, for that menu 'Data -> Filter -> Remove Filter' is required.
I can't see any checkbox at Data->Filter->Auto Filter, can you please provide a screenshot?
Funny thing, today every thing works as expected, I will try to find out what circumstances cause the problem I saw.
Created attachment 39499 [details]
Screen shot for removing autofilter.
In some cases the checkbox would be a icon (the icon button might look to be pressed or released depending on the state of the autofilter).
Yes, I have the icons, and with much fantasy I can distinguish "pressed" and "unpressed".
But as I wrote, I'm talking about problems with item "Remove Filter", that still sometimes does work and sometimes does not.
Remove filter would be enabled when you filter something using the auto-filter.
If you are still facing problems, it would be great if you could provide us more information on the problem. Thank you!
Please! I have been using OOo for several years, I know how such filter should work.
You will find all available information in my report and comments, including that the problem is not 100% reproducible.
I stopped using beta2 because of bug 30905, so even if it would be possible to find additional information - I can't do that before the next build.
kohei for you?
I can think of two things:
1) maybe the cell cursor was positioned outside the filtered area in which case the Remove Filter entry is grayed.
2) the original file was imported from an xls file, which may set the data base range smaller than the actual data range. And somehow that's interfering with the state of the Remove Filter menu item.
other than that, I can't reproduce this problem, so I'm tempting to mark this WORKSFORME...
Just to say that I just saw this happen on me when I was messing with autofilter, but I don't remember what I did. :-/
I haven't seen that for weeks, but currently I do not use filter function very often.
When I saw the problem, I clicked into the filter heading to be sure that the cell cursor isn't outside the filter area, because - of course - that happens sometimes during my daily work. That did not heal the problem.
Currently I still try to reproduce the problem from time to time, without success.
Now I use Beta3 for my daily work, if I can't find out more details, I will close this bug end of November.
Created attachment 40503 [details]
Today I see it again. In one of my "real life" spreadsheets after a while I lost the "Remove Filter" Function. But it was not reproducible with same time opened sample document for this bug report
Another attempt to provide a sample document. I checked with "LibreOffice 3.3.0 RC2 - WIN7 Home Premium (64bit) German UI [OOO330m18 (build 22.214.171.124)]"
1. open document
2. Press filter button for column "Artikel"
3. select 'Standard Filter'
Unexpected: already contents in 'Value', I see that effect in all
documents where I see that problem, and the problem does not
appear with OOo 3.1.1
I don't know any method to
11. Replace filter Value contents "Relais" and proceed filter
as expected, only rows with "Relais" in column 'D' will be shown
12. click into 'D367'
13. Watch button "remove filter" in Standard Toolbar.
actual: greyed out
14. Try menu 'Data -> Filter - Remove Filter Toolbar.
actual: greyed out
15. Watch Filter Button in column 'D'
actual: no filter color
21. Press filter button for column "Artikel"
22. select 'All'
As expected filter will be removed
23. Redo from step 2., you should see the same unexpected effects.
As I told, whith OOo 3.1.1 filter of that document works without problems
Created attachment 41933 [details]
Pls see Comment 14
can you help?
Info provided, and let's set the target to 3.4.
I think I figured this out.
The short answer is, this is probably not a bug.
When you have autofilter set to a named database range, you can't remove autofilter; you can only hide it. You can remove autofilter only when you have it set to an un-named database range.
To check whether the database range is named, set the cell cursor to a cell within the database range, and go to Data - Define Range. It should highlight the current named range where the cursor is in.
However, this may be a usability bug. To me, hiding and removing autofilter should be combined into just one "remove autofilter". It would be nice to know the original rationale behind this behavior though...
Technically this is not a bug. So, I'll close it as such.
If this poses a usability concern, please file a new bug.
If you think there is no bug please explain how I can get work reliable step 3 of this comment.
Be sure, this is a bug, but it seems that I failed to explain the problem.
It seems there is some misunderstanding concerning the problem, reason might be ambiguity of words like "remove" or "hide"
Do we really talk about the same situation?
1. I use Autofilter to show only some particular interesting data
That works fine
2. Now I want to switch back to primary view with all data.
3. For this I have to use menu 'Data > Filter > Remove Filter' or alternatively
the function that can be added to the toolbar.
This does not remove Autofilter (the buttons will remain), but the filter
will be switched to a "show all mode"
This works with LibO for several documents and several cases, and several
times, sometimes with some documents it does not work with LibO. I doubt
that your comment is concerning such an intermitting problem.
This works with perfectly with all OOo versions and all other spreadsheets I
used the last 20 years in the same way.
I would have liked to create a more demonstrative demo than my attached screenshots, but just now everything works fine. Yesterday the same problem caused some additional grey hairs for me ...
To be honest, I do not understand at all what you want to tell me in Comment 18. That I use CALC filters in a wrong way?
If there are problems to understand my problem I can give you remote access to my PC so that you can see the problem.
Ok. I'll be honest with you. I couldn't reproduce the problem in comment 14. So, I'm also confused. Your step 11 is where I failed to reproduce. There is no data "Ralais" in the test document.
RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO.