https://bugs.documentfoundation.org/show_bug.cgi?id=153206
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #7 from Mike Kaganski <[email protected]> --- I couldn't find in Excel 2016 a feature like our "Enable natural sort"; and this is a feature that *likely* doesn't save to files (so just a UI function). It *could* be possible to change it to consider numbers and texts similarly ... However: 1. It still could be used in macros, and they could break then => we could use a separate "[x] treat numbers as text" checkbox to keep the old behavior unchanged, and only have new behavior when explicitly configured 2. The numbers may be formatted in different ways; in which position should a *number* 0.1 be placed in the sorted list, when it is formatted as: "0.0"; "#.0"; ";;"; "[NatNum12]0.0"? => we could only use the display format then, solving the problem of dates at the same time... 3. Anyway, having a mix of numbers and number-like things in cells is a sign of user error. Is it really needed? IMO, we better have some notification in sort function that it sorted a mix, so possibly user needs to check their data (e.g., using a balloon tip or an infobar)? -- You are receiving this mail because: You are the assignee for the bug.
