https://bugs.documentfoundation.org/show_bug.cgi?id=123263
--- Comment #3 from [email protected] ---
I did some tests on Excel VBA. And I was so surprised at how I was
misunderstanding Excel VBA. (please note that the post to LibreOffice Dev ML
has been done before these tests. Also note that VB.NET MAY WORK IN DIFFERENT
WAY)
’---Excel VBA---
Option Explicit
Sub Main()
Dim a(1) As Integer
Dim b() As Integer
b = a
End Sub
’----------------
=> No Error
’---Excel VBA---
Sub Main()
Dim a(1) As Integer
Dim b(1) As Integer
b = a
End Sub
’----------------
=> Error
’---Excel VBA---
Sub Main()
Dim a() As Integer
Dim b() As Integer
b = a
End Sub
’----------------
=> No Error
’---Excel VBA---
Sub Main()
Dim a() As Integer
Dim b As Variant
b = a
End Sub
’------------------
=> No Error
’---Excel VBA---
Sub Main()
Dim a() As Integer
Hoge (a)
End Sub
Function Hoge(x() As Integer) As String
Hoge = "abc"
End Function
’------------------
=> Error
’---Excel VBA---
Sub Main()
Dim a() As Integer
Hoge (a)
End Sub
Function Hoge(x As Variant) As String
Hoge = "abc"
End Function
’------------------
=> No Error
’---Excel VBA---
Sub Main()
Dim a() As Integer
Dim b As Integer
Dim c As Variant
c = a
c = b
End Sub
’------------------
=> No Error
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
