[Bug 170840] Crash of a macro with as parameter a sum of two matrices comprising non-numerical values

[bugzilla-daemon]

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

--- Comment #4 from jlucsch...@aol.com ---
The conformity test of the parameters passed to the Macro is carried out AFTER
THE END of the execution of the Macro, which is absurd !

I added in the Macro a break of 10s, in case of non-compliant value, to check
this 

Function Som_New2( Liste() ) As Double
        Dim i,d,f As Integer
        Dim s,v As Double

        If Not IsArray(Liste) Then
                Som=0
                Exit Function
        End If

        d=LBound(Liste,1)
        f=UBound(Liste,1)

        For i=d to f
                v=Liste(i,1)
                If( v=Liste(i,1) ) Then
                        s=s+Liste(i,1)
                Else
                        wait(1000)
                End If
        Next i

        Som=s
End Function

In this case, the message #VALUE! appears AFTER the 10s of execution of the
Macro...

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