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! WHY: 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": https://www.ablebits.com/office-addins-blog/2016/08/31/excel-filter-add-use-remove/ 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. ***
Hi, 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? Thanks
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? Thanks
(In reply to kabilo from comment #7) > Will the blue tint also work for a standard filter? Hi 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": https://git.libreoffice.org/core/commit/9bba5f418d4900ba20503dd1d310b3ff68bb14df 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.2.0.0.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 Calc: CL Thanks for implementig it, Tünde Tóth
Created attachment 178156 [details] screenshot showing the mess Oh my... 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. https://cgit.freedesktop.org/libreoffice/core/commit/?id=ba0100be03c6bbc5ae10201bae340b3f7b7c4500 author Heiko Tietze <tietze.heiko@gmail.com> 2022-01-18 12:20:57 +0100 committer Heiko Tietze <heiko.tietze@documentfoundation.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 https://bugs.documentfoundation.org/attachment.cgi?id=169350 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.
See: https://bugs.documentfoundation.org/show_bug.cgi?id=143833