[Libreoffice-bugs] [Bug 146112] IsNull must return False when testing object variables (including non-initialized/assigned to Nothing) in VBASupport 1 mode

Wed, 05 Jan 2022 14:51:19 -0800 

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

Rafael Lima <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #1 from Rafael Lima <[email protected]> ---
I can confirm the bug. I tested the following code in LibO Basic:

Sub TestIsnull
    Dim a As Object
    MsgBox IsNull(a)
    Set a = Nothing
    MsgBox IsNull(a)
    a = Array(1, 2, 3)
    MsgBox IsNull(a)
End Sub

It returns True, True and False regardless of VBA support being enabled or not.

However in Excel VBA, the code below returns False in all MsgBox statements.

Sub TestIsnull
    Dim a As Object
    MsgBox IsNull(a)
    Set a = Nothing
    MsgBox IsNull(a)
    Set a = Range("A1")
    MsgBox IsNull(a)
End Sub

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to