Created attachment 96504 [details] junk.ods is the original file where the glitch appeared, but with personal data overwritten Problem description: Problem applying Autofilter sort function to a certain data sheet Refer to http://ask.libreoffice.org/en/question/31913/prevent-calc-from-sorting-column-labels-with-data-using-autofilter/ Steps to reproduce: 1. ....Only reproduced using the file in which the problem was found 2. ....Select any cell in the Expenses table 3. ....Select Sort Ascending for any Autofilter menu Current behavior: The column labels will sort into the data table and be replaced by a data record, regardless of sort option setting or database definition settings. Expected behavior: Column labels should remain in row 1 Operating System: Mac OS X Version: 4.2.0.4 release
Hi Scott, thanks for reporting. Reproducible for this file will all versions, and with Aoo 4.0 Change the platform, version and status.
The problem comes from the use of formula in column headers L1 and M1. The problem does not occur if I replacing these formula by fixed strings. Not sure if autofilter is intended to work with variable headers. Best regards. JBF
Problem already tracked in bug 58013. Best regards. JBF *** This bug has been marked as a duplicate of bug 58013 ***