cannot sort 2 long columns [closed]

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

joeh6966
22 ●3 ●5 ●9

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

flag of United Kingdom of Great Britain and Northern Ireland

10494 ●14 ●40 ●42 http://etmg.altervista...

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 4.4.6.3 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

add a comment

1 Answer

Sort by » oldest newest most voted

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

joeh6966
22 ●3 ●5 ●9

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

add a comment

Question Tools

1 follower

Stats

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

Seen: 29 times

Last updated: Dec 27 '15

cannot sort 2 long columns [closed] edit

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

Question Tools

Stats

Related questions

cannot sort 2 long columns [closed]

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