[Libreoffice-bugs] [Bug 123878] Numeric format inconsistency: Macros vs Writer fields, formula calculation fails

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123878

--- Comment #10 from jsd.libreoffice at bvac.co.za ---
(In reply to Buovjaga from comment #9)
> > If LO is using the default locale settings instead of the getting the actual
> > ones from the OS, this would explain my results.
> 
> So bug 73242 ?

Quite possibly, yes.  If I understand that discussion correctly, the gist is
that LO isn't picking up the OS locale settings.  If it were to do so, I agree
that would probably resolve this issue.

But here's an interesting thing: in the LO Preferences under Language
Settings/Languages, the settings I have are:

Language Of:
  User interface: Default - English (USA)
Formats:
  Locale setting: Default - English (UK)
  Decimal separator key: (ticked) Same as local setting (.)

What's interesting to me is that AFAIK, the decimal separator for both English
(USA) and English (UK) is a period, not a comma.  Yet LO is nevertheless
expecting a comma, not a period, in numbers.

Not sure why that would be.  I considered the possibility that it might be
using the _document's_ language setting, which was originally English (South
Africa).  But changing that to English (USA) did not make a difference. 
Calculations involving numbers with a decimal comma worked, those involving
numbers with a decimal period did not.

Curiouser and curiouser.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200512/6389441f/attachment.htm>