Ask Your Question

Calc isn't sorting correctly [closed]

asked 2018-08-31 17:39:00 +0200

KingZorc gravatar image

updated 2018-09-02 18:57:05 +0200

I have an 18 column by 55 row sheet and I'm trying to sort by one of my headings. When I do so it doesn't sort all of them. It brings to the top the ones that aren't sorted.

Attached a portion so it's easier to understand.image descriptionC:\fakepath\Test.ods

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-09-03 15:56:24.013689

2 Answers

Sort by » oldest newest most voted

answered 2018-09-02 19:30:29 +0200

updated 2018-09-02 19:30:41 +0200

ViewValue Highlighting (Ctrl+F8) toggles a view mode that allows you to tell which cell has which kind of data (text/numeric/etc). Changing cell format does not convert test to number (even if you set the format to number); so unless you re-enter data having wrong type (this can be done automatically, using Find & Replace, or DataText to Columns), the cells will stay textual. See this FAQ by @erAck.

edit flag offensive delete link more


Finally, that worked. Thanks

KingZorc gravatar imageKingZorc ( 2018-09-02 20:34:04 +0200 )edit

answered 2018-08-31 18:26:30 +0200

erAck gravatar image

To me it looks like you are sorting descending and the values 6,31,...,1 are text cells and 140,111,...,40 are numbers, or some similar mix. Text sorts before numbers when sorting descending.

edit flag offensive delete link more


Doesn't matter if they're all set to text or numbers, it still sorts like that. I already tried changing them from one to the another as well as everything from one to the others, same result regardless.

KingZorc gravatar imageKingZorc ( 2018-08-31 21:12:08 +0200 )edit

Please attach a test file.

JBF gravatar imageJBF ( 2018-09-01 14:12:41 +0200 )edit

Attached a sample test file taken from the spreadsheet.

KingZorc gravatar imageKingZorc ( 2018-09-02 18:57:02 +0200 )edit

Question Tools

1 follower


Asked: 2018-08-31 17:39:00 +0200

Seen: 1,011 times

Last updated: Sep 02 '18