Created attachment 133352 [details] Document with test macro 1. Open attached document 2. Run macro: VBAProject -> Modules -> Module1 -> AF Result: All data rows are hidden Expected: Only row containing "A" (row 2) should be hidden Used method in the macro: AutoFilter Field:=1, Criteria1:=">A", Operator:=xlFilterValues AutoFilter can only check if Criteria1 string is "equal to". Comparing with ">" "<" or "=" should be supported. Code pointer: http://opengrok.libreoffice.org/xref/core/sc/source/ui/vba/vbarange.cxx#4493
Hi Szymon, Criterial:"<>A" can be used. Help pages at Operators Standard Filters give other useful combinations. https://help.libreoffice.org/Common/Comparison_Operators Jacques
I can confirm with Version: 6.0.0.0.alpha0+ Build ID: e808bbe1ce51465e6f3e9dc4fec2ecd263fe0e4b CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still confirmed in: Version: 7.0.0.0.alpha0+ (x64) Build ID: dbd74393fd0b4d11655e2c4d2676ec1bfebe8923 CPU threads: 6; OS: Windows 10.0 Build 17134; UI render: Skia/Vulkan; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: CL Code pointer: https://opengrok.libreoffice.org/xref/core/sc/source/ui/vba/vbarange.cxx?r=9d4c36d7#4338
https://gerrit.libreoffice.org/c/core/+/91834
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/59374ea361815b022b1f2a415f995852f23f222e tdf#107885 - VBA AutoFilter can't compare strings It will be available in 7.1.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.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/978862b99ca7af6a17012084923494b6c85754d5 Use OUString::toChar(), tdf#107885 follow-up It will be available in 7.1.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.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/a7cf65ac009819cb6ae3c08e5fe3f496ef31260a tdf#107885 - VBA AutoFilter can't compare strings It will be available in 7.0.0.2. 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.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e58cab418349a43ea788d0a4f5ba26097b377d2c tdf#107885: sc_macros_test: Add unittest It will be available in 7.1.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.
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f013b5127e3048914d829cf918df2a43f133d108 tdf#107885: sc_macros_test: Add unittest It will be available in 7.1.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.