Ask Your Question

calc is sorting incorrectly [closed]

asked 2018-09-16 00:06:53 +0100

cachirro gravatar image

sorting works on pure number cells (ctrl+f8 in blue) however in cells formated as number but the value is coming from a formula they show as green in ctrl+f8 and are sorted in some weird way.

i have no idea why this happens and how to fix it, they are just numbers.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by m.a.riosv
close date 2018-09-16 12:18:53.214819

1 Answer

Sort by » oldest newest most voted

answered 2018-09-16 00:59:51 +0100

cachirro gravatar image

some cells had an invalid number coming out of the formula, and once i fixed that the sorting is working.

the cell had a X+Y+Z+A+B type of formula, that doesnt work properly when some of those cells have text and not a number, and once i changed to a SUM type of formula, that ignores the text and returns a proper value, even if 0, and then sorting works

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-09-16 00:06:53 +0100

Seen: 35 times

Last updated: Sep 16 '18