https://bugs.freedesktop.org/show_bug.cgi?id=58520
Priority: medium
Bug ID: 58520
Keywords: regression
Assignee: [email protected]
Summary: FILTER: Operators filter EMPTY and NOT_EMPTY
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Spreadsheet
Product: LibreOffice
Problem description: In macros Libre Office, operators EMPTY and NOT_EMPTY does
not run correctly. In the two cases, return all records
Steps to reproduce:
sub FiltrePlage(NomZone as String, Col as integer)
dim Plage as object, Filtre as object
dim ChampFiltre(0) As New com.sun.star.sheet.TableFilterField
'Accès à une plage de données par son nom
Plage = thiscomponent.DatabaseRanges.getByName(NomZone)
'Crée un descripteur de filtre vide sur la plage référencée
Filtre = Plage.referredCells.createFilterDescriptor(true)
with Filtre
.ContainsHeader = true 'La 1ère ligne = en-tête de colonnes
.UseRegularExpressions = True 'Utilise les expressions régulières
end with
with ChampFiltre(0)
.Field = Col
.Operator =com.sun.star.sheet.FilterOperator.EMPTY
end with
Filtre.setFilterFields(ChampFiltre()) 'Passe les paramètres
Plage.referredCells.filter(Filtre) 'Applique le filtre
Current behavior: returns all records
Expected behavior:
Operating System: Windows (other)
Version: 3.6.4.3 release
Last worked in: 3.6.3.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
