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

--- Comment #4 from Eike Rathke <er...@redhat.com> ---
Isn't that rather a BASIC error if an expression X/100 results in 100 if X is
Empty? i.e. ignores the Variant *and* the following operator (same with X-100,
for example, the result is 100).

The same behaviour with

Dim X
Sub Main
    print X/100
End Sub

(where Dim X is a so far empty Variant) so how's that supposed to be defined?

FWIW, it can be checked with

Function foo( X )
    If IsEmpty(X) Then
        X = 0
    End If
    foo = X / 100
End Function


Or should we only put Empty if it was a cell range argument, but not for single
cells? What does Excel do?

-- 
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

Reply via email to