I cannot get Libre calc to sort

O

ohdearme

Member
Hello All
Even the most simple of spreadsheets will not sort. Some columns will, but never all of them. (Libre calc). I used Excel for years so know what I'm doing (I hope)

Please help
Alan
 
Actually Couriant, it was not what I wanted, ie get my ascend/descending part working. I won't work, but you sent me this video that taught me something else I wanted, so many thanks to you.

Any other help to sort out my sorting?
Greetings
 
You'll probably have to describe the behavior more, because to most people the immediate response would be like:

1771635538609.png
 
Hello I am going to have to work out what is exactly wrong, so I'll come back to you with exact symptoms (If I can!)

Many thanks so far

Very best
Alan
 
The easiest option will to reload Libre office to the latest version, this will not affect any data files you have created.
text below may help.

After this you can reset the sort options to automatic.



Calc sometimes re‑sorts because a Sort Range was previously applied and Calc tries to “maintain” it.


Turn that off:

----------------------------------------------------------------------
  1. Select the whole sheet (Ctrl + A).
  2. Go to Data → Sort…
  3. In the Sort window:
    • Make sure “Range contains column labels” is correct.
    • Remove all sort criteria (set them to “None”).
  4. Press OK.

This clears any “persistent” sort rules.
---------------------------------------------------------------------
 
Hello Terry, There is no "none choice" in "Sort". What to do please? If I can't find that, I will try a reload.

Thanks everyone

Alan
 
Alan, the "some columns sort, others don't" symptom is almost always mixed data types - specifically numbers stored as text sitting alongside real numbers in the same column. LibreOffice Calc won't sort those together correctly. Quick way to check: click a cell in the problem column that should be a number. Look at the bottom status bar. If it shows Sum: 0 or Count: 1 instead of the actual value, that cell contains a text-number. To fix it, select the affected column, go to Data > Text to Columns, then just click OK/Finish without changing anything. That forces Calc to re-evaluate all cells in the column as proper numbers. After that the sort should work fine. Also worth checking for merged cells anywhere in your data range. Even one merged cell will silently block sorting for that whole area. Go to Format > Merge Cells > Unmerge Cells on the selection to rule that out.
 
You must log in or register to reply here.
Back
Top