Ask Your Question

cannot sort 2 long columns [closed]

asked 2015-12-27 21:19:18 +0200

joeh6966 gravatar image

updated 2016-03-11 22:28:46 +0200

Alex Kemp gravatar image

I can sort 2 columns that are short. One column is the date, and second column is my weight. I am sorting from high to low. The enclosed attachment is a Steps Recorder file showing the errors that happen when I sort a whole long spreadsheet. Calc v Windows 8.1 English

Forget the attachment; it will not upload. link text

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-11 22:29:03.567791

1 Answer

Sort by » oldest newest most voted

answered 2016-01-15 19:16:57 +0200

joeh6966 gravatar image

I figured it out finally, after many tries. I need to copy the columns I want to sort and paste them in a new spreadsheet with Paste Special. I deselected formula, and got just numbers. After the sort, both columns sorted. Then, I formatted the date column to be Date rather than number. Solved

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-12-27 20:51:28 +0200

Seen: 29 times

Last updated: Dec 27 '15