[Libreoffice-bugs] [Bug 41781] AUTO FILTER disappears unexpectedly

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=41781

--- Comment #5 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2011-10-14 08:11:21 PDT ---
Created an attachment (id=52340)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=52340)
New simple test document

GerardF's gave me some new ideas for additional tests. The reason for the
problem seems to be the filter data range with empty column label cell for the
last column. At least typing a single letter into that cell solves the problem
for me in several affected spreadsheets I tested.

Steps to reproduce:
1. open attached simple spreadsheet "new_sample1.ods"
2. Select / mark A1:M40
3. Menu 'Data -> Define Dange - Name = "filterarea"
    -> More -> check "Contains Cloumn Labels" if necessary'  <OK>
   DB range name has been created
4. Save as "new_sample2.ods"
5. Menu 'Data -> Filter -> Autofilter'
   Filter buttons appear
6. For column D click filter button
7. Select 'Standard filter'
   Unexpecedly Autofilter buttons disappear
   Clicking <More> in dialog shows new range 'A1:I38' with name "_Anonymous..."
8. Quit without saving

10. Open "new_sample2.ods"
11. Menu 'Data -> Filter -> Autofilter'
    Filter buttons appear
12. type an "x" into 'M1' and <Enter>
13. For column D click filter button
14. Select 'Standard filter'
    Now the Autofilter buttons remain, everything will work as expected.

With th "x" in 'L1' instead of 'M1' the problem remains


@GerardF:
Very very good catch!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.