Re: [more absurd] (was: org-table-sort-lines (numerically) leaves 0 separated)

[Bruno Barbier]

Uwe Brauer <oub@mat.ucm.es> writes:

> Consider 
>
> | 2 |
> | 1 |
> | 1 |
> | 0 |
> |   |
> |   |
>
> (org-table-sort-lines nil nil nil nil t) (numerically 'n' gives)
...
>
> So no empty lines, what the hell is going on here?


The reason is probably that the function 'string-to-number' return 0 for
anything that cannot be converted to a number.

Thus, as far as sorting is concerned, "not a number cells" and "cells
containing zeros" are the same and can be put in any arbitrary order.

Maybe org should handle NaN cells in a better way.

Bruno