[Libreoffice-bugs] [Bug 144038] New: LO BASE numeric properties converted to locale format inside macro

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144038
           Summary: LO BASE numeric properties converted to locale format
                    inside macro
           Product: LibreOffice
           Version: 7.1.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rich.libre at demattio.co.at

Created attachment 174499
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174499&action=edit
Database with a macro example

Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: de-AT (en_US.UTF-8); UI: en-US
Calc: threaded
==================================================================
Have a look at my locale settings above.

No matter, if I use a constant with decimal POINTS or a numeric property of an
object, that numeric values are converted - in my case to German format with
decimal COMMA.
The problem in this case is: I use that kind of values in a SQL statement
inside the macro, which leads to misinterpretation. (see my attached Database
with macro in it.
==================================================================
WORKAROUND: using the "replace" function to replace comma by point.
BUT: I have to handle every possible locale setting
==================================================================
SUGGESTION: Inside a macro the format of numbers should always convert to
internal native format by default. For converting to locale format there should
be a conversion function.

Have a look at the macro in the attachment

-- 
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/20210823/d9ae9f36/attachment.htm>