| Summary: | VIEWING: Sorting does not sort the first line in matrix with the selection contains non-numeric cells. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Welton Rodrigo <rodrigo> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | jbfaure |
| Priority: | medium | ||
| Version: | 4.1.1.2 release | ||
| Hardware: | Other | ||
| OS: | macOS (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Screen capture exemplifying the input used. | ||
You wrote : "I think this is related to sorting trying to detect column headers or labels." You gave the right explanation. In the "Sort" dialog box, switch to tab "Options" and uncheck the "the range contains column labels" box, I guess it will be OK For this kind of difficulty you need to ask first for help on users mailing-list (users@global.libreoffice.org) or on http://ask.libreoffice.org The explanation you found yourself is surely the right one. So closing as NotABug. Feel free to reopen if you can show that something does not work as it should in this area. Best regards. JBF |
Created attachment 85738 [details] Screen capture exemplifying the input used. Problem description: Steps to reproduce: 1. Create a new spreadsheet and enter the sequence a-g, with each letter in a cell from A1 to A7. 2. Select cells A1:A7 3. Click on the Sort Descending button Current behavior: The first Cell does not get sorted with the others as a result, after Sort Descending, the cells will contain: a g f e d c b Expected behavior: Cells sorted in descending order: g f e d c b a ASIDE: If you click Sort Ascending or Sort Descending, the behaviour is the same: the first cell does not get sorted. This won't happen if the cells are numeric. I think this is related to sorting trying to detect column headers or labels. Operating System: Mac OS X Version: 4.1.1.2 release