Incorrect Sorting?

[NotLeftBehind]

I am trying to figure this one out. I got two issues with this example. I assume because of the dashes.

One, I will sort by SET1 then SET2 and the numbers are not in order. The numbers starting in 9 should be first in both columns. It should be that 969 be first in both sides.

Two, even sorting the columns both ascending, numbers come backwards. Look at the highlighted groups. Even removing the dashes, making the numbers now what they are, but in doing so the right column still sorts opposite.

Not the results I was expecting.

Might be Monday, but....

[RoryOF]

Mixed data types; /View /Value Highlighting to see.

[NotLeftBehind]

Nothing happens. On other sheets, that seems to turn DATE cells blue, but does nothing on this sheet.

[RoryOF]

It doesn't DO anything - it tells you about your data. Look up "highlighting" in the Help and then adjust your data.

[acknak]

The results of sorting depends on what data type Calc uses to store the values; numeric or text. For example, the sorting rules say that any number comes after any text, so the number zero will come AFTER the text 9999999. This looks completely wrong on the screen because you can't see that 9999999 is not a number at all.

You have the opposite situation. The items that look like numbers (no dash) Calc has converted to numbers, and the items like 1011-1014 are all text because they can't be converted to a number, and thus they always come before any of the numbers.

Here's your sample with all the items in set2 converted to text, then sorted. You can see that the sort interleaves all the items because now they are all the same data type.

[Alex1]

Select column B and click Data, Text to Columns, use the dash as the separator. Then do the same for column A after inserting an empty column between A and B. Then you can sort the data using their numerical value.

[DFW333]

I'm having a problem getting it to sort a list of prices properly. I have a column for business names, a column for addresses and a column for cost. I need to sort by cost, lowest price to highest price. The entire column has been formatted to be currency. And I have even retyped the numbers into the cells manually after changing the format. Yet it still shows the spreadsheet sorted in the column by this order:

$100
$100
$100
$100
$185
$39.95
$40
$40 and so on

Why is it putting $100 at the top of the range? Granted "1" is less than "3" but this program should be able to understand the concept of hundreds vs tens. All the other numbers are sorted correctly.

[Zizi64]

Your "numbers" are not numeric values, but they are strings.
Please upload your example .ods document here ( with a few formatted "currency values").