https://bugs.documentfoundation.org/show_bug.cgi?id=107885
Bug ID: 107885
Summary: VBA AutoFilter can't compare strings
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 133352
--> https://bugs.documentfoundation.org/attachment.cgi?id=133352&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
