Ask Your Question
0

calc sorting incorrectly [closed]

asked 2012-12-03 23:55:42 +0200

pepsimax gravatar image

I have two columns of numbers that I want to sort. Pre sort looks like:

2   0
0   1
0   0
0   1
3   8
467 3
1   2
1   1
1   2

And after sort (Data> sort> columnA > Ascending), it looks like

0   1
0   0
0   1
467 3
1   2
1   1
1   2
2   0
3   8
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 2015-10-19 02:57:12.565773

3 Answers

Sort by » oldest newest most voted
1

answered 2012-12-05 02:15:19 +0200

vbas96 gravatar image

I mentioned it in my comment. But it's true. If 467 is actually .467 but formatted so the decimal doesn't show, the sort would be correct. Perhaps pepsimax has presented us a puzzle posing as a problem. But I hesitate to call a user's seriousness into question. Instead I'll suggest pepsimax call up Format > Cells > Numbers > Number for that particular cell, and check the Format Code field to make sure the format hasn't been corrupted and there has been no "User-defined" tampering.

edit flag offensive delete link more

Comments

I know why I always want to have the zero displayed!!!..............

ROSt52 gravatar imageROSt52 ( 2012-12-05 08:12:36 +0200 )edit
0

answered 2012-12-04 00:46:53 +0200

m.a.riosv gravatar image

I can not see this issue, neither 3.5.7.2 or 3.6.4.rc3.

Sometimes reset the user profile solve strange issues. http://wiki.documentfoundation.org/UserProfile

edit flag offensive delete link more

Comments

Sorted absolutely normal with 3.6.3 Final.

Timon gravatar imageTimon ( 2012-12-04 06:39:36 +0200 )edit
0

answered 2012-12-04 07:25:09 +0200

ROSt52 gravatar image

I tested in LibO 3.5.7.2 on XP and had with your figures no problem

However, I observed that the cell content must be a number. The result of =value(text) could not be sorted. Only after copy & paste special numbers, I was able to sort.

The result of =value(text) is a number in the sense that I e.g. could add 1 and got the correct result.

Please check if you really only have numbers.

edit flag offensive delete link more

Comments

The easiest way to press F8 to make sure that all value have blue color (numbers). If they are black, so it's text.

JohnSUN gravatar imageJohnSUN ( 2012-12-04 09:22:46 +0200 )edit

This is a good way. I just hope I don't forget the F8.

ROSt52 gravatar imageROSt52 ( 2012-12-04 10:27:28 +0200 )edit
1

Oh, sorry! NOT F8, but Ctrl+F8!!! F8 is "status extended selection"

JohnSUN gravatar imageJohnSUN ( 2012-12-04 12:42:10 +0200 )edit

Just a tiny little difference. Thanks for correction.

ROSt52 gravatar imageROSt52 ( 2012-12-04 15:12:31 +0200 )edit

Ctrl-F8 is a neat feature. Color my spreadsheets blue black and green. Thanks JS. I tried to replicate pepsimax's sorting problem in Libre 3.5.6.2 using text as well as numeric. The text sorted as expected (leftmost character). Could 467 be .467 with an invisible decimal? Yes, absurd, but....

vbas96 gravatar imagevbas96 ( 2012-12-05 00:13:02 +0200 )edit

Try set format Number-Standard to this cells. Then Find .+ (dot-plus) and Replace with & (ampersand) with option Regular expression = On. This should make all the values ​​apostrophe+number (that Сalс read as string) into real numbers

JohnSUN gravatar imageJohnSUN ( 2012-12-05 08:41:10 +0200 )edit

Question Tools

Stats

Asked: 2012-12-03 23:55:42 +0200

Seen: 2,689 times

Last updated: Dec 05 '12