Bug 146113

Summary: Basic's IsNull documentation must mention that it also returns True for object variables that don't refer to an object (not initialized or set to Nothing) - at least in non-VBA mode
Product: LibreOffice Reporter: Mike Kaganski <mikekaganski>
Component: DocumentationAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: himajin100000, olivier.hallot, sokol
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=146112
Whiteboard: QA:needsComment
Crash report or crash signature: Regression By:

Description Mike Kaganski 2021-12-08 06:47:25 UTC
IsNull in LibreOffice Basic, unlike VBA, returns True when an object variable is passed that doesn't refer to a valid object (e.g., just created not yet assigned object, or assigned to Nothing literal). This is a conscious design decision (see tdf#146112), and is widely used [1]. This should be mentioned in the help. (And when bug 146112 is fixed, the VBA mode difference also needs to be reflected in help.)

[1] https://ask.libreoffice.org/t/is-there-are-value-for-a-null-object-in-lobasic/31483/2