https://bugs.documentfoundation.org/show_bug.cgi?id=153206
--- Comment #10 from Hendrik Maryns <[email protected]> --- (In reply to Mike Kaganski from comment #9) > (In reply to Hendrik Maryns from comment #8) > > In my case, it is not a user error, they are all article numbers in > > a hardware store > > And this is *exactly* the user error. A *number* (in Calc sense) is anything > that you use to *perform calculations*. Identifiers of any kind (like > "article numbers") are *not* numbers, and should be stored as *text* (either > by prepending number-like entries with ', or by pre-formatting the column as > text *prior to entry*). > > Without that, one can realize at some point that "numbers" that they enter > would transform to somethin unexpected: e.g., one enters "000123", and gets > "123"; or one enters "123/4", and gets "30 3/4"... > > And the sort "misbehaving" is just another manifestation of *the* user error. OK, then might I suggest that the above information, which I suppose is documented somewhere, is linked to from the help article about sorting. -- You are receiving this mail because: You are the assignee for the bug.
