<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CSV "Text Import" dialog configuration issues with OS local and LibreOffice local" href="https://bugs.documentfoundation.org/show_bug.cgi?id=104970#c15">Comment # 15</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CSV "Text Import" dialog configuration issues with OS local and LibreOffice local" href="https://bugs.documentfoundation.org/show_bug.cgi?id=104970">bug 104970</a> from <a class="email" href="mailto:todventtu@suomi24.fi" title="Buovjaga <todventtu@suomi24.fi>"> Buovjaga</a> <pre>(In reply to Buovjaga from <a href="show_bug.cgi?id=104970#c14">comment #14</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135672" name="attach_135672" title="CSV with decimal separators corrected to commas">attachment 135672</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=135672&action=edit" title="CSV with decimal separators corrected to commas">[details]</a> > CSV with decimal separators corrected to commas > > In the F column the values are numbers, but with incorrect decimal separator > for German locale. They should be using commas. Now as they are detected to > be "Number" format, the import treats 2.544 as two thousand five hundred and > forty four due to German locale using period as the thousands separator. In another report, I bumped into a more elegant way that does not require changing the .csv: <a href="https://wiki.documentfoundation.org/Faq/Calc/136/fr">https://wiki.documentfoundation.org/Faq/Calc/136/fr</a> So in the import dialog, change the columns with the period decimal to type "English (US)". Note that Shift and Ctrl keys work when selecting the columns in the dialog.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>