https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #11 from Jonny Grant ---
Thank you for your message.
Yes, the solution is to imported (using "Detect special numbers" ON), it's
rather manual, not automatic as users would expect. That's fine, I'm a software
engineer, I am
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #10 from ady ---
(In reply to Jonny Grant from comment #9)
> sort by the nominal value. Is that another "enhancement" request?
Let's recap.
If we cannot replicate the problem, there is no way to improve the case.
You see
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #9 from Jonny Grant ---
(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,
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #8 from ady ---
(In reply to Jonny Grant from comment #7)
> Yes, indeed I can change to English(US) and it loads, although oddly it
> swaps the $ USD to be a £ GBP symbol! that's a bug -- but depends if anyone
> wants to fix
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #7 from Jonny Grant ---
Thank you for the replies.
Note, this works without any clicking or changes in Gnumeric
Note, it does not work in Google Sheets
Does anyone have a copy of Excel to try with?
When I consider as a
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #6 from ady ---
(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 want to be clear.
Following the steps that I described (i.e. using
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
m_a_riosv changed:
What|Removed |Added
Status|UNCONFIRMED |RESOLVED
Resolution|---
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #4 from Jonny Grant ---
(In reply to ady from comment #3)
> (In reply to Jonny Grant from comment #2)
>
> > ^ see the numbers are sorted by nominal value, the larger are at the top.
>
> That's exactly how I get it, sorted
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #3 from ady ---
(In reply to Jonny Grant from comment #2)
> ^ see the numbers are sorted by nominal value, the larger are at the top.
That's exactly how I get it, sorted by value, the larger at the top, using
either 7.6.3.2
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #2 from Jonny Grant ---
Perhaps this has been fixed recently? Could you share your full version
information.
Imported (using "Detect special numbers" ON) as:
Sort descending by column B:
test4 $9951.00
ts5t$995.00
https://bugs.documentfoundation.org/show_bug.cgi?id=159647
--- Comment #1 from ady ---
Imported (using "Detect special numbers" ON) as:
test1 $336.00
test2 $3.00
test3 $436.00
test3 $4,360.00
test3 $336.00
test3 $3,360.00
ts5t$995.00
test4 $9,951.00
afesf $995.00
Sort
11 matches
Mail list logo