Ask Your Question

Numerical Sorting

asked 2016-11-11 05:22:11 +0200

Cork gravatar image

Hi Everyone,

I do a lot of sports standings sheets. When using LibreOffice Calc, if I have ten rows to indicate position or place 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. and sort them, tenth always comes between first and second. I have to change tenth to 99., then sort, then change it back to 10. Is there a fix for this that someone could point me towards? I like using Calc over similar programs, but this is one fault I have with it.

Thank you in advance!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-11 06:29:59 +0200

mark_t gravatar image

Suspect the numbers are being considered by Calc as text and therefore sorted by alphabetic order instead of numeric.

If you have locale where "," is the decimal separator, then when you enter "1." this will be treated as text and not a number. Solution would be to enter "1", "2" etc instead of "1.", "2." etc.

Other possible cause is if data is imported from csv files with incorrect choice of format for the column of data.

Use "View", "Value Highlighting" to show numeric data in blue and text in black to confirm your data is entered correctly.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-11 05:22:11 +0200

Seen: 1,300 times

Last updated: Nov 11 '16