Description: I select rows 2 through 19 and try to sort on column E and nothing happens. Steps to Reproduce: 1. select rows 2 thru 19 of my .xls file 2. select column E of sort menu 3. click OK Actual Results: no change to the sheet, rows still out of order Expected Results: rows sorted based on values in column E Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.1.8.1 (x64) / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
Created attachment 178269 [details] Pretty basic spreadsheet
Not reproducible for me. Please explain in more detail how you do it. For example, which rows do you select, which sort options you are using, ascending or descending order, etc. Status has been set to NEEDINFO, please set it back to UNCONFIRMED once requested information has been provided. Best regards. JBF
Hi JBF, I was using ascending order. I just tried it again using descending order and it reversed them, but the numbers still weren't in order. So I looked at the actual cells that were out of order and lo and behold, there were hidden "`" in front of the numbers! Sorry about that. It was "bad" data, not the software. Sorry to take your time. It really had me baffled. I'll remember to check for that in the future. Thanks for your patience. Ken
E17:E19 are text numbers. And text are below numbers in ascending sort. Select those and Menu/Data/Text to column to convert into numbers. Then sort and it works fine.