Bug 89277 - Autofilter header, containing number is mixed with other rows
Summary: Autofilter header, containing number is mixed with other rows
Status: RESOLVED DUPLICATE of bug 63416
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-10 07:06 UTC by Yan Pas
Modified: 2015-04-11 19:29 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
buggy file (8.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-10 07:06 UTC, Yan Pas 		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 Yan Pas 2015-02-10 07:06:28 UTC 
Created attachment 113278 [details]
buggy file

1) Create table with two columns (one containing only numbers)
2) Select two top cells of each row and click autofiltericon
3) Click sort button from drop-down menu
And we see the bug: The header cell is mixed with other cells, even if we sorted column, containing only words.

BTW changing header of number column to text format doesn't help. In excel everything works good, so it's not a feature, it's a bug.
Comment 1 raal 2015-02-10 07:37:04 UTC 
I can confirm with LO 4.4, win7


When sorted a Calc sheet via Data->Sort no problem at all. When changing name of header to non numeric, then sorting works.
Comment 2 Yan Pas 2015-04-01 13:13:51 UTC 
Guess it is related with https://bugs.documentfoundation.org/show_bug.cgi?id=90394
Comment 3 Roland Kurmann 2015-04-10 19:50:48 UTC 
This issue seems to be a duplicate of #63416.
Comment 4 Yan Pas 2015-04-10 22:03:52 UTC 
Yes, seems to me too. In addition not only empty fields, but numbers are sorted too
Comment 5 Roland Kurmann 2015-04-11 09:30:54 UTC 
Marked as duplicate of bug 63416.

It is the same source of problem: Everything that is no text will not be recognized as header and thus sorted.

I hope it is OK if I am closing this issue.

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