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