There is almost no indication that Autofilter was applied ...
Only one blue triangle on top ... But it should be at least like in Excel:
Blue triangle and blue row numbers when Autofilter selected!
Thank you in advance!
Because when you are searching for some values and autofilter is applied and the value is in others cells (then these applied) you do not get any results like your value do not exist!!!
And you can draw really bad conclusions; Like I did :(((
Thank you in advance!
valid enhancement, setting to new.
*** Bug 122349 has been marked as a duplicate of this bug. ***
This is what it looks like in Excel, see section "How to apply filter in Excel":
Let's add the UX team for guidance.
Created attachment 152751 [details]
Shadow around filtered cells
The border might be used (and we shouldn't just copy) so how about a shadow? By doing this we could also get rid of the triangle in fully saturated blue and use some default color.
bug 76389 might be solved when this is being touched.
Created attachment 169350 [details]
Blue row numbers
Screenshot about the result of this commit: https://gerrit.libreoffice.org/c/core/+/110130
*** Bug 138929 has been marked as a duplicate of this bug. ***
great job, finally it will not be necessary to check all columns if the autofilter is off.
Will the blue tint also work for a standard filter?
I am 51 and my eyesight is not so good as it was.
On the autofilter I find it very difficult to see the difference between the black arrow and the blue one. The dot is also very small.
Would you consider colouring the whole square icon blue, to make it easy to see which columns are filtered please?
I'll add an example as a attachment
Created attachment 169363 [details]
Mockup of whole autofilter being blue
I find it very difficult to see the difference between the blue and black arrows on the autofilter. I also find the small dot difficult to see.
Would you consider making the whole box blue (perhaps with a white arrow) to make the filter much more obvious?
(In reply to kabilo from comment #7)
> Will the blue tint also work for a standard filter?
I compiled the patch and unfortunately it does not. I'll file a new bug about that - and also about the fact that an applied standard filter is currently not visible at all.
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#89841 sc UI: show blue row numbers for filtered rows
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Version: 22.214.171.124.alpha0+ (x64) / LibreOffice Community
Build ID: d97528da0c70c43fccd3239cbe8e064c3480bba8
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Thanks for implementig it, Tünde Tóth
Created attachment 178156 [details]
screenshot showing the mess
Would you guys reconsider this feature? Showing a long dashed lines on each filtered cell is toooooooooooo bad. See the attached screenshot.
We already have colored row labels indicating that a filter is set, why do we need to show another indication?
(In reply to Kevin Suo from comment #13)
> Would you guys reconsider this feature? Showing a long dashed lines on each
> filtered cell is toooooooooooo bad. See the attached screenshot.
The change you're referring to was introduced with the following commit, therefore your comment would be better directed in bug 128258.
author Heiko Tietze <email@example.com> 2022-01-18 12:20:57 +0100
committer Heiko Tietze <firstname.lastname@example.org> 2022-01-27 10:31:52 +0100
Resolves tdf#128258 - Draw a dotted line before hidden columns/rows
Created attachment 181764 [details]
People that use dark themes now have problems
The "blue row numbers" screenshot looks good using light themes
Although people that use dark themes now have problems.
Created attachment 181765 [details]
Problems even using Tools - Options - LibreOffice - Application Colors - LibreOffice Dark
People that use dark themes now have problems, even using "Tools ▸ Options ▸ LibreOffice ▸ Application Colors ▸ LibreOffice Dark".
(In reply to Ganton from comment #16)
> Created attachment 181765 [details]
> Problems even using Tools - Options - LibreOffice - Application Colors -
> LibreOffice Dark
> People that use dark themes now have problems, even using "Tools ▸ Options ▸
> LibreOffice ▸ Application Colors ▸ LibreOffice Dark".
Please open a separate ticket for this issue.
(In reply to Gabor Kelemen (allotropia) from comment #17)
> Please open a separate ticket for this issue.
Done with bug 150413
(In reply to Heiko Tietze from comment #18)
> Done with bug 150413
And it has been solved for bug 147515. The upcoming version 7.4 should solve the problem.
line numbers are not highlighted (blue row numbers) when the workbook is opened with the filter active.