<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Allow custom locale settings for decimal separator, group separator, default date and time formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=46448#c20">Comment # 20</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Allow custom locale settings for decimal separator, group separator, default date and time formats" href="https://bugs.documentfoundation.org/show_bug.cgi?id=46448">bug 46448</a> from <a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> Jean-Baptiste Faure</a> <pre>(In reply to Miguel from <a href="show_bug.cgi?id=46448#c19">comment #19</a>) > If, some day, you allow to change these separators and formats, please allow > to change the list separator. > > In French, the standard list separator is a semicolon (";"), since the comma > is already used for the decimal separator (which is very inconvenient when > opening a standard CSV file or any other file created by a C program or > similar). If one changes the decimal separator to a dot ("."), he will > possibly want to change the list separator to a comma (","), and write a sum > like SOMME(A1,A2) instead of SOMME(A1;A2), and a CSV file like > "pi,3.1416,e,2.71828" instead of "pi;3.1416;e;2.71828" or > "pi;3,1416;e;2,71828". All what you need is explained in the FAQ: <a href="https://wiki.documentfoundation.org/Faq/Calc/136/fr">https://wiki.documentfoundation.org/Faq/Calc/136/fr</a> Best regards. JBF</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>