https://bugs.documentfoundation.org/show_bug.cgi?id=143182
Bug ID: 143182
Summary: Format Basic function converts string to number
irrespective of format string
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
In LibreOffice Basic, this call returns "1":
Format("001", "@")
The format string specifies "put the text as is", but the "001" obviously gets
converted to a number before processing.
Note that Format documentation [1] is wrong where it tells "expression: Numeric
expression". In fact, this function argument is Variant, and works with input
like "Bar" as expected, without converting it to 0. (FTR: the method is
specified at [2], implemented in [3], and functionally implemented in [4].)
In VBA, the call above produces the expected "001".
[1]
https://help.libreoffice.org/7.2/en-US/text/sbasic/shared/03120301.html?DbPAR=BASIC
[2]
https://opengrok.libreoffice.org/xref/core/basic/source/runtime/stdobj.cxx?r=fbaf865f#389
[3]
https://opengrok.libreoffice.org/xref/core/basic/source/runtime/methods.cxx?r=4a0b40f1&fi=SbRtl_Format#SbRtl_Format
[4]
https://opengrok.libreoffice.org/xref/core/basic/source/sbx/sbxscan.cxx?r=0771ac00&mo=19326&fi=660#660
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
