<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#c43">Comment # 43</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:markysparky77@gmail.com" title="Mark <markysparky77@gmail.com>"> Mark</a> <pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=46448#c42">comment #42</a>) > (In reply to Mark from <a href="show_bug.cgi?id=46448#c41">comment #41</a>) > > (In reply to Eike Rathke from <a href="show_bug.cgi?id=46448#c40">comment #40</a>) > > > (In reply to Mark from <a href="show_bug.cgi?id=46448#c38">comment #38</a>) > > > > Open Office does not have this bug. I just installed it and all the > > > > formatting works correctly since it takes it from my Windows settings. > > > It does not. > > It does not what? > It does not take formatting from the Windows settings. > It uses an older set of builtin locale data that *you* consider to be > correct but others and specifically the ZA government don't, see <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED FIXED - FORMATTING Incorrect number and date format for South Africa (en_ZA)" href="show_bug.cgi?id=119613">bug 119613</a>. I do consider it to be correct. A quick glance at Wikipedia says that both commas and points are used. I recall when I was in school over 25 years ago that the teachers specifically told us that we were to change from comma to point notation since that is more aligned with international standards and the electronic equipment that we were using. Since then and in the 20 years that I have been working in finance, I have never seen a comma used as a decimal separator. Perhaps as a reference you could look at some of the main South African finance websites such as www.moneyweb.co.za or fin24.co.za and see if you can find a comma separator used anywhere there. Or perhaps a step further and look at the South African government's own websites such as South African Revenue Services <a href="https://www.sars.gov.za/Tax-Rates/Income-Tax/Pages/Capital-Gains-Tax-(CGT).aspx">https://www.sars.gov.za/Tax-Rates/Income-Tax/Pages/Capital-Gains-Tax-(CGT).aspx</a> or the South African Reserve Bank at <a href="https://www.resbank.co.za/Pages/default.aspx">https://www.resbank.co.za/Pages/default.aspx</a> Let me know what you see. Bear in mind that unlike in Germany, the South African government is no longer good at maintaining and enforcing standards, or even adapting to international standards. The government document may say one thing, but nobody that I know follows that any more. Either way, the format in both Open Office and Excel are aligned to what is in Windows whereas Libre Office is not and there is not an easy way to change it.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>