Bug 58520 - FILTER: Operators filter EMPTY and NOT_EMPTY
Summary: FILTER: Operators filter EMPTY and NOT_EMPTY
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.4.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-12-19 15:13 UTC by philippe.schmidlin
Modified: 2013-06-10 06:27 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description philippe.schmidlin 2012-12-19 15:13:13 UTC 
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
Comment 1 Markus Mohrhard 2012-12-26 19:00:27 UTC 
Can you please tell us in which version it worked?
Comment 2 philippe.schmidlin 2012-12-26 19:32:52 UTC 
It worked with Windows 8 and Libre Office 3.6.4





> Message du 26/12/12 20:00
> De : bugzilla-daemon@freedesktop.org
> A : philippe.schmidlin@orange.fr
> Copie à : 
> Objet : [Bug 58520] FILTER: Operators filter EMPTY and NOT_EMPTY
> 
>
>

Comment # 1 on bug 58520 from Markus Mohrhard 
Can you please tell us in which version it worked?

You are receiving this mail because:

You reported the bug.
Comment 3 Markus Mohrhard 2012-12-27 02:32:19 UTC 
(In reply to comment #2)
> It worked with Windows 8 and Libre Office 3.6.4
> 

Why do you report the bug then against version 3.6.4?
Comment 4 philippe.schmidlin 2012-12-27 17:02:46 UTC 
The bug is existing en 3.6.3 and windows 8

 

Before, I'll never work in Libre Office because I'll work with Windows XP SP3 and Microsoft Office 97






> Message du 27/12/12 03:32
> De : bugzilla-daemon@freedesktop.org
> A : philippe.schmidlin@orange.fr
> Copie à : 
> Objet : [Bug 58520] FILTER: Operators filter EMPTY and NOT_EMPTY
> 
>
>

Comment # 3 on bug 58520 from Markus Mohrhard 
(In reply to comment #2)
> It worked with Windows 8 and Libre Office 3.6.4 > Why do you report the bug then against version 3.6.4?

You are receiving this mail because:

You reported the bug.
Comment 5 ign_christian 2013-06-10 06:27:30 UTC 
set RESOLVED WORKSFORME per comment 2

Please change status of this bug to: REOPENED if that problem still persists in latest stable release