https://bugs.freedesktop.org/show_bug.cgi?id=41781
--- Comment #5 from Rainer Bielefeld <[email protected]> 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. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
