<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED WONTFIX - Remove commas in numbers" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138993#c16">Comment # 16</a> on <a class="bz_bug_link bz_status_CLOSED bz_closed" title="CLOSED WONTFIX - Remove commas in numbers" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138993">bug 138993</a> from <a class="email" href="mailto:jg@jguk.org" title="Jonny Grant <jg@jguk.org>"> Jonny Grant</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>