Bug 33190

Summary: Auto Filter uses outdated data range
Product: LibreOffice Reporter: Gökçen Eraslan <gokcen.eraslan>
Component: SpreadsheetAssignee: Katarina Behrens <bubli>
Status: RESOLVED WORKSFORME QA Contact:
Severity: normal    
Priority: medium CC: LibreOffice
Version: 3.3.0 RC3   
Hardware: All   
OS: All   
Whiteboard: (target:4.0.0)
i915 platform: i915 features:
Attachments: Document to reproduce the problem

Description Gökçen Eraslan 2011-01-16 10:41:55 UTC
Created attachment 42105 [details]
Document to reproduce the problem

In libreoffice RC2, filtering was working OK, but in RC3 it doesn't work well.

In the attached file, when I try to list all "ccc" lines only, it also lists "aaaa", "ddd", "eee" and "fff" entries in addition to "ccc" entries. 

In LibreOffice RC2, when I try to list only "ccc" entries, just those entries were listed.
Comment 1 Rainer Bielefeld Retired 2011-01-16 22:07:21 UTC
[Reproducible] with "LibreOffice-filter.ods" and "LibreOffice 3.3.0 RC3 - WIN7  Home Premium (64bit) German UI  [OOO330m19 (build 5 / tag 3.3.0.3)]". 
I see a diference between RC2 and RC3, when I simply use the filter button in column "CINSI" and select "ccc"
- RC2: only "ccc" rows will be shown until last "ccc" line 153
- RC3: ccc filter works until line 51 (no "not - ccc - rows" will be shown
      starting with line 81 no rows will be suppressed by filter for "ccc".
      That's the same behavior I see with OOo 3.1.1


From OOo (until 3.1.1) I have been used to have to define a data range before I can use the filter. In "LibreOffice-filter.ods" in menu 'Data -> Define Range ... - Range' I see a data range 'A2:F82' (I believe that has been selected when reporter filtered the first time), and for that range filtering works fine.

When I define a new range for all data, filtering also works fine with "LibreOffice-filter.ods".

Also Everything works fine when I proceed 'Filter button -> Standard Filter ... - "CINSI = ccc". In this case LibO automatically creates a new filter range 'A2:F332'.

When I directly select "ccc", no new filter range will be created for all data, the "old" filter range 'A2:F82' will be used. That's the problem. That worked better in RC2.
Comment 2 Thomas Arnhold 2013-02-08 12:15:51 UTC
Works very well with libo 4.0.0.3.
Comment 3 Rainer Bielefeld Retired 2013-02-08 21:58:15 UTC
No Fix known, so WFM
I did not test where that really became working well.
Comment 4 Gökçen Eraslan 2013-02-08 22:02:32 UTC
(In reply to comment #3)
> No Fix known, so WFM
> I did not test where that really became working well.

You cannot both reproduce the bug and close it as WORKSFORME.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.