https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #9 from Jonny Grant <[email protected]> --- (In reply to m_a_riosv from comment #5) > They are not importer as numbers, but text. Doesn't matter that the cell > format is standard. > > I think the situation is solved with one of the next steps, to get column > values as numbers: > > 1. Select as locale 'English US' in the Text import window. > or > 2. Click on the header of column with values and select US English for the > column type, in the Text import window. > > Without the above steps, just with 'Enable natural sorting', the sorting is > done correctly. It is there precisely for this kind of cases. Maybe Gnumeric > has this option enable as default. Perhaps it's an "enhancement"? to do what users expect, (match as Gnumeric already does), it's logical that strings containing numbers, would be sorted by their nominal value. I saw in "Format Cells" that those fields were detected as "Currency". So it is surprising again, that given a currency amount is a number.. it wouldn't sort by the nominal value. Is that another "enhancement" request? > > There is not a bug. Reminds me of people characterising an issue as "a feature, not a bug". -- You are receiving this mail because: You are the assignee for the bug.
