Bug 43583

Summary: The result of a standard filter is wrong in certain cases.
Product: LibreOffice Reporter: Starxpert <openoffice>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: medium    
Version: 3.3.4 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Allows to reproduce the bug with following instructions.

Description Starxpert 2011-12-07 09:02:36 UTC
Created attachment 54193 [details]
Allows to reproduce the bug with following instructions.

Make a standard filter with 2 criteria : 
- choose "Begins with" as condition for the first one
- choose "=" as condition for the second one

The result is the same than a filter using "Begins with" as first condition and
"Contains" as second condition.


To reproduce the bug on the attached document, apply the following filter on
the data range of the sheet "Feuille1" :

       Dummy2    Begins with    va
and    Dummy1    =              erreur

=> All lines that contain "erreur" are kept visible whereas only those which
match exactly "erreur" should remain visible.


However, if the two criteria are inverted, the result is correct.
Comment 1 Carl Michael Skog 2011-12-07 22:57:34 UTC
Can confirm this on Ubuntu Oneric(amd64) on an uptodate build.
Comment 2 pjacquod 2011-12-18 09:46:45 UTC
Hello, 
I confirm this on 3.4.2 on OpenSuse 11.4

BUT, please not that this but does not exists anymore on current master (which will be the source for 3.5.0). 
Very little chances 3.3.X will have a bug fix. 
3.4.5 will be released soon, but I doubt that this has been fixed there

To used a fixed version, I would recommend to pick 3.5.1 scheduled for  Mar 7, 2012 (Wed) if no one starts the job to find the change and backport it to 3.4.X line. (sadly, filter have been overhauled in an important way in 3.5, so it is difficult to find the right change.)
Comment 3 Markus Mohrhard 2011-12-19 18:53:43 UTC
If fixed by Kohei's rework we can reduce importance.
Comment 4 ign_christian 2013-06-09 15:39:04 UTC
Not reproducible on LO 4.0.4.1 (Win7 32bit)
Perhaps it's been fixed