https://bugs.documentfoundation.org/show_bug.cgi?id=172448
--- Comment #4 from Anton <[email protected]> --- (In reply to ady from comment #2) > My guess is that the Autofiltered Sorted list is considering the list's > Headers as normal items of the list, not as Headers. > > With attachment 207441 [details]: > > 1. Clear the filter. > 2. Remove the Auto-Filter; under some circumstances, you might need to do > this twice in order to really get the Autofilter removed). > 3. Select the whole spreadsheet. > 4. Set (all) rows to Show (just in case some row is unintentionally set as > Hidden). > 5. Select the range B3:N500 - do not skip the selection of the adequate > range when you intend to apply an AutoFilter! > 6. Apply AutoFilter. > 7. Filter the "(empty)" rows on column E "Gruppe / Verein". > 8. Apply Sort. > > With those steps, the behavior should be correct. > > On the web page of the bug report tdf 172448, please post a comment about > whether those steps solved the issue for you. With those steps, it works fine, thank you. But I'm looking for a substitute for excel (special for my customers), so could this be placed as a bug? I don't want to teach all my customers (that are willing to change from MS to Libre) how they have to do it now as a workaround. For me now it worked, but i use actually excel and calc parallel, to gain the advantages to use calc instead of excel. (In reply to m_a_riosv from comment #3) > I think the issue is when generating the autofilter there are text on G2 and > H2, this is why Calc inform about 'range does not contain column headers', > and why following @ady instructions it works fine. This could be the problem, maybe we (you?) could adress it? Best regards, Anton -- You are receiving this mail because: You are the assignee for the bug.
