| Summary: | EDITING: Sort a column doesn't sort first row | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Matt Reine <mattreine> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | jbfaure, Michael.Tiernan |
| Priority: | medium | ||
| Version: | 4.0.4.2 release | ||
| Hardware: | Other | ||
| OS: | Windows (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | 4 screenshots how to reproce the issue | ||
*** Bug 66960 has been marked as a duplicate of this bug. *** Reproducible on LO 4.0.4.2 (Win7 32bit) -> same behavior persists if we only select cells A1:A16 (not entire column A) Finding after highlight column A: Check Menu: Data > Sort... > Sort key 1 (in the dropdown list only shown entry from row 1) As the first row contains text, it was considered a row label. Use sort via dialog to change that. Sorry, this is not a resolved issue. I have run into this issue when attempting to sort a short list of values and there is no dialog box to change the behavior. Additionally, the sorting option presented specifically says "or sort the currently selected range" which shows no indication of a heading or otherwise. Example is available at: https://www.dropbox.com/sh/es308xl689a9cq5/ADoTJ-SpXA/LO_Bug_report The files there will illustrate the problem. If the selected range for sort is C4:C23 and you're only going to sort C5:C23 with C4 as a heading, then it should be shown in that dialog box otherwise expectations are as stated, that the entire range will be operated on and affected. As an aside, since we're discussing it, the selection of the label field in the sort tool seems to use rules of operations that are not obvious to the user. I have a spreadsheet of some 400+ system entries and when I try to sort it, I *constantly* have to tell it that the first row is column labels but when I *don't* expect the column label checkbox to be active, it is! I have an additional data point to provide. I *ass*u*me*d that if the first row was a header then if I select, in my case, C3:C23 and perform the sort then the blank space in C3 will be the header and the rest of the list is sorted properly. *****BBBBZZZZZZTTTTTT****** WRONG. So, I have data in C4:C23, Select C3:C23 and sort asending. It moves the blank space in C3 to the BOTTOM of the sorted data implying that the cell with data is less than the blank cell! WTF? I am going to assume that there's more to this than meets the eye so I'm going to go under the assumption that something else might be happening in addition to the (seemingly) random choice for header row. Now, in a twist that surprises me, *this* time when I tried to sort, choosing "Sort" from the menu (instead of the menubar button) I *am* given the choice to turn off the header row and it does sort correctly. Comment #3 is the correct answer. The dialog is there: menu Data > Sort. Uncheck "Range contains column label" in the Options tab. Closing again. Best regards. JBF |
Created attachment 82497 [details] 4 screenshots how to reproce the issue when you want to sort data it sorts everything but the first row which is wierd. Here are screenshots how to reproduce. Operating System: Windows 7 Version: 4.0.4.2 release