Bug 76010 - Sorting within autofilter makes column header also sorted together with data, when one of the column header is blank
Summary: Sorting within autofilter makes column header also sorted together with data,...
Status: RESOLVED DUPLICATE of bug 63416
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.2 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-11 05:23 UTC by philomoral
Modified: 2015-04-11 19:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
sample bug file (9.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-11 05:23 UTC, philomoral 		Details
another simple test file (12.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-07-07 16:30 UTC, Kevin Suo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description philomoral 2014-03-11 05:23:32 UTC 
Created attachment 95569 [details]
sample bug file

Problem description: Align in autofilter has a bug. 

Steps to reproduce:

My data has some blank label on the top of the sheet. (please see my attached file.) I have data with three columns, one of them have blank on top of the column. when I align the total data, it aligned wrongly.


1. Do Autofilter with blank label.
2. Then, align it.

Current behavior: 

When I align it, the label will not situate at top of the sheet, but it align with other data.

Expected behavior:

              
Operating System: Ubuntu
Version: 4.1.3.2 release
Comment 1 Joel Madero 2014-05-01 03:36:17 UTC 
Please clarify the instructions: 

what does "then align it" mean? Please be explicit when providing steps as we have no clue how to interpret that. Do you mean align left? And by "it" do you mean select the entire sheet and align left/right/center? Select an individual cell? 

Marking as NEEDINFO - once you provide clearer steps please mark as UNCONFIRMED. Thanks
Comment 2 Kevin Suo 2014-07-07 16:30:25 UTC 
Created attachment 102381 [details]
another simple test file

Confirmed on Fedora 20 X86, libreoffice 4.3.0.2.

By saying "align", philomoral must be meaning "sort".
I have created a more simple test file to reproduce this problem.

Steps to reproduce:
1. Open my attached in this comment
> observe that autofilter is applied, while column C has a blank header.
2. Sort any column by clicking the "Sort Asending" or "Sort Desending" in the autofilter.
> Data are sorted, but column headers are sorted together with data. (bug)
3. Sort by use the normal way (menu "Data -  Sort...")
> Data are sorted, column headers are remaining at the top after sorting. (expected)
Comment 3 Kevin Suo 2014-07-07 16:37:56 UTC 
This is a duplicate of bug Bug 63416.

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