<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Numeric format inconsistency: Macros vs Writer fields, formula calculation fails" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123878#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Numeric format inconsistency: Macros vs Writer fields, formula calculation fails" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123878">bug 123878</a> from <a class="email" href="mailto:jsd.libreoffice@bvac.co.za" title="jsd.libreoffice@bvac.co.za">jsd.libreoffice@bvac.co.za</a> <pre>(In reply to Buovjaga from <a href="show_bug.cgi?id=123878#c6">comment #6</a>) > > Could you test your macro using a daily build of LO? > > jsd: you will find daily builds here: > <a href="https://dev-builds.libreoffice.org/daily/master/current.html">https://dev-builds.libreoffice.org/daily/master/current.html</a> Sorry for delayed response. I'm afraid I see no change in behaviour, using this build <a href="https://git.libreoffice.org/core/+log/4118610df8a78b00e5369bad1d9ce21cf1fbafeb">https://git.libreoffice.org/core/+log/4118610df8a78b00e5369bad1d9ce21cf1fbafeb</a> (downloaded today, 12 May) I'll attach a screenshot of my regional settings, where you can see (if you look very closely :-) that the decimal separator is a period, not a comma. Using the demo file I attached here on 2019-12-02, I get the same result, which is that calculations fail for numbers with a period as the decimal separator. Something that just occurred to me is this: for my locale, ZA, the _default_ decimal separator is a comma. I changed that to a period (and changed the thousands grouping character from period to comma). If LO is using the default locale settings instead of the getting the actual ones from the OS, this would explain my results.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>