Created attachment 110401 [details] PCI Attached Hardware List When sorted a Calc sheet via Data->Sort no problem at all. However when Data->Filter->AutoFilter is selected and sorted the datas by using dropdown menu in first filter row, the top (filter) row is also being sorted.
I can not confirm with Version: 4.3.6.0.0+ Build ID: 9e57326acebde972df22ea4368b5ce4822d51330 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-11-27_12:21:59
can reproduce it with the version mentioned below and capture a desktop video while doing this if needed. Version: 4.3.4.1 Build ID: bc356b2f991740509f321d70e4512a6a54c5f243 i've updated 4.3.4.1 from the older version (not remembering) according to LibreOffice's update request.
(In reply to ben sen from comment #2) > can reproduce it with the version mentioned below and capture a desktop > video while doing this if needed. Please, could attach your own test file ? Not reproducible for me too. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #3) > (In reply to ben sen from comment #2) > > can reproduce it with the version mentioned below and capture a desktop > > video while doing this if needed. > > Please, could attach your own test file ? > Not reproducible for me too. > > Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have > provided requested informations. Thank you for your understanding. > > Best regards. JBF Now i found real problem. If you follow below steps as written, you should be able to reproduce this problem. Since I do not have any Microsoft OS or office software on my Pc, can not reproduce it again. 1- Create an Excel sheet with Microsoft Office 2013 under Windows 8 64-bit operating system. 2- Create a table with random values and add filter row at top. 3- Save it as an *.xlsx document. 4- Open this document with LibreOffice Calc Version: 4.3.4.1 under one of 64-bit Ubuntu OS variants. 5- Try to filter or sort with the top row. When Auto-filtering is disabled and enabled again in LibreOffice Calc, the problem has disappeared. I've tried to reproduce the problem, however, it does not appear when the sheet has been created in LibreOffice. I would like to share video of my own xlsx sheet but it is kind of a classified document. If I can find regular document created by Excel, will add the video attachment that shows this problem.
Created attachment 110668 [details] test file
I can confirm with LO 4.3.4.1, win7
This is a duplicate of bug 63416. Header recognition is currently quite odd: a header row is recognized if all column headers are text, i.e. no empty cells and no numbers. Otherwise, the header row and autofilter buttons will move. Thus, this bug is duplicate. *** This bug has been marked as a duplicate of bug 63416 ***
*** Bug 90398 has been marked as a duplicate of this bug. ***