Why is Calc failing to sort a column of numbers?

asked 2017-01-28 01:14:49 +0200

tonyvella gravatar image

updated 2017-01-30 19:16:59 +0200

Evgeny gravatar image

I have a column of numbers that is 80 rows deep. When I sort them ascending, they sort fine with the exception of rows 70 to 75. The numbers in rows 70 to 75 go to the bottom of the sort and regardless how many times I sort they stay there (at the bottom). I have other columns with a heck of a lot more rows of numbers (one in particular has close to 700) and it sorts perfectly.

Why? What am I doing wrong?

Thanks in advance and regards from Ottawa, Canada.

edit retag flag offensive close merge delete



The numbetrs may be text looking like numbers. Did you try 'View' > 'Value Highlighting'? Yoi may also use the functions ISTEXT and ISNUMBER.

Lupp gravatar imageLupp ( 2017-01-28 01:28:58 +0200 )edit