[Libreoffice-bugs] [Bug 138993] Remove commas in numbers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138993

--- Comment #16 from Jonny Grant <jg at jguk.org> ---
Good evening, It is a real shame this bug was closed. It does feel like a
confirmed issue as it works as normal in Google Sheets, and is easy to
reproduce.

Google Sheets doesn't suffer this issue. Sheets also retains the formatting
entered correctly. Can you confirm if you can reproduce the same?

Jul-19-2019     
10 Aug 2019

=A1-A2
-22     Days different


We get CSV files from all over the world, USA, Japan, UK, France

In the case of the USA, they often (but not always) put the month before the
day, and then end as /19 or /2019 or with hyphen.

There's no reason for us to need to force anything if it can be auto detected

It's a bit strange for us to need to import into Google Sheets, and then export
before loading into Calc.

Probably this column forcing on CSV load was only introduced in 7.x which
hasn't made it into Ubuntu stable LTS yet. Sorry I am not that up to date.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210120/671f86d7/attachment-0001.htm>