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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Dec 2 18:23:13 UTC 2019


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

--- Comment #4 from jsd.libreoffice at bvac.co.za ---
Created attachment 156251
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156251&action=edit
Minimal demonstration of decimal point bug

Hi Andreas.  The attached .OTT file demonstrates the issue.  
It includes an explanation as well as screenshots since YMMV, as I suspect the
behaviour depends on the system locale.  Mine is South Africa, where the
decimal separator is a comma, not a period.

For me this problem manifests in 2 ways: (a) with constant fields in the
template itself, as demonstrated here and (b) with values pulled from a
spreadsheet and inserted into the document by a macro.  The second case is hard
to demo in a single file, but I'd say it boils down to the same root cause: the
number will be inserted into the document with a period (not a comma) as the
separator, and consequently calculations that depend on the value will fail.

-- 
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/20191202/33a9696f/attachment-0001.html>


More information about the Libreoffice-bugs mailing list