https://bugs.documentfoundation.org/show_bug.cgi?id=153206
--- Comment #9 from Mike Kaganski <[email protected]> --- (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. -- You are receiving this mail because: You are the assignee for the bug.
