[Libreoffice-bugs] [Bug 143182] New: Format Basic function converts string to number irrespective of format string

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Jul 4 14:19:10 UTC 2021


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 at lists.freedesktop.org
          Reporter: mikekaganski at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210704/7950cbb9/attachment.htm>


More information about the Libreoffice-bugs mailing list