Using Open Office 3.3.0
Calc will sort a list of numbers not in numerical fashion, as would seem reasonable, logical, and rational, but in alphabetical order.
Eg: Calc thinks that 103,1000,etc come between 1 and 2.
If I change the format to of the cells to Number, it makes no difference; they remain in the order of 1, 100, 1000, 2, 250, 3.
A work around has been posted on OO forums to create a 2nd column, and use
=value(A1), which calculates the numerical value of the original column, but I found if I sorted data using this 2nd column as the sort order it still sorted alphabetically.
I'm not sure how this fell through the cracks. I would assume numbers and sorting numerically would be important for a program called Calc, instead of treating numbers like letters.
Update: as much as I admire OO for creating a pretty decent application suite, their support pretty much sucks. Every time I've attempted to login to submit a bug, I get a 404 error. If I forget my password to their support forums, I can only retrieve it if I remember both my username and email. If I forget my username, then game over, because I cannot register again with the same email. /end sooky rant.