https://bugs.freedesktop.org/show_bug.cgi?id=77681
Priority: medium
Bug ID: 77681
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: Sorting: header-identifiying heuristic
misbehaves if not all header cells are filled out
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: na+lo...@nicapicella.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.5.3 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
In certain cases, the "header-identifying heuristic" misbehaves, thus glitching
the sort. This happens under the following conditions:
* not all header cells are filled out
* the data is text (it worked for some combination of text and numbers, thus
this constraint)
Steps to reproduce:
1. Create a table, containing the following data (CSV syntax):
TITLE, (empty cell)
Beta1, Beta2
Zeta1, Zeta2
Alfa1, Alfa2
Delta1, Delta2
2. a) Select cells "Beta1" to "Delta2", or
2. b) select cells "TITLE" to "Delta2".
3. Sort ascending.
Current behavior:
In case of 2. a), the "sorted" table looks like:
TITLE, (empty cell)
Beta1, Beta2
Alfa1, Alfa2
Delta1, Delta2
Zeta1, Zeta2
Which is obviously wrong—the row "Alfa" should come _before_ "Beta".
Apparently, Calc tried to be smart and identified the "Beta"-row to be a
header; which it is not. Well, that's actually kind of cool—unfortunately,
that's not what I wanted. So I figure I just have to select the header-row,
too… So now to 2. b).
In case of 2. b), the "sorted" table ends up looking like:
Alfa1, Alfa2
Beta1, Beta2
Delta1, Delta2
TITLE, (empty cell)
Zeta1, Zeta2
Which—again—is not what I wanted: Judging by the result of 2. a), it is not
even what I expected.
Expected behavior:
The sorted table should look like:
TITLE, (empty cell)
Alfa1, Alfa2
Beta1, Beta2
Delta1, Delta2
Zeta1, Zeta2
Ideally, it should look like this *both times* (though I understand that the
heuristic would be basically impossible to define). More realistically, the
sorting should be possible to do at all.
Current workaround: Fill the empty cell in the header row with dummy data and
then sort—sorting works as expected. (Optionally, subsequently remove the dummy
data.)
Operating System: Mac OS X
Version: 4.1.5.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
