<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_REOPENED " title="REOPENED - Severe Bug: Libre Office Calc: csv Import --> correct preview, wrong numbers imported" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116258#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_REOPENED " title="REOPENED - Severe Bug: Libre Office Calc: csv Import --> correct preview, wrong numbers imported" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116258">bug 116258</a> from <a class="email" href="mailto:gerard.fargeot@orange.fr" title="GerardF <gerard.fargeot@orange.fr>"> GerardF</a> <pre>> Ok. the behaviour has something to do with the DE locale. > > But your answer did not explain > why 0.05 and 0.00001 gets imported correctly > (at least looking correctly, even if it is interpreted as text) > and 0.005 becomes read as a number, here as number "5" dots with group(s) of 3 digits are imported as numbers. Example 123.456 or .005 Without group of 3, example 0.1 or 0.05 it is text. > In addition to it your answer does not explain why the preview shows the > correct numbers. > > It still seems pretty buggy to me. > > The behaviour is not predictable for the user. I can agree with this part. Preview should shows text and numbers in the way they will be imported.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>