Bug 33190 - Auto Filter uses outdated data range
Summary: Auto Filter uses outdated data range
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.3.0 RC3
Hardware: All All
: medium normal
Assignee: Katarina Behrens
QA Contact:
URL:
Whiteboard: (target:4.0.0)
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-16 10:41 UTC by Gökçen Eraslan
Modified: 2013-02-08 22:02 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Document to reproduce the problem (16.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-16 10:41 UTC, Gökçen Eraslan
Details

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.