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@lists.freedesktop.org Reporter: rich.li...@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.