For some reason, when I try to sort in a file I downloaded, the sorting fails, even if there are just simple numbers in the cells. Editing is enabled.
What is going on?
Edit: When I say sort, I mean the following:
- Select the range I want sorted
- Hit the sort button
- Select the column that I want it sorted by
- Watch as the range remains unchanged.
Edit 2: The range is not quite unchanged. 5,1,2,3,4 is the least to greatest, and 3,4,5,1,2 is greatest to least. The latter order was the one that the data was entered in.