Bug 76715

Summary: Other: AUTOFILTER sorts column label row into data table sometimes
Product: LibreOffice Reporter: Scott <dzturbd>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: jbfaure, miguelangelrv, suokunlong
Priority: medium    
Version: Inherited From OOo   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=81010
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: junk.ods is the original file where the glitch appeared, but with personal data overwritten

Description Scott 2014-03-28 01:32:13 UTC 
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
Comment 1 m_a_riosv 2014-03-30 23:40:43 UTC 
Hi Scott, thanks for reporting.

Reproducible for this file will all versions, and with Aoo 4.0

Change the platform, version and status.
Comment 2 Jean-Baptiste Faure 2014-10-12 08:06:14 UTC 
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
Comment 3 Jean-Baptiste Faure 2014-10-12 20:04:22 UTC 
Problem already tracked in bug 58013.

Best regards. JBF

*** This bug has been marked as a duplicate of bug 58013 ***