[Libreoffice-bugs] [Bug 143192] New: 'Format' Basic function doesn't handle Null values

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143192
           Summary: 'Format' Basic function doesn't handle Null values
           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

Format function's format string takes up to four sections separated by
semicolons. The fourth section is for Null values.

This is defined in SbxValue::Format, which handles SbxNULL values explicitly,
calling SbxBasicFormater::BasicFormatNull. However, calling

> Format(Null)

or

> Format(Null, ";;;""NNN""")

results in "Inadmissible value or data type. Data type mismatch" error.
This works in VBA [1]: the former call returns "", and the latter returns
"NNN".

[1]
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications

-- 
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/20210705/3b917cf1/attachment.htm>