Ask Your Question

cannot sort 2 long columns [closed]

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

joeh6966 gravatar image

updated 2020-08-28 06:49:03 +0100

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 +0100

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 +0100

Seen: 67 times

Last updated: Dec 27 '15