Calc sorting incorrectly

I have two columns of numbers that I want to sort. Pre sort looks like:

2	0
0	1
0	0
0	1
3	8
467 3
1	2
1	1
1	2

And after sort (Data> sort> columnA > Ascending), it looks like

0	1
0	0
0	1
467	3
1	2
1	1
1	2
2	0
3	8

I mentioned it in my comment. But it’s true. If 467 is actually .467 but formatted so the decimal doesn’t show, the sort would be correct. Perhaps pepsimax has presented us a puzzle posing as a problem. But I hesitate to call a user’s seriousness into question. Instead I’ll suggest pepsimax call up Format > Cells > Numbers > Number for that particular cell, and check the Format Code field to make sure the format hasn’t been corrupted and there has been no “User-defined” tampering.

I know why I always want to have the zero displayed!!!..

I can not see this issue, neither 3.5.7.2 or 3.6.4.rc3.

Sometimes reset the user profile solve strange issues.
http://wiki.documentfoundation.org/UserProfile

Sorted absolutely normal with 3.6.3 Final.

I tested in LibO 3.5.7.2 on XP and had with your figures no problem

However, I observed that the cell content must be a number. The result of =value(text) could not be sorted. Only after copy & paste special numbers, I was able to sort.

The result of =value(text) is a number in the sense that I e.g. could add 1 and got the correct result.

Please check if you really only have numbers.

The easiest way to press F8 to make sure that all value have blue color (numbers). If they are black, so it’s text.

This is a good way. I just hope I don’t forget the F8.

Oh, sorry! NOT F8, but Ctrl+F8!!! F8 is “status extended selection”

Just a tiny little difference. Thanks for correction.

Ctrl-F8 is a neat feature. Color my spreadsheets blue black and green. Thanks JS. I tried to replicate pepsimax’s sorting problem in Libre 3.5.6.2 using text as well as numeric. The text sorted as expected (leftmost character). Could 467 be .467 with an invisible decimal? Yes, absurd, but…

Try set format Number-Standard to this cells. Then Find .+ (dot-plus) and Replace with & (ampersand) with option Regular expression = On. This should make all the values ​​apostrophe+number (that Сalс read as string) into real numbers